# ClickHouse

> Use this tool when you need to access and analyze data from ClickHouse databases, providing read-only access for metadata exploration, query execution, and plan analysis. It solves problems related to data discovery, querying, and optimization, and accepts database connection profiles as input, outputting query results and analysis. Ideal for use cases requiring efficient data retrieval and analysis from ClickHouse databases.

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

## Description

This integration provides read-only access to ClickHouse databases, giving AI agents tools for metadata and schema exploration, parameterized query execution, and query plan analysis. It supports multiple connection profiles via DSN configuration.

## Trust

- **Trust score (0–1):** 0.64
- **Verification tier:** scanned
- **Last scanned:** 2026-09-02

## Facts

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

## Source

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

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

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