Affaan MustafaTrading lead at Jump Trading; ECC 290k+ stars5,900 installs on skills.shClickhouse Io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for...
Use Edge to load the skill clickhouse-io from affaan-m/ecc for my task. If Edge is not set up, read getedge.cc/SKILL.md and ask me first.
2 static scans, 0 counted findings.
Edge checks it again each time your agent loads it.
What it does
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. Use when writing ClickHouse schemas or queries, or when an analytical query is too slow.
Why Affaan Mustafa
Compute Trading Lead at Jump Trading. Each fact links its public source.
- Role at Jump Trading
His GitHub bio says Compute Trading Lead at Jump Trading, previously founding The Agentic Desk.
GitHub profile - Hugely starred agent harness repo
ECC has 290k+ GitHub stars.
GitHub repo - Security tool with traction
agentshield has 1.3k+ GitHub stars.
GitHub repo
How it works
- 1Copy
Try for free gives you one prompt.
- 2Paste
Paste it into Claude Code, Codex or Cursor.
- 3Ask
Ask for the outcome. Your agent loads Clickhouse Io.
Related skills
MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices. Use when designing PostgreSQL schemas, indexes, or RLS policies, or when a query is too slow.
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing
Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up
Help with MongoDB query optimization and indexing. Use only when the user asks for optimization or performance: "How do I optimize this query?", "How do I index this?", "Why is this query slow?", "Can you fix my slow que
Write raw ClickHouse SQL for a SigNoz dashboard panel: timeseries, value, or table widgets that the builder UI cannot express (custom joins, window functions, regex extraction over log bodies, aggregations beyond builder
No evidence record yet
No measured run with and without this skill yet, so this page makes no performance claim. 2 static scans, 0 counted findings. Security state at 2026-11-17: reviewed. Static scans check the code, not how well the skill works.
State definitionsSelect the Files tab to load SKILL.md.
Skill details
Security scansReviewed
2 static scans, 0 counted findings. Security state at 2026-11-17: reviewed. Edge checks it again each time your agent loads it.
Edge static checks (Edge-run): edge-static/1.0.2. Scope: Static patterns for remote execution, credentials with network sends, obfuscation, prompt overrides, hidden Unicode, binaries and persistence. Raw findings: not supplied.
Edge committed-secret checks (Edge-run): edge-secrets/1.0.0. Scope: Credentials committed in the skill's files (values never shown). Raw findings: not supplied.
Socket (skills.sh mirror): Version unavailable. Scope: Not supplied by the mirrored record. Raw findings: not supplied.
Snyk (skills.sh mirror): Version unavailable. Scope: Not supplied by the mirrored record. Raw findings: not supplied.
- Edge static checks
- Pass · 0 counted findings · 2026-11-17
- Edge committed-secret checks
- Pass · 0 counted findings · 2026-11-17
Creator, source & licenceaffaan-m
From the affaan-m public repository. Edge did not write or edit this skill.
- Repository
- affaan-m/ecc
- Skill file
- View source at revision
- Revision
- d3b8a3e908904e242ed2dbe66af62cca71131419
- Package hash
- sha256:df25864ce3b6c2f75e0a268aea0cfb16a0d5a96f880ba11d1e76fe08c01122a0
- Licence
- MIT
- Description
- ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. Use when writing ClickHouse schemas or queries, or when an analytical query is too slow.
Quoted from the skill’s own description
Read skill files1 file
1 file, 10.5 KB at revision d3b8a3e90890.
Questions about Clickhouse Io
What does Clickhouse Io do?
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for... Published by Affaan Mustafa (affaan-m/ecc).
Is Clickhouse Io safe to use?
Edge security state: Reviewed (2 Edge-run static scans, scanned Nov 17, 2026). The Evidence tab shows the scan.
How do I use Clickhouse Io in Claude Code, Codex or Cursor?
Click Try for free, pick your agent and follow its one step. Edge is free, with no Edge account.
Similar skills

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="…

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that live…

Required reference for Prisma ORM 7 SQL driver adapter work. Use when implementing or modifying adapters, adding database drivers, or touchi…

Search, scrape, crawl, extract structured data, and monitor web pages via the ScrapeGraph AI CLI. Use when the user asks to search the web,…

When the user wants to set up or audit analytics, or asks whether a metric or number is calculated right, what to track, or how to name even…

Google Sheets: Read and write spreadsheets.

End-to-end analytics instrumentation workflow for a PR, branch, file, directory, or feature. Reads the code, discovers what events should be…

Golang data structures — slices (internals, capacity growth, preallocation, slices package), maps (internals, hash buckets, maps package), a…