# ClickHouse Database

> Use this tool when you need to securely interact with ClickHouse databases, retrieve data, or execute SQL queries while preventing data modification. It solves problems in data analysis workflows by providing a controlled interface for exploring and querying databases. The tool takes environment variables or command-line arguments as input and returns query results in JSON format, making it ideal for read-only data analysis use cases.

Canonical page: https://skillsregistry.net/skills/dubin555-clickhouse  
JSON: https://api.skillsregistry.net/v1/skills/dubin555-clickhouse

## Description

ClickHouse MCP Server enables AI assistants to securely interact with ClickHouse databases through a controlled interface. Built by dubin555, it provides tools for listing tables, reading data, and executing SQL queries while implementing security checks to prevent dangerous operations like INSERT, UPDATE, or DELETE. The server connects to ClickHouse using environment variables or command-line arguments, exposes database schema as resources with detailed table and column descriptions, and returns query results in JSON format. This implementation is particularly valuable for data analysis workflows where users need to explore and query ClickHouse databases without risking data modification.

## Trust

- **Trust score (0–1):** 0.83
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-19

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/dubin555-clickhouse)
- **Repository:** <https://github.com/dubin555/clickhouse_mcp_server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "dubin555-clickhouse"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/dubin555-clickhouse` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/dubin555-clickhouse/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt