Use ClickHouse from Claude
Add the ClickHouse connection to a Space that runs Claude, then use it from every channel in that Space.
ConnectorClickHouse
ClickHouse integration for Claude and Codex
Connect ClickHouse once, then control which Spaces can use its approved tools and data without pasting credentials into prompts or threads.
CategoryDeveloper Tools & IT
Use ClickHouse from Codex
Add the ClickHouse connection to a Space that runs Codex, then use it from every channel in that Space.
Use ClickHouse from Sidekick
Connect your own OpenClaw to Sidekick while type.com provides the conversations, permissions, connections, skills, and automations.
Developer Tools & IT
What the ClickHouse connector can do
ClickHouse is a column-oriented database built for fast analytical queries over large volumes of data. Connected to type.com, a data or engineering Space can ask the agent to list databases, inspect a table's schema, or run a SQL query, so analysis happens in a thread the whole team can follow instead of a private terminal.
One connection, many Spaces
Connect ClickHouse once, then decide which Spaces can use it in threads, skills, automations, and coding work.
What teams do with ClickHouse in type.com
Explore an unfamiliar database
List the databases and tables in a ClickHouse instance before writing a query, so a new analyst doesn't have to guess at the schema.
List all databases in our ClickHouse instance, then show me the schema for the events database.
Answer a question with a live query
Run a SQL query against ClickHouse and get results back in the thread, instead of switching to a separate SQL client.
Run a ClickHouse query that counts signups by day for the last 30 days.
Check a table before building a report
Pull a table's column definitions and sample rows so a report is built against the actual structure, not assumptions.
Get the schema and a few sample rows from the orders table in ClickHouse.
Representative actions
- Execute ClickHouse Query
Runs a SQL query against ClickHouse and returns the results, the main way to pull data out on demand.
- Get Database Schema
Returns an overview of a database's tables and, optionally, their columns, useful for understanding structure before writing queries.
- Get ClickHouse Play Interface
Opens ClickHouse's web-based query interface for interactive exploration outside of a scripted query.
- Get Table Schema
Returns column definitions, types, and keys for a specific table, with optional sample data.
- List ClickHouse Databases
Lists every database in the instance, a starting point before querying any tables.
Connection
API and auth details
ClickHouse provides database and cloud-management APIs for real-time analytics, including SQL over HTTP, native protocol clients, Cloud API service management, OpenAPI/Swagger specs, ClickStack API references, connection guides, server configuration, cloud organization/service automation, and integration with dashboards, MCP tools, and analytical data pipelines.
- Source
- type.com catalog metadata
- Auth schemes
- Basic auth
- API docs
- https://clickhouse.com/docs/en
- Official site
- https://clickhouse.com/
FAQ
Questions people ask before connecting ClickHouse
Can Claude query ClickHouse directly from type.com?
Yes. Once ClickHouse is connected and shared with a Space, the agent can list databases, check table schemas, and run SQL queries, with results posted right in the thread.
How does type.com authenticate with ClickHouse?
ClickHouse is connected with basic authentication. An admin enters the credentials once when creating the connection, and access from there is controlled by which Spaces it's shared with.
Can ClickHouse reports run on a schedule in type.com?
Yes. A recurring query, such as a daily signups count, can be set up as a type.com automation that posts the result to a channel.
Is this the same as an MCP server for ClickHouse?
Not exactly. type.com uses connectors and connections to give selected Spaces access to approved app tools and data. Some connectors use hosted MCP, while others use OAuth, API keys, service accounts, or custom APIs.
More developer tools & it connectors
All Developer Tools & IT integrations
GraphhopperConnect Graphhopper to Claude in type.com to geocode addresses, cluster delivery stops, and pull distance matrices in one thread.
GriptapeConnect Griptape to Claude in type.com to create assistants, start runs, check errors, and manage Griptape Cloud from a thread.
Connect GroqCloud to Claude in type.com to transcribe audio, translate recordings, and generate chat completions from a shared thread.
Connect GTmetrix to Claude in type.com to check test locations, review browser options, and clean up old reports from a shared dev thread.