We manage OAuth, API Key, token refresh, and scopes, you just build.
Try for FreeCodex is one of the most popular coding harnesses out there. And MCP makes the experience even better. With ClickHouse MCP integration, you can draft, triage, summarise emails, and much more, all without leaving the terminal or app, whichever you prefer.
Composio removes the Authentication handling completely from you. We handle the entire integration lifecycle, and all you need to do is just copy the URL below, authenticate inside Codex, and start using it.
Apart from a managed and hosted MCP server, you will get:
Run the command in your terminal.
This will auto-redirect you to the Rube authentication page.
Once you're authenticated, you will be able to access the tools.
Verify the installation by running:
codex mcp listIf you otherwise prefer to use config.toml, add the following URL to it. You can get the bearer token from rube.app → Use Rube → MCP URL → Generate token
[projects."/home/user/composio"]
trust_level = "untrusted"
[mcp_servers.rube]
bearer_token_env_var = "your bearer token"
enabled = true
url = "https://rube.app/mcp"If you have installed Codex in VS Code.
Then: ⚙️ → MCP Settings → + Add servers → Streamable HTTP:
Add the Rube MCP URL: https://rube.app/mcp and the bearer token.
To verify, click on the Open config.toml
Make sure it's there:
[mcp_servers.composio_rube]
bearer_token_env_var = "your bearer token"
enabled = true
url = "https://rube.app/mcp"Codex App follows the same approach as VS Code.
.codex/config.toml[mcp_servers.composio_rube]
bearer_token_env_var = "your bearer token"
enabled = true
url = "https://rube.app/mcp"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 so your agent can perform ClickHouse operations on your behalf.
You've successfully integrated ClickHouse with Codex using Composio's Rube 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:
Next steps:
