Clickhouse

ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support

VIEWS

USERS

VERSION

0.1.0(Updated 12h ago)

91VIEWS

1USERS

Install MCP Server

Paste and run this command in your terminal to set up Cursor with MCP

npx @composio/cli add cursor --app clickhousenpx @composio/cli add cursor --app clickhousenpx @composio/cli add cursor --app clickhousenpx @composio/cli add cursor --app clickhousenpx @composio/cli add cursor --app clickhouse

After running the command, restart Cursor to start using the MCP Server.

View Docs

Available Tools

Execute Clickhouse Query

Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.

Get Database Schema

Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. essential for ai agents to understand the complete database structure in a single call.

Get Table Schema

Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. this is essential for ai agents to understand table structure before constructing queries.

List Clickhouse Databases

List all databases in the clickhouse instance. useful for discovering available databases before querying tables.

List Clickhouse Tables

List tables in clickhouse databases. returns information about tables including their engine, size, and row count.

5 actions available