# ClickHouse MCP - Tools, Setup and Examples | FlyMy.AI > ClickHouse MCP for Claude, Cursor and Codex. Analytics, with 5 actions. Your API key. See setup, examples and pricing. Page: https://flymy.ai/mcp/clickhouse/ MCP / Analytics and data # ClickHouse MCP: analytics ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support. Connect it to Claude, Codex, Cursor or any MCP client through one FlyMy.AI MCP. [Connect ClickHouse](https://flymy.ai/mcp/clickhouse/#connect) [What it can do](https://flymy.ai/mcp/clickhouse/#actions) Your own API key, 5 actions, Analytics and data $ YOUR NEXT RUN Claude Code, Codex, Cursor, Any agent ## Use ClickHouse MCP in your assistant Paste this prompt into Claude Code, Codex, Cursor or any agent. It reads the guide and helps you connect. ``` Read https://flymy.ai/skill.md and https://flymy.ai/mcp/clickhouse.md. Help me connect ClickHouse MCP to this assistant. Then help me run this task: Use ClickHouse to execute query. Ask me for the required inputs first and show the result. ``` [Open FlyMy.AI](https://app.flymy.ai/new-agent) [Download brief](https://flymy.ai/mcp/clickhouse.md) ## What ClickHouse MCP can do 5 actions in the FlyMy.AI catalog, the most used first. Your agent finds them through search_tools and calls the one the task needs. | Action | What it does | |---|---| | [#](https://flymy.ai/mcp/clickhouse/#method-CLICKHOUSE_EXECUTE_QUERY) `CLICKHOUSE_EXECUTE_QUERY` | Execute a sql query in clickhouse and return the results. | | [#](https://flymy.ai/mcp/clickhouse/#method-CLICKHOUSE_GET_DATABASE_SCHEMA) `CLICKHOUSE_GET_DATABASE_SCHEMA` | Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. | | [#](https://flymy.ai/mcp/clickhouse/#method-CLICKHOUSE_GET_TABLE_SCHEMA) `CLICKHOUSE_GET_TABLE_SCHEMA` | Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. | | [#](https://flymy.ai/mcp/clickhouse/#method-CLICKHOUSE_LIST_DATABASES) `CLICKHOUSE_LIST_DATABASES` | List all databases in the clickhouse instance. | | [#](https://flymy.ai/mcp/clickhouse/#method-CLICKHOUSE_LIST_TABLES) `CLICKHOUSE_LIST_TABLES` | List tables in clickhouse databases. | ## Ask your agent Requests to paste as they are. Each one runs on the actions named under it. **“Use ClickHouse to execute query. Ask me for the required inputs first and show the result.”** uses `CLICKHOUSE_EXECUTE_QUERY` **“Use ClickHouse to get database schema. Ask me for the required inputs first and show the result.”** uses `CLICKHOUSE_GET_DATABASE_SCHEMA` **“Use ClickHouse to get table schema. Ask me for the required inputs first and show the result.”** uses `CLICKHOUSE_GET_TABLE_SCHEMA` ## Connect ClickHouse in a minute One MCP for every integration. Add it once, then every MCP in the catalog is a request away. 1. 01 ### Add FlyMy.AI Add the FlyMy.AI MCP to your assistant with one of the commands below and sign in. No key to copy. 2. 02 ### Add your ClickHouse credentials Paste them into the ClickHouse [connection settings](https://app.flymy.ai/mcp-configs#clickhouse) once; they stay with FlyMy.AI, never in a prompt or a chat. - **Base URL** - The base URL of your ClickHouse instance (e.g., http://localhost:8123 or https://your-cluster.clickhouse.cloud:8443) - **Username** - ClickHouse username for authentication (default user is 'default') [Open ClickHouse →](https://clickhouse.com) - **Password** - ClickHouse password for authentication [Open ClickHouse →](https://clickhouse.com) 3. 03 ### Ask Paste a request from this page. Every run shows what it cost. Claude Code ``` claude mcp add --transport http flymyai https://mcp-agents.flymy.ai/mcp ``` Then run /mcp in Claude Code and sign in. Codex ``` codex mcp add flymy --url https://mcp-agents.flymy.ai/mcp ``` Then run codex mcp login flymy to sign in. claude.ai and Claude Desktop ``` https://mcp-agents.flymy.ai/mcp ``` Settings, Connectors, Add custom connector: paste this URL. ## Pay per run FlyMy.AI bills the run: the model and the tool's seconds. Calls go to your own ClickHouse account, under its plan and limits. No seats and no minimum. [See usage pricing →](https://flymy.ai/pricing/) ## More Analytics and data MCPs Product analytics, BI dashboards and databases. ### 21Risk 21RISK is a web application that simplifies working with checklists, audits, and actions, facilitating compliance and risk management processes 9 actions / your API key Link: https://flymy.ai/mcp/21risk/ ### AI or Not AI or Not - detect AI-generated/deepfake image, video, audio or text 5 actions / no setup Link: https://flymy.ai/mcp/aiornot/ ### Amplitude Amplitude analytics: event segmentation, funnels, retention, cohorts 51 actions / your API key Link: https://flymy.ai/mcp/amplitude/ ### Baremetrics Baremetrics subscription analytics: sources, MRR/ARR metrics, customers, subscriptions, plans 8 actions / your API key Link: https://flymy.ai/mcp/baremetrics/ ### Baserow Baserow is an open-source database tool that lets teams build no-code data applications, collaborate on records, and integrate with other services for data... 2 actions / your API key Link: https://flymy.ai/mcp/baserow/ ### beaconcha.in Beaconchain is a platform providing real-time data and analytics for the Ethereum 2.0 Beacon Chain, offering insights into validators, blocks, and network... 2 actions / your API key Link: https://flymy.ai/mcp/beaconchain/ ## Go to the source [ClickHouse in the docs →](https://docs.flymy.ai/mcp/apps/clickhouse), [ClickHouse connection settings →](https://app.flymy.ai/mcp-configs#clickhouse), [ClickHouse website →](https://clickhouse.com), [Every MCP in the catalog →](https://flymy.ai/mcp/#catalog), [Usage pricing →](https://flymy.ai/pricing/) From the FlyMy.AI platform catalog of 2026-11-03: name, description, actions and setup as the platform lists them. Examples are requests to paste, not recorded runs. --- For agents: the FlyMyAI operating guide (sign up, connect, run models, tools and agents) is https://flymy.ai/skill.md, and https://flymy.ai/llms.txt lists the other pages and the documentation.