All settings use the **MCP_CLICKHOUSE** prefix. **Flat** environment variables (e.g. `MCP_CLICKHOUSE_DSN`) are the straightforward way to configure
If you already use MCP Clickhousex, the mcp clickhousex mcp server is the piece that lets your assistant work with it directly. All settings use the MCP_CLICKHOUSE prefix. Flat environment variables (e.g. MCP_CLICKHOUSE_DSN) are the straightforward way to configure the default profile when you have a single connection. For multiple profiles, the.
@modelcontextprotocol/inspector on npm is all you need. Most clients run it directly, so configuration is a few lines and a restart.
The toolset is worth reading before you wire it up, because it tells you what the integration is really for:
Cursor — The Cursor tool exposed by this serverCodex — The Codex tool exposed by this serverOpenCode — The OpenCode tool exposed by this serverCopilot — The Copilot tool exposed by this serverConfiguration is passed through the environment: MCP_CLICKHOUSE_DSN, MCP_CLICKHOUSE_DESCRIPTION, MCP_CLICKHOUSE_QUERY_MAX_ROWS, MCP_CLICKHOUSE_SNAPSHOT_MAX_ROWS, MCP_TEST_CLICKHOUSE_DSN, MCP_CLICKHOUSE_PROFILES_WAREHOUSE_DSN. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
Plenty of developer tooling servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. MCP Clickhousex's toolset — Cursor, Codex, OpenCode and 1 more — is a fair guide to whether it matches your workflow. It is maintained by alyiox; worth a glance at recent repository activity before you build anything load-bearing on it.
We check each listing at SyncDev against the project's documentation before it goes live — if something here drifts out of date, it is a bug worth reporting.
| Tool | What it does |
|---|---|
| Cursor | The Cursor tool exposed by this server. |
| Codex | The Codex tool exposed by this server. |
| OpenCode | The OpenCode tool exposed by this server. |
| Copilot | The Copilot tool exposed by this server. |
{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": ["mcp-clickhousex"],
"env": {
"MCP_CLICKHOUSE_DSN": "http://default:@localhost:8123/default"
}
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| MCP_CLICKHOUSE_DSN | Endpoint or connection string the server talks to. | Yes |
| MCP_CLICKHOUSE_DESCRIPTION | Configuration value read at startup. | Optional |
| MCP_CLICKHOUSE_QUERY_MAX_ROWS | Configuration value read at startup. | Optional |
| MCP_CLICKHOUSE_SNAPSHOT_MAX_ROWS | Configuration value read at startup. | Optional |
| MCP_TEST_CLICKHOUSE_DSN | Endpoint or connection string the server talks to. | Yes |
| MCP_CLICKHOUSE_PROFILES_WAREHOUSE_DSN | Endpoint or connection string the server talks to. | Yes |
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Microsoft's official browser automation server — drive a real browser through the accessibility tree, no screenshots needed.
GitHub's official server — repos, issues, pull requests, Actions and code security, straight from your assistant.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Local repository surgery — status, diffs, commits, branches and history for any repo on disk.
Timezone sanity for AI — current time anywhere and correct conversions, without the model doing date math.