ClickHouse MCP vs SQLite (reference, archived)
Both are databases & vector stores MCP servers, and we ran both through the same test (file query, roundtrip) in each app. ClickHouse MCP passed 3 of 3 apps we tested it in; SQLite (reference, archived) passed 0 of 3.
Test results side by side
| ClickHouse MCP | SQLite (reference, archived) | |
|---|---|---|
| Claude Code | Passed 2026-10-23 | Failed 2026-10-15 |
| Cursor | Passed 2026-10-23 | Failed 2026-10-15 |
| Claude Desktop | Not tested yet | Not tested yet |
| ChatGPT (Codex) | Passed 2026-10-23 | Failed 2026-10-21 |
| Tools exposed (protocol check) | 1 tools | — |
| GitHub stars | 889 | 305 |
| License | Apache-2.0 | MIT |
| Last push | 2026-10-15 | 2025-05-28 |
Results from our own harness runs, dated per cell. Stars and last push from GitHub at our last data refresh. We don’t pick a winner here: which one fits depends on your app and setup.
What each does
ClickHouse MCP: ClickHouse's official MCP server: agents can list databases and tables and run SQL queries against your ClickHouse cluster (read-only by default).
SQLite (reference, archived): The original reference SQLite server: run queries on a local SQLite file. Now in the archived reference servers repo.
