ClickHouse vs MCP Database Doctor
A side-by-side look at the ClickHouse and MCP Database Doctor MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose ClickHouse for databases work as a local process; choose MCP Database Doctor for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose ClickHouse when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: other.
- You have the keys it needs:
MCP_CLICKHOUSE_DSN. - You want tools like
list_profiles, run_query, analyze_query.
Choose MCP Database Doctor when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: No auth required.
- You have the keys it needs:
CONTROL_PLANE_URL. - You want tools like
analyze_query, check_migration, suggest_indexes.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 57/100 · Good | 56/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | No auth required |
| Pricing | Free | Free |
| Required env vars | MCP_CLICKHOUSE_DSN | CONTROL_PLANE_URL |
| Verified owner | Community listing | Community listing |
| GitHub stars | 1 | 0 |
| Directory activity | 3 views 0 installs 0 upvotes | 0 views 0 installs 0 upvotes |
| Tools | 3 | 5 |
| Full listing | View ClickHouse | View MCP Database Doctor |
Tools & capabilities
ClickHouse tools 3
list_profiles[ClickHouse] List configured connection profiles.run_query[ClickHouse] Execute read-only SELECT or SHOW.analyze_query[ClickHouse] Explain read-only SELECT. Indexes names only the keys the plan used; confirm absent keys from system.tables (primary_key, sorting_key, partition_key).
MCP Database Doctor tools 5
analyze_querySQL anti-patterns with severity and recommendationscheck_migrationDestructive DDL, index locking, constraints, rewrite and transaction riskssuggest_indexesConservative DDL candidates; not appliedexplain_planLarge sequential scans, row estimate errors, sort spills, high loopshealth_reportAggregate review of supplied artifacts only
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
ClickHouse
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhousex"
],
"env": {
"MCP_CLICKHOUSE_DSN": "YOUR_MCP_CLICKHOUSE_DSN_HERE"
}
}
}
}
MCP Database Doctor
{
"mcpServers": {
"mcp-database-doctor": {
"command": "npx",
"args": [
"-y",
"mcp-database-doctor"
],
"env": {
"CONTROL_PLANE_URL": "YOUR_CONTROL_PLANE_URL_HERE"
}
}
}
}
Frequently asked questions
ClickHouse is categorized under Databases and uses a local stdio subprocess. MCP Database Doctor belongs to Databases and uses a local stdio subprocess. Pick ClickHouse for databases work and MCP Database Doctor for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
ClickHouse is listed as free. Auth: other. MCP Database Doctor is listed as free. Auth: no auth required. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add clickhouse and mcp-database-doctor as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, ClickHouse has a quality signal of 57/100 (Good) with 3 views, 0 installs and 1 GitHub stars. MCP Database Doctor has 56/100 (Good) with 0 views, 0 installs and 0 GitHub stars.