How to connect ClickHouse MCP with ChatGPT

How to connect ClickHouse MCP with ChatGPT

ChatGPT can take action across your apps and files, stay with a project for hours, and turn a goal into finished materials like sheets, slides, and docs, not just answers.

In this guide, I will explain the easiest and most secure way to connect your ClickHouse account to ChatGPT via Composio Connect, so it can show total user signups for last week, summarize top 5 products by revenue, insert a new sales record into database through natural language commands without ever putting your account credentials at risk.

Why use Composio over default connectors?

• Apps with read and write access. Default connectors mostly can read your data. Composio's ClickHouse integration lets ChatGPT take actions like creating drafts, sending updates, labeling records, and more.
• 1,500+ SaaS toolkits out of the box. Composio gives you instant access to a vast catalog of pre-built connectors, from Gmail and Slack to Notion, Linear, and Salesforce.
• One MCP server for every app. Connect any of your applications on demand through a single endpoint, rather than juggling a separate server for each app.
• Smart, context-aware tool loading. Unlike traditional MCP servers that dump every available tool into the LLM context window, Composio searches for and loads only the tools relevant to the task at hand.
• Cross-app automation. Chain actions across multiple apps in a single run - fetch a thread, summarize it in Notion, and post highlights to Slack without leaving the conversation.

Prerequisites

• A ChatGPT account. We will use the ChatGPT desktop app, and the steps are the same on the web.
• Access to the ClickHouse workspace you want to connect.
• Composio plugin.

Note: Composio connects through OAuth. You will be asked to sign in and approve specific permissions. Review the permission screen carefully if you are using a work account.

Step-by-step: Connect ClickHouse to ChatGPT

1. Install the Composio plugin

Click the button. ChatGPT opens the Composio plugin page. Click Install plugin.

Install in ChatGPT

You can also find it inside ChatGPT: go to Settings, open Plugins, search the marketplace for Composio, and click Install plugin.

2. Authenticate

After you install, ChatGPT asks you to authenticate with Composio. Log in and click Allow access to authorize ChatGPT to use your Composio account.

3. Start using Composio

That is it. Composio tools are now available in ChatGPT. Type @Composio followed by your request, for example @Composio find unread ClickHouse messages and summarize them, and it will run the actions you authorize. On first use it asks you to authorize ClickHouse.

Option 2: Add Composio as an MCP server

If you cannot use the plugin marketplace, add Composio as a custom MCP server instead.

1. Open the MCP settings

In ChatGPT, go to Settings and open the Plugins section. Inside the Plugins page, click the MCP tab.

2. Add the server

Click Add server. In the Name field enter Composio, for Type select Streamable HTTP, and in the URL field paste the Composio MCP server URL: