# ClickHouse

> Use this tool when you need to access and analyze large-scale data warehouses, time-series data, or analytics datasets stored in ClickHouse databases. It enables AI assistants to execute queries and retrieve data directly from ClickHouse instances, providing a secure and configurable connection. Ideal for data analysis workflows, this tool allows for seamless data retrieval without leaving the conversation interface.

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

## Description

ClickHouse MCP provides a bridge between Claude and ClickHouse databases, enabling AI assistants to execute queries and retrieve data directly from ClickHouse instances. Built by Alex Novikov, it leverages the official ClickHouse Go client to establish secure connections with configurable authentication options. The implementation is containerized with Docker for easy deployment and includes comprehensive test coverage. This tool is particularly valuable for data analysis workflows requiring access to time-series data, analytics datasets, or large-scale data warehouses stored in ClickHouse without leaving the conversation interface.

## Trust

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

## Facts

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

## Source

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

## 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": "headcrab-clickhouse"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/headcrab-clickhouse` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/headcrab-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