What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the ClickHouse MCP server?
Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.
How to install ClickHouse
Copy-paste configuration for popular MCP clients.
MCP_CLICKHOUSE_DSNsecretOptional shortcut DSN for the default profile, for example http://user:password@host:8123/database. For multiple profiles, use ~/.config/mcp-clickhousex/config.json or MCP_CLICKHOUSE_PROFILES_<NAME>_DSN.
{
"mcpServers": {
"mcp-clickhousex": {
"command": "uvx",
"args": [
"mcp-clickhousex"
],
"env": {
"MCP_CLICKHOUSE_DSN": "<YOUR_MCP_CLICKHOUSE_DSN>"
}
}
}
}Related MCP servers

Local RAG MCP for markdown documentation. Retrieval only; host synthesizes answers.

Microsoft SQL Server
Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.

OpenAPI Services
MCP server that fronts any OpenAPI service: discover operations from its spec and call them

MCP server for Walmart Connect Ads, Sam's Club Sponsored Ads, and Walmart Marketplace APIs