ClickHouse/mcp-clickhouse

Name: ClickHouse/mcp-clickhouse
Author: ClickHouse

by ClickHouse

Rating

0.0

Votes

score

Downloads

total

Price

Free

No login needed

Works With

Claude CodeCursorWindsurfVS CodeDeveloper tool

About

[](https://pypi.org/project/mcp-clickhouse)

run_query
Execute SQL queries on your ClickHouse cluster.
Input: query (string): The SQL query to execute.
Queries run in read-only mode by default (CLICKHOUSE_ALLOW_WRITE_ACCESS=false), but writes can be enabled explicitly if needed.

list_databases
List all databases on your ClickHouse cluster.

list_tables
List tables in a database with pagination.
Required input: database (string).
Optional inputs:
like / not_like (string): Apply LIKE or NOT LIKE filters to table names.
page_token (string): Token returned by a previous call for fetching the next page.
page_size (int, default 50): Number of tables returned per page.
include_detailed_columns (bool, default true): When false, omits column metadata for lighter responses while keeping the full create_table_query.
Response shape:
tables: Array of table objects for the current page.
next_page_token: Pass this value back to fetch the next page, or null when there are no more tables.
total_tables: Total count of tables that match the supplied filters.

Works with Claude (desktop and mobile), Cursor, Windsurf, VS Code, and any MCP-compatible AI app.

Category: Developer Tools

Don't lose this

Three weeks from now, you'll want ClickHouse/mcp-clickhouse again. Will you remember where to find it?

Save it to your library and the next time you need ClickHouse/mcp-clickhouse, it’s one tap away — from any AI app you use. Group it into a bench with the rest of the team for that kind of task and you can pull the whole stack at once.

⚡ Pro tip for geeks: add a-gnt 🤵🏻‍♂️ as a custom connector in Claude or a custom GPT in ChatGPT — one click and your library is right there in the chat. Or, if you’re in an editor, install the a-gnt MCP server and say “use my [bench name]” in Claude Code, Cursor, VS Code, or Windsurf.

🤵🏻‍♂️

a-gnt's Take

Our honest review

This plugs directly into your AI and gives it new abilities it didn't have before. ClickHouse/mcp-clickhouse. Once connected, just ask your AI to use it. It's completely free and works across most major AI apps. This one just landed in the catalog — worth trying while it's fresh.

Tips for getting started

Tap "Get" above, pick your AI app, and follow the steps. Most installs take under 30 seconds.

Developer Tools