MCP Clickhouse vs Dbridge MCP — MCP Server Comparison | AllMCPs
Side-by-Side Model Context Protocol Comparison
MCP Clickhouse vs Dbridge MCP
In-depth architectural comparison of the MCP Clickhouse and Dbridge MCP MCP servers. Compare execution transports, security boundaries, tool capabilities, quality scores, and ready-to-paste client installation snippets for Claude, Cursor, Windsurf, and VS Code.
At a Glance & Executive Verdict
MCP Clickhouse
Databases · Local stdio
Quality: 65/100 (Great) | Auth: other
Dbridge MCP
Databases · Local stdio
Quality: 57/100 (Good) | Auth: other
Verdict Summary: Choose MCP Clickhouse if you need specialized Databases tools running via a local process. Choose Dbridge MCP if your workspace requires Databases integration with local subprocess execution. Both servers can be configured concurrently in your client's mcpServers manifest.
Which MCP Server Should You Choose?
Choose MCP Clickhouse when:
You need dedicated capabilities in the Databases domain.
You prefer local stdio subprocess transport architecture.
Your security boundary fits: other (Free / Open Source).
ClickHouse database integration with schema inspection and query capabilities
Query SQLite, PostgreSQL, and MySQL in plain language — read-only by design, with column hiding/masking, row caps, per-query timeouts, cost-based rejection, and rate limiting.
List available ClickHouse tables in a database, including schema, comment,
row count, and column count.
Args:
database: The database to list tables from
like: Optional LIKE pattern to filter table names
not_like: Optional NOT LIKE pattern to exclude table names
page_token: Token for pagination, obtained from a previous call
page_size: Number of tables to return per page (default: 50)
include_detailed_columns: Whether to include detailed column metadata (default: True).
When False, the columns array will be empty but create_table_query still contains
all column information. This reduces payload size for large schemas.
Returns:
A JSON-encoded string of an object containing:
- tables: List of table information (as dictionaries)
- next_page_token: Token for the next page, or None if no more pages
- total_tables: Total number of tables matching the filters
run_query
Execute SQL queries in ClickHouse. Queries run in read-only mode by default. Set CLICKHOUSE_ALLOW_WRITE_ACCESS=true to allow DDL and DML operations. Set CLICKHOUSE_ALLOW_DROP=true to additionally allow destructive operations (DROP, TRUNCATE).
Dbridge MCP Tools (11)
Ready-to-Paste Client Configurations
Paste either (or both) of these JSON server blocks into your client config file (e.g. claude_desktop_config.json or ~/.cursor/mcp.json).
MCP Clickhouse is categorized under Databases and uses a local stdio subprocess. In contrast, Dbridge MCP belongs to Databases using local stdio subprocess. Select MCP Clickhouse when you need capabilities focused on databases and Dbridge MCP when you require tools for databases.
Return a table's columns, primary key, foreign keys, and row-count estimate.
sample_table
Preview the first rows of a table (`json`/`csv`/`markdown`).
count_rows
Return the exact row count of a table.
run_query
Run a single read-only `SELECT` / `WITH` and return rows as `json`, `csv`, or `markdown`.
explain_query
Return a query's plan and estimated cost without running it.
column_stats
Per-column distinct-value counts and null fractions — is this column selective enough to index?
index_health
List indexes with sizes and scan counts, flagging unused, duplicate, and invalid ones.
test_index
Simulate a `CREATE INDEX` without building it and report whether the planner would use it (PostgreSQL, via [hypopg](https://github.com/HypoPG/hypopg)).
slow_queries
The most expensive recorded statements with call counts and timings (PostgreSQL `pg_stat_statements`, MySQL `performance_schema`).
get_limits
Report the safety limits in effect (caps, timeouts, hidden/masked columns).