dockndevai/mcp-clickhouse

Overview

MCP server for ClickHouse that enables exploration, querying, and management through SQL-classification-based security modes and access-control flags. Written in TypeScript, it integrates with MCP clients to provide structured database operations.

Best for

Best for
Developers building MCP-based tools that need secure, controlled ClickHouse access

Use cases

• Expose ClickHouse queries to MCP-enabled assistants
• Enforce role-based access control on database operations
• Manage ClickHouse schemas and data via MCP tools

How to use

Install

claude mcp add clickhouse -e CLICKHOUSE_URL="http://localhost:8123" -e CLICKHOUSE_USER="default" -e CLICKHOUSE_MODE="read-only" -- npx -y @dockndevai/mcp-clickhouse

Tested with

Claude Desktop, Claude Code, Cursor, Windsurf, VS Code, ChatGPT

Notes

MCP server for ClickHouse that enables exploration, querying, and management through SQL-classification-based security modes and access-control flags. Written in TypeScript, it integrates with MCP clients to provide structured database operations.

1 stars on GitHub. Last updated 2026-09-04. Licensed MIT.

Use cases

• Expose ClickHouse queries to MCP-enabled assistants
• Enforce role-based access control on database operations
• Manage ClickHouse schemas and data via MCP tools

Pros

• SQL classification adds a security layer beyond raw query access
• Access-control flags allow granular permission tuning
• TypeScript implementation offers type safety for developers

Cons

• Low adoption (1 star) limits community support and validation
• Security configuration may require careful setup for complex environments
• No evidence of active maintenance or frequent updates

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.