Lightlines
By clickhouse

clickhouse-best-practices

clickhouse10.7k installs

Safer schemas, faster queries, steadier ingestion.

What it does

Guides ClickHouse schema, query, ingestion, and agent-connectivity reviews with prioritized best practices.

When to use it

Use when reviewing ClickHouse connections, schemas, queries, ingestion, engines, or partitioning.

How to use it

It changes how the agent answers ClickHouse questions by checking applicable rules, citing them, and reporting checked rules, findings, and recommendations.

Uses

Security reviews

Not yet reviewed.


What you need · 2

A ClickHouse connection is needed for the live connectivity, schema-discovery, and query-execution workflow.

The CLI connection path can read the ClickHouse password from the environment; the hosted MCP path uses OAuth instead.


Access · 2

This skill

ClickHouse

Read

Reads ClickHouse metadata

ClickHouse documentation

Read

Reads ClickHouse documentation