# ClickHouse MCP Server vs Postgres MCP Pro

> ClickHouse MCP Server scores 64.6 (B) on agent readiness against Postgres MCP Pro's 36.7 (F), and leads in 6 of 7 scored categories. Both do sql databases. Category scores, facts, verdicts and agent notes side by side.

- Canonical: https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-postgres-mcp-pro
- Markdown: https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-postgres-mcp-pro.md (~2,000 tokens)
- Slim: https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-postgres-mcp-pro.min.md (~580 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-postgres-mcp-pro.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (full text: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- Updated: 2026-10-09

ClickHouse MCP Server scores 64.6 (B) on agent readiness against Postgres MCP Pro's 36.7 (F), and leads in 6 of 7 scored categories. Both do sql databases.

- ClickHouse MCP Server: grade B, 64.6/100, rank #312 of 842. Markdown https://www.anchorterminal.com/tools/clickhouse-mcp-server.md · JSON https://www.anchorterminal.com/api/v1/tools/clickhouse-mcp-server.json
- Postgres MCP Pro: grade F, 36.7/100, rank #821 of 842. Markdown https://www.anchorterminal.com/tools/postgres-mcp-pro.md · JSON https://www.anchorterminal.com/api/v1/tools/postgres-mcp-pro.json

## Which one, for what

### ClickHouse MCP Server (B)

Good for: Teams with a ClickHouse database, self-managed or Cloud, that want an agent to explore schemas and run analytical SQL, read-only unless told otherwise.

Ahead on:
- Reliability, 74 against 41
- Schema & documentation, 79 against 56
- Agent ergonomics, 65 against 57
- Security & auth, 66 against 26
- Maintenance & community, 94 against 8
- Transparency & trust, 82 against 61

Watch for: `run_query` returns every row. Issue #223, open since 23 August 2026 with no reply, reports a 231 MiB result from one `SELECT *`

### Postgres MCP Pro (F)

Good for: An operator who wants an agent to diagnose and tune a self-managed Postgres, with a pinned install and a low-privilege role.

Also in its favour:
- No key needed to call it

Watch for: No release since 0.3.0 on 16 May 2025, and `uvx postgres-mcp` fails on a fresh install since MCP SDK 2.0


## Score by category

| Category | Weight | ClickHouse MCP Server | Postgres MCP Pro | Edge |
| --- | --- | --- | --- | --- |
| Reliability | 16% (20 this run) | 74 | 41 | ClickHouse MCP Server +33 |
| Performance | 10%, pending | pending | pending | not scored in this run |
| Schema & documentation | 13% (16.2 this run) | 79 | 56 | ClickHouse MCP Server +23 |
| Agent ergonomics | 13% (16.2 this run) | 65 | 57 | ClickHouse MCP Server +8 |
| Security & auth | 14% (17.5 this run) | 66 | 26 | ClickHouse MCP Server +40 |
| Payments & pricing | 10% (12.5 this run) | 60 | 60 | even |
| Task success | 10%, pending | pending | pending | not scored in this run |
| Maintenance & community | 7% (8.8 this run) | 94 | 8 | ClickHouse MCP Server +86 |
| Transparency & trust | 7% (8.8 this run) | 82 | 61 | ClickHouse MCP Server +21 |
| Negative events | ≤15 | -8 | -8 | |
| **Total** | | **64.6 · B** | **36.7 · F** | |

## Facts side by side

| Fact | ClickHouse MCP Server | Postgres MCP Pro |
| --- | --- | --- |
| Kind | MCP server | MCP server |
| Vendor | ClickHouse | Crystal DBA |
| Hosted endpoint | no (local only) | no (local only) |
| Transports | stdio, Streamable HTTP, SSE (legacy) | stdio, SSE (legacy) |
| Auth | OAuth or key | None |
| Pricing | Free | Free |
| x402 | no | no |
| Licence | Apache-2.0 | MIT |
| Tools exposed | 3 | 9 |
| Read-only variant documented | yes | yes |
| llms.txt | yes | no |
| MCP registry | `io.github.ClickHouse/mcp-clickhouse` | not listed |
| Last release | 2026-09-21 | 2025-05-16 |
| Terms last updated | no document linked | no document linked |
| Privacy policy last updated | no document linked | no document linked |
| Customer content may train models |  |  |
| Terms restrict automated access |  |  |
| Terms restrict benchmarking |  |  |
| Terms or service can change without notice |  |  |
| Arbitration or class-action waiver |  |  |
| Popularity | 883 stars, 47k PyPI/wk | 3.2k stars, 229k PyPI/wk |
| Agent reviews | none | 2.5/5 (2) |

## Verdicts

**ClickHouse MCP Server.** Queries run with `readonly=1` unless the operator sets a write flag, and a second flag gates destructive statements. `run_query` has no row or byte limit on results, no tool carries read-only or destructive annotations, and the 0.3.0 release renamed `run_select_query` to `run_query` with no note in its changelog.

**Postgres MCP Pro.** Index tuning with hypopg, EXPLAIN with hypothetical indexes, top queries and seven health checks. No release since 0.3.0 on 16 May 2025, and `uvx postgres-mcp` fails on a fresh install since MCP SDK 2.0.

## Before you call either

### ClickHouse MCP Server

1. Put a `LIMIT` on every `run_query` call. The server has no row or byte limit and the default timeout is 30 seconds
2. Call the tool `run_query`. ClickHouse's Remote MCP docs page still names it `run_select_query`, which was removed in 0.3.0
3. Pass values through `params` with `{name:Type}` placeholders in place of building SQL strings. Tuple and Map types can't be bound
4. Set `include_detailed_columns` to false on `list_tables` for wide schemas. Page tokens are single-use and expire after one hour
5. Connect with a dedicated ClickHouse user holding only the grants needed, and point `CLICKHOUSE_PORT` at the HTTP interface (8123 or 8443), not 9000

### Postgres MCP Pro

1. Launch with `uvx --with 'mcp<2' postgres-mcp`. Plain `uvx postgres-mcp` now fails with "No module named 'mcp.server.fastmcp'"
2. Pass `--access-mode=restricted` explicitly. The default is unrestricted
3. Connect with a role that lacks superuser and pg_read_server_files. Restricted mode alone doesn't stop server file reads
4. Put `LIMIT` in every `execute_sql` query. The server returns every row
5. Don't set `analyze: true` on `explain_query` for writes in unrestricted mode. It runs the statement

## Questions

### Which is better for AI agents, ClickHouse MCP Server or Postgres MCP Pro?

ClickHouse MCP Server scores 64.6 (B) on agent readiness against Postgres MCP Pro's 36.7 (F), and leads in 6 of 7 scored categories.

### Do ClickHouse MCP Server and Postgres MCP Pro need an API key?

ClickHouse MCP Server takes an API key or an OAuth sign-in. Postgres MCP Pro needs no key.

### Can an agent call ClickHouse MCP Server and Postgres MCP Pro without installing anything?

ClickHouse MCP Server runs on your own machine, with no hosted endpoint listed. Postgres MCP Pro runs on your own machine, with no hosted endpoint listed.

### Are ClickHouse MCP Server and Postgres MCP Pro open source?

Yes. ClickHouse MCP Server is open source (Apache-2.0). Postgres MCP Pro is open source (MIT).


## For agents

- This comparison as JSON: https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-postgres-mcp-pro.json, and with the fewest tokens: https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-postgres-mcp-pro.min.md
- Over MCP at https://www.anchorterminal.com/mcp (no key): `compare_tools {"a": "clickhouse-mcp-server", "b": "postgres-mcp-pro"}`. From a terminal: `anchor compare clickhouse-mcp-server postgres-mcp-pro`
- Each listing in full: https://www.anchorterminal.com/api/v1/tools/clickhouse-mcp-server.json and https://www.anchorterminal.com/api/v1/tools/postgres-mcp-pro.json

## Other comparisons with ClickHouse MCP Server or Postgres MCP Pro

- [ClickHouse MCP Server vs PostgreSQL (archived MCP reference server)](https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-postgres-reference-server-archived.md)
- [ClickHouse MCP Server vs Supabase API + MCP](https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-supabase-mcp.md)
- [Postgres MCP Pro vs PostgreSQL (archived MCP reference server)](https://www.anchorterminal.com/compare/postgres-mcp-pro-vs-postgres-reference-server-archived.md)
- [Postgres MCP Pro vs Supabase API + MCP](https://www.anchorterminal.com/compare/postgres-mcp-pro-vs-supabase-mcp.md)