# clickhouse-mcp-server

> Use this tool when you need to interact with ClickHouse databases via MCP protocol, to list databases and tables, or execute safe queries like SELECT, SHOW, and DESCRIBE. It solves problems of secure data retrieval and database exploration, providing a controlled interface for querying ClickHouse databases. The tool accepts MCP requests as input and returns query results as output, ideal for use cases requiring secure and limited database access.

Canonical page: https://skillsregistry.net/skills/ahmedrowaihi-clickhouse-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/ahmedrowaihi-clickhouse-mcp-server

## Description

Enables interaction with ClickHouse databases via MCP, providing tools to list databases and tables and execute safe SELECT, SHOW, and DESCRIBE queries.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/pdiv0jiksf)
- **Repository:** <https://github.com/ahmedrowaihi/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": "ahmedrowaihi-clickhouse-mcp-server"
    }
  }
}
```

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