Get answers from your ClickHouse data, in Claude, ChatGPT or Cursor

Ask "what were the top pages by unique visitors yesterday?" and your assistant queries ClickHouse for the real numbers. SaturnSQL's hosted MCP server works with ClickHouse Cloud and self-hosted servers, no local process to run.

ClaudeMCP · clickhouse
You
What were the top pages by unique visitors yesterday?
execute_query
SELECT path, uniqExact(visitor_id) AS visitors
FROM events
WHERE event_date = yesterday()
GROUP BY path
ORDER BY visitors DESC
LIMIT 3;
pathvisitors
/pricing4812
/3977
/docs2150
Claude
/pricing had the most unique visitors yesterday, about 4.8k.

Setup

1. Add your ClickHouse connection in SaturnSQL. ClickHouse Cloud connects over HTTPS on port 8443, self-hosted servers over the HTTP interface on 8123, directly or through an SSH tunnel.

2. Click your name in the sidebar, then Install MCP, and pick your client: Claude, ChatGPT, Cursor or Claude Code. You add https://mcp.saturnsql.com/mcp and sign in with your SaturnSQL account, with no API key to copy.

What it can do

The connector gives your assistant six tools: list your connections, read a schema (tables, columns and foreign keys), run SQL, run a saved query from your team's library, save a new query back to that library, and export a result to CSV. Queries run through the same read-only validation and row limits as the SaturnSQL editor, and billing, users and account settings are never reachable.

It works with PostgreSQL, MySQL and MariaDB, SQL Server, Oracle, Amazon Redshift, ClickHouse, BigQuery and DynamoDB. Your database password stays encrypted in SaturnSQL; the assistant only ever sees results.

Why not run a ClickHouse MCP server yourself?

Self-hosted ClickHouse MCP servers work in Claude Desktop but need a local process and a password in a config file, and they do not reach ChatGPT or Claude on the web. SaturnSQL reuses the connection you already set up, applies row limits so a wide scan cannot flood the chat, and keeps saved queries in your team's library.

Common questions

What plan do I need? The MCP server is included on SaturnSQL Starter and above. The free plan can try the editor, but it cannot connect an AI client.

Does the assistant see my database password? No. The connection and its credentials stay encrypted in SaturnSQL. Your AI client signs in with your SaturnSQL account and only receives query results.

Can it change or delete data? No. Queries go through the same read-only validation and row limits as the SaturnSQL editor. For defense in depth, connect with a read-only database user as well.

Does it work with ClickHouse Cloud and self-hosted ClickHouse? Yes. ClickHouse Cloud connects over HTTPS on port 8443 and self-hosted servers over the HTTP interface, usually port 8123, with an SSH tunnel if the server is private.

Other databases and clients

The same server connects PostgreSQL, MySQL and MariaDB, SQL Server, Oracle, Amazon Redshift, ClickHouse, BigQuery and DynamoDB. Setting up a specific assistant? See Claude, ChatGPT, Cursor and Claude Code.

Get answers from your ClickHouse data