# ClickHouse MCP Server vs ReqRes MCP server (slim)

> ClickHouse scores 68.8 (B) to ReqRes's 48.8 (D) for databases. Prices, MCP, x402, uptime and agent notes side by side.

- Full: https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-reqres-mcp.md (~4,750 tokens) · this version ~2,880 tokens · JSON https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-reqres-mcp.json · canonical https://www.anchorterminal.com/compare/clickhouse-mcp-server-vs-reqres-mcp
- Index: https://www.anchorterminal.com/llms.txt · API: https://www.anchorterminal.com/api/v1/index.json · MCP: https://www.anchorterminal.com/mcp · Updated: 2026-11-07
- Licence: CC BY 4.0, credit Anchor Terminal and link this page (https://www.anchorterminal.com/terms/#data)

ClickHouse MCP Server scores 68.8 (B) on agent readiness against ReqRes MCP server's 48.8 (D), and leads in 6 of 7 scored categories. ReqRes MCP server leads on agent ergonomics. Both do databases.

- ClickHouse MCP Server: B 68.8, rank #267 of 1510 · https://www.anchorterminal.com/tools/clickhouse-mcp-server.min.md
- ReqRes MCP server: D 48.8, rank #1114 of 1510 · https://www.anchorterminal.com/tools/reqres-mcp.min.md
- ClickHouse MCP Server, 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 30; Schema & documentation, 79 against 61; Security & auth, 66 against 33; Payments & pricing, 60 against 50; Maintenance & community, 84 against 50; Transparency & trust, 82 against 47. Also Runs on your own machine; Open source.
- ReqRes MCP server, good for Coding agents that need a throwaway or starter backend for a prototype, with no account to set up. Ahead on Agent ergonomics, 76 against 65. Also No key needed to call it; A hosted endpoint, with nothing to install; No incidents deducted, where ClickHouse MCP Server loses 3 points for them.

| Category | ClickHouse MCP Server | ReqRes MCP server |
| --- | --- | --- |
| Reliability (16%) | 74 | 30 |
| Performance (10%) | pending | pending |
| Schema & documentation (13%) | 79 | 61 |
| Agent ergonomics (13%) | 65 | 76 |
| Security & auth (14%) | 66 | 33 |
| Payments & pricing (10%) | 60 | 50 |
| Task success (10%) | pending | pending |
| Maintenance & community (7%) | 84 | 50 |
| Transparency & trust (7%) | 82 | 47 |

| Fact (where they differ) | ClickHouse MCP Server | ReqRes MCP server |
| --- | --- | --- |
| Vendor | ClickHouse | ReqRes |
| Hosted endpoint | no (local only) | `https://reqres.in/mcp` |
| Transports | stdio, Streamable HTTP, SSE (legacy) | Streamable HTTP |
| Auth | OAuth or key | None |
| Pricing | Free | Freemium |
| Licence | Apache-2.0 | none |
| Tools exposed | 3 | 7 |
| Read-only variant documented | yes | no |
| MCP registry | `io.github.ClickHouse/mcp-clickhouse` | `in.reqres/reqres` |
| Last release | 2026-09-21 | none |
| Terms last updated | no document linked | not read yet |
| Privacy policy last updated | no document linked | not read yet |
| Popularity | 883 stars, 47k PyPI/wk | none |
| Agent reviews | 3.3/5 (4) | none |

Why the edge:
- Reliability, ClickHouse MCP Server +44: ClickHouse MCP Server 74 (Scored as local software, since the owner runs it over stdio or its own HTTP listener. Official PyPI package `mcp-clickhouse` and a Docker image on GitHub Container Registry, with Python 3.10 to 3.14 stated (20). The CI workflow concluded in success on main on 6 October 2026, on a five-version Python matrix against ClickHouse 26.3, per the 9 October check, not re-read on 2 November since GitHub's pages and API answer 403; main has since taken only dependency bumps and documentation (25). Three open issues and five open pull requests per the 9 October check. Issue #223 on unbounded `run_query` results had been open since 23 August 2026 with no reply, and #155 on per-user access has ten comments; the clone shows no fix for #223 and no annotations from #184 by 26 October (20 of 25). A changelog with a labelled breaking change in 0.5.0 and Compatibility sections in 0.6.0 and 0.7.0, but the changelog file dates only from 14 April 2026, 0.3.0 renamed `run_select_query` to `run_query` without a note, and its entry names environment variables the code does not read (9 of 15). Version 0.7.0, with no stability declaration found (0). 20+25+20+9+0 = 74.); ReqRes MCP server 30 (status.reqres.in wasn't reachable (0). No history (5). Free-plan limits published with numbers (250 requests a day, 3 collections, 100 records) (15). No retry guidance (0). No SLA found (0). Not labelled beta (10). 0 + 5 + 15 + 0 + 0 + 10 = 30.)
- Transparency & trust, ClickHouse MCP Server +35: ClickHouse MCP Server 82 (Apache-2.0 (30). Local software that connects only to the configured ClickHouse. The README states where parameter values and SQL text appear in logs, and no telemetry code was found in the 0.7.0 source. Nothing in the README states the absence of telemetry, and the ClickHouse Privacy Policy does not address this software (22 of 30). No deprecation policy. The SSE transport is marked deprecated in 0.6.0 with no removal date, and `run_select_query` was removed in 0.3.0 with no prior notice found (8 of 20). No usage statistics to opt out of on the evidence of the source, though the project does not say so in writing (16 of 20).); ReqRes MCP server 47 (Closed service under readable terms; operating company not named in the parts read (10 of 30). You own your data, unclaimed agent projects are deleted after 72 hours, and the terms say the free service can end with reasonable notice (22 of 30). That notice clause and the 72-hour rule are dated commitments (10 of 20). Subprocessors not found (5 of 20). 10 + 22 + 10 + 5 = 47.)
- Maintenance & community, ClickHouse MCP Server +34: ClickHouse MCP Server 84 (v0.7.0, tagged and released on 21 September 2026, is still the newest release on 2 November, 42 days on (20, was 30, cause time). Three tagged releases since 4 August, 0.5.0 on 1 September, 0.6.0 on 3 September and 0.7.0 (20). Three open issues against a dozen closed between July and October 2026, most with a maintainer reply and a fix version, per the 9 October check. Issue #223 had had no reply in six weeks and pull request #184 has been open since May (20 of 25). Listed in the official MCP registry as `io.github.ClickHouse/mcp-clickhouse`, a GitHub-verified namespace, with 0.7.0 published on 21 September 2026 and marked latest (re-read on 2 November) (15). Dependabot updates merged on 1, 20, 21 and 26 October 2026, a lock file, and a CI matrix that tests the minimum supported driver. `server.json` on main still says 0.6.0 (9 of 10). 20+20+20+15+9 = 84.); ReqRes MCP server 50 (Registry entry in.reqres/reqres updated 16 October 2026 (30). No dated releases found (0). Blog and docs; no changelog (5 of 15). Official registry entry under its own namespace (15). No package to read (0). 30 + 0 + 5 + 15 + 0 = 50. Registry presence read from Anchor Terminal's own daily import of the official MCP registry (/api/v1/registry.json, 6 November 2026), not the registry's API.)
- Security & auth, ClickHouse MCP Server +33: ClickHouse MCP Server 66 (The server holds one ClickHouse user and password, or an X.509 client certificate since 0.7.0, which ClickHouse grants and roles can scope and an admin can revoke. HTTP and SSE require a bearer token or a FastMCP OAuth or OIDC provider by default, and no secret travels in a URL. Every caller shares the one database user unless middleware is written (24 of 30). Queries run with `readonly=1` by default, writes and destructive statements need two separate flags, the server warns when the user's direct grants exceed the flags, and the README tells operators to use a dedicated least-privilege user. The destructive gate is a keyword check the README calls best-effort, and nothing asks for confirmation (17 of 20). Query results reach the model as stored. No injection guidance was found in the README or the docs pages read, and the server's own instructions ask agents to install a skills package (2 of 15). Each query's SQL is logged at INFO, ClickHouse's `system.query_log` records it under the client name `mcp_clickhouse`, and a middleware hook can log tool calls. No per-caller identity reaches ClickHouse (9 of 15). ClickHouse has a valid security.txt (expires 28 July 2027, re-read on 2 November), a Bugcrowd bounty programme, and SOC 2 Type 2 and ISO 27001 on its trust centre. This repository has no SECURITY.md and no published advisories, though 0.3.0 and 0.5.0 carried security fixes (14 of 20). 24+17+2+9+14 = 66.); ReqRes MCP server 33 (No credential to start, and project keys returned by the tool (15 of 30). Writes on the agent's own project only (12 of 20). Every successful result ends with a sponsored message, labelled and 'never written as an instruction', which still puts third-party text in the model's context (3 of 15). No audit log (0). No security programme found (3 of 20). 15 + 12 + 3 + 0 + 3 = 33.)
- Schema & documentation, ClickHouse MCP Server +18: ClickHouse MCP Server 79 (Each tool is built from a typed Python signature, so inputs carry JSON Schema, read from the source since we do not run vendor software. `params` on `run_query` is a free-form object and tools return JSON-encoded strings with no output schema (21 of 25). clickhouse.com serves llms.txt, a docs llms.txt and a Markdown form of each docs page, and the README is Markdown (10). The `run_query` description runs to about 1,500 characters and says what the tool does, how to bind parameters and when to use `DESCRIBE` and `EXPLAIN ESTIMATE`. `list_tables` documents every argument and the response shape. `list_databases` has one line (16 of 20). `page_size` must be greater than 0 and `database` is required, but there are no enums and SQL arrives as one string (9 of 15). The README has worked examples for parameters, pre-run checks with sample error text, and client configuration. No catalogue of error responses was found (10 of 15). Semantic version numbers, tagged releases and a dated changelog, though ClickHouse's Remote MCP docs page still names the removed `run_select_query` tool (13 of 15).); ReqRes MCP server 61 (Seven tools read from tools/list with JSON Schema inputs (25). llms.txt (10). A tool table says what each does (12 of 20). Records and fields are free-form objects (5 of 15). Worked flow on the MCP page, no error docs (6 of 15). Registry 1.0.0, no changelog (3 of 15). 25 + 10 + 12 + 5 + 6 + 3 = 61.)
- Agent ergonomics, ReqRes MCP server +11: ClickHouse MCP Server 65 (Three tools by default and four with chDB, one of them with a long description (25). `list_tables` pages with single-use tokens, filters with `like` and `not_like`, and drops column detail with `include_detailed_columns`. `run_query` has no row or byte limit, and issue #223 reports a 231 MiB result from one query (11 of 20). ClickHouse error codes and messages pass through, timeouts return 'Query timed out after N seconds', and the README shows sample analysis errors. No documented error list (13 of 20). No tool declares `readOnlyHint`, `destructiveHint` or `idempotentHint`, and pull request #184 adding them has been open since 22 May 2026. The metadata tools retry once on connection errors and `run_query` is not retried because a write may have succeeded (6 of 20). `run_query` and `list_tables` each need one argument and defaults are stated. The server is a Python package only (10 of 15).); ReqRes MCP server 76 (Seven compact tools (25). list_records is paginated (15 of 20). No documented errors (3 of 20). Annotated, two read-only, and delete_record marked (18 of 20). No key needed and a plain REST API behind it (15). 25 + 15 + 3 + 18 + 15 = 76.)