Deep ClickHouse architecture, pipeline optimization, and Python integration skills for building optimal data warehouses
/plugin marketplace add discreteds/clickhouse-skills
/plugin install clickhouse-skills@discreteds/clickhouse-skills
Design architecturally optimal ClickHouse data warehouses. Use when creating schemas, modeling data, optimizing queries, or making architectural decisions about ClickHouse tables, materialized views, projections, or dictionaries.
Analyze and optimize existing ClickHouse pipelines, schemas, and queries. Use when reviewing ClickHouse performance, auditing table designs, troubleshooting slow queries, or improving data ingestion patterns.
Write Python code to interact with ClickHouse using clickhouse-connect. Use when creating ETL scripts, data pipelines, analytics applications, or any Python code that needs to query or insert data into ClickHouse.
Payload Development plugin - covers collections, fields, hooks, access control, plugins, and database adapters.
Schema validation, data quality monitoring, streaming validation pipelines, and input validation for backend APIs
Database migration automation, observability, and cross-database migration strategies
Database query optimization, cloud cost optimization, and scalability improvements