Skill UI

A comprehensive guide to high-performance analytical database patterns using ClickHouse. Covers advanced topics including MergeTree engine types (Replacing, Aggregating), efficient query optimization techniques (filtering, window functions), bulk data insertion strategies, and setting up materialized views for real-time analytics. Ideal for data engineers and analysts building OLAP systems.

Generates structured CodeTour `.tour` files in JSON format for detailed, step-by-step code walkthroughs. This tool is essential for onboarding new engineers, conducting architectural reviews, or documenting complex PR changes. It provides a guided narrative that directs users to specific files and line anchors, ensuring a structured and focused learning journey.

This comprehensive guide establishes foundational coding standards and best practices for enhancing code quality, readability, and maintainability across all projects. It covers naming conventions, immutability patterns, error handling, and core design principles like KISS, DRY, and YAGNI, applicable to TypeScript, JavaScript, and React development. Use it when starting a new module or performing code reviews.

Performs multi-baseline counterfactual cost analysis by comparing actual session spending against hypothetical costs generated by fixed, non-optimal models (e.g., always-haiku, always-sonnet). This tool quantifies the financial savings realized by the smart routing mechanism, answering the critical question: 'Is the routing earning its keep?' It is ideal for quarterly cost reviews, setting CI performance gates, and validating routing configurations.

A comprehensive guide to implementing Test-Driven Development (TDD) for Django projects. This skill covers the full Red-Green-Refactor cycle, utilizing pytest, pytest-django, and factory_boy to write robust unit and integration tests for Django models, views, and DRF APIs. Essential for developers aiming to build large-scale, high-quality Python applications.

A comprehensive, library-agnostic checklist covering best practices for Flutter and Dart applications. It guides developers on architectural principles, state management patterns (BLoC, Riverpod, etc.), Dart idioms, performance optimization, and clean code principles, making it invaluable for code reviews.

A comprehensive 7-section readiness report generated for a repository, analyzing key metrics including risk score, test confidence, and publish readiness. It assesses architectural viability, agent topology recommendations, and potential risks, making it essential for pre-mint reviews, CI/CD gating, and detecting architectural drift in large codebases.

This skill generates an enterprise-grade threat model report using the `harness threat-model` command. It categorizes threats across the MCP surface, providing a detailed report including the overall worst severity (clean, low, medium, high) and specific findings. Ideal for pre-launch security reviews and periodic audits when sharing findings with an InfoSec team.

This skill reviews prediction market, basket, oracle, and trading-agent workflows to ensure compliance, safety, data quality, and privacy. It must be run before any workflow handles user portfolio data, venue authentication, API keys, or trade planning to mitigate execution and regulatory risks across multiple domains.

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

This skill executes the final two phases (Refinement and Completion) of the structured SPARC development methodology. It systematically elevates an implemented feature to production-grade quality by performing detailed code reviews (verifying compliance against specifications, architecture, and quality standards), maximizing test coverage (unit, integration, and edge cases), validating performance, and generating comprehensive documentation and traceability matrices. It ensures the feature is fully ready for deployment.

This skill provides a comprehensive, read-only audit of a development workspace, including active repositories, installed plugins, connected services, and environment configurations. It analyzes existing capabilities against best practices to identify functional gaps and recommends the most valuable ECC-native skills, hooks, and workflows needed to enhance the development experience. Ideal for setup planning and architectural reviews.