We manage OAuth, API Key, token refresh, and scopes, you just build.
Try for FreeHermes is a 24/7 autonomous agent that lives on your computer or server — it remembers what it learns and evolves as your usage grows.
This guide explains the easiest and most robust way to connect your ClickHouse account to Hermes. You can do this through either Composio Connect CLI or Composio Connect MCP. For personal use we recommend the CLI, but you won't go wrong with MCP either.
Composio Connect is a consumer offering that lets anyone plug 1,000+ applications directly into their agent harness — including Hermes. It can:
1. Install the Composio CLI
Run the install script directly, or paste https://composio.dev/hermes into your Hermes chat box to have it installed for you.
2. Authenticate
Once the CLI is installed, ask Hermes to authenticate with Composio.
3. Connect to ClickHouse
Ask your agent to connect to ClickHouse, or simply request any ClickHouse-related task. Hermes will prompt you to authenticate and authorize access.
4. Done. You're all set with a new ClickHouse connection.
1. Get your MCP URL and API Key
Go to dashboard.composio.dev and copy your Connect MCP URL and API key.
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.
With ClickHouse connected, Hermes can now act on your behalf whenever it detects a relevant task or you ask it to.
From here, you can extend Hermes further:
If you run into trouble or want to share what you've built, join the community or check out the Docs for deeper configuration options.
