How to integrate ClickHouse MCP with Codex

Connect Codex to ClickHouse MCP. Show total user signups for last week, summarize top 5 products by revenue, and more using natural language, with authentication handled for you.

ClickHouse logoClickHouse
Basic

ClickHouse is an open-source, column-oriented database for real-time analytics and big data processing using SQL. Its lightning-fast query performance makes it ideal for handling large datasets and delivering instant insights.

6 Tools

Introduction

Codex is one of the most popular coding harnesses out there. And MCP makes the experience even better. With the ClickHouse MCP integration, Codex can run SQL queries, list databases and tables, and inspect table schemas, all without leaving the terminal or the app, whichever you prefer.

For exact tool slugs and parameter tables, see the tool catalog in the Composio docs.

Also integrate ClickHouse with

Why use Composio?

Apart from a managed and hosted MCP server, you will get:

  • CodeAct: A dedicated workbench that allows GPT to write its code to handle complex tool chaining. Reduces to-and-fro with LLMs for frequent tool calling.
  • Large tool responses: Handle them to minimise context rot.
  • Dynamic just-in-time access to 20,000 tools across 1700+ other Apps for cross-app workflows. It loads the tools you need, so GPTs aren't overwhelmed by tools you don't need.

How to install ClickHouse MCP in Codex

Run the setup command

Run this command in your terminal to add the Composio MCP server to Codex.

Terminal

It will initiate the authentication in a browser window, authorize Codex to access your Composio account.

Composio authentication page

(Optional) Authenticate with OAuth

To authenticate manually, run the login command to open a browser window and authorize Codex to access your Composio account.

bash
codex mcp login composio

Verify the connection

Run codex mcp list to confirm Composio appears as a registered MCP server.

bash
codex mcp list

Codex App

Codex App follows the same approach as VS Code.

  1. Click ⚙️ on the bottom left → MCP Servers → + Add servers → Streamable HTTP:
  2. Fill the header and Key fields with { "x-consumer-api-key" = "ck_*******" }.
  3. The Key is the Composio API key, that you can find on dashboard.composio.dev
  4. Click on Authenticate and authorize Codex to your Composio account and you're all set.
Codex App MCP setup
  1. Restart and verify if it's there in .codex/config.toml
bash
[mcp_servers.composio]
url = "https://connect.composio.dev/mcp"
http_headers = { "x-consumer-api-key" = "ck_*******" }

Try it

Ask Codex for a ClickHouse task. The first time, Composio asks you to connect your ClickHouse account.

For example, ask it to:

  • "Show total user signups for last week"
  • "Summarize top 5 products by revenue"
  • "Insert a new sales record into database"

What is the ClickHouse MCP server, and what's possible with it?

The ClickHouse MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your ClickHouse account. It provides structured and secure access to your databases, tables, schemas, and analytical data, so your agent can discover databases, list tables, inspect schemas, and run SQL queries on your behalf.

  • Database discovery: Have your agent list the databases available in your ClickHouse instance before starting an analysis.
  • Table exploration: Let the agent list tables across your ClickHouse databases to find the data needed for a task.
  • Database schema review: Direct your agent to review a complete database schema, including its tables and optional column definitions.
  • Detailed table inspection: Instruct your agent to examine a table's columns, data types, keys, and optional sample data before writing SQL.
  • SQL query execution: Have your agent run SQL queries and return the results for real-time analytics and big data analysis.

Conclusion

You've successfully integrated ClickHouse with Codex using Composio's MCP server. Now you can interact with ClickHouse directly from your terminal, VS Code, or the Codex App using natural language commands.

Key benefits of this setup:

  • Seamless integration across CLI, VS Code, and standalone app
  • Natural language commands for ClickHouse operations
  • Managed authentication through Composio
  • Access to 20,000+ tools across 1700+ apps for cross-app workflows
  • CodeAct workbench for complex tool chaining

Next steps:

  • Try asking Codex to perform various ClickHouse operations
  • Explore cross-app workflows by connecting more toolkits
  • Build automation scripts that leverage Codex's AI capabilities
TOOLS

Supported Tools

Every ClickHouse action and event your agent gets out of the box.

Execute ClickHouse Query

Execute a SQL query in ClickHouse, including statements that can modify data or schema, and return its results.

Get Database Schema

Get a schema overview of a ClickHouse database, including its tables and optionally their column definitions.

Get ClickHouse Play Interface

Get the ClickHouse Play web user interface for interactive query execution.

Get Table Schema

Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data.

List ClickHouse Databases

List all databases in the ClickHouse instance.

List ClickHouse Tables

List tables in ClickHouse databases.

FAQ

Frequently asked questions

Start with ClickHouse.It takes 30 seconds.

Managed auth, hosted MCP servers, and every ClickHouse tool your agent needs.Free to start.

Start building