# ClickHouse

> Use this tool when you need to analyze and optimize database queries, particularly for ClickHouse metadata and parameterized queries. It solves problems related to query performance and plan analysis, providing insights to improve database efficiency. Ideal for use cases involving read-only access to ClickHouse data, where users can input queries and receive output in the form of query plans and performance metrics.

Canonical page: https://skillsregistry.net/skills/io-github-alyiox-mcp-clickhousex  
JSON: https://api.skillsregistry.net/v1/skills/io-github-alyiox-mcp-clickhousex

## Description

Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.

## Trust

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

## Facts

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

## Source

- **Source listing:** [MCP Registry](https://registry.modelcontextprotocol.io/v0/servers/io.github.alyiox%2Fmcp-clickhousex)
- **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": "io-github-alyiox-mcp-clickhousex"
    }
  }
}
```

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