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 ClickHouseWhat it can do
Your own API key5 actionsAnalytics and data

$ YOUR NEXT RUN

Claude CodeCodexCursorAny 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.AIDownload brief

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.

ActionWhat it does
# CLICKHOUSE_EXECUTE_QUERYExecute a sql query in clickhouse and return the results.
# CLICKHOUSE_GET_DATABASE_SCHEMAGet comprehensive schema overview of an entire database including all tables and optionally their column definitions.
# CLICKHOUSE_GET_TABLE_SCHEMAGet detailed schema information for a specific table including column definitions, types, keys, and optionally sample data.
# CLICKHOUSE_LIST_DATABASESList all databases in the clickhouse instance.
# CLICKHOUSE_LIST_TABLESList 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 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 →
    • Password - ClickHouse password for authentication Open ClickHouse →
  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 →

Go to the source

ClickHouse in the docs →ClickHouse connection settings →ClickHouse website →Every MCP in the catalog →Usage 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.