MCP serverlar / mcp-clickhouse
mcp-clickhouse
Oxirgi 5 ta yangilanishning 4 tasi agent o'qiydigan narsani o'zgartirdi: 5 ta tool tavsifi qayta yozilgan, 0.7.0 gacha.
PyPI paketi · oxirgi marta 2026-yil 13-noyabr kuni soxta sozlamalar bilan toza mashinada yozib olingan; faqat tools/list yuborilgan. O'zgargan tavsif zaiflik emas. PyPI sahifasi · Usul va cheklovlar · bu ma'lumot JSON ko'rinishida.
Relizma-reliz
0.5.0 → 0.6.0
minor reliz, 2026-yil 3-sentabrlist_databases: kiritma sxemasi o'zgardi
list_tables: tavsif va kiritma sxemasi o'zgardi
run_query: kiritma sxemasi o'zgardi
0.4.1 → 0.5.0
minor reliz, 2026-yil 1-sentabrlist_tables: tavsif va kiritma sxemasi o'zgardi
run_query: tavsif o'zgardi
0.4.0 → 0.4.1
patch reliz, 2026-yil 17-iyulBirorta tool ta'rifi o'zgarmadi.
0.3.0 → 0.4.0
minor reliz, 2026-yil 3-iyunlist_databases: sarlavha, annotatsiyalar yoki chiqish sxemasi o'zgardi
list_tables: tavsif o'zgardi
run_query: sarlavha, annotatsiyalar yoki chiqish sxemasi o'zgardi
Sinalgan relizlar: 0.3.0 (2026-04-14); 0.4.0 (2026-06-03); 0.4.1 (2026-07-17); 0.5.0 (2026-09-01); 0.6.0 (2026-09-03); 0.7.0 (2026-09-21).
0.7.0 dagi tool'lar
Pin — tool nomi, tavsifi va kiritma sxemasining SHA-256 qiymati, verfy.lock uni shunday yozadi. Lock'ingizda xuddi shu pin bo'lsa, agentingiz aynan shu ta'rifni o'qiydi. Verfy 0.16.0 va yangilari server yuborsa, tool sarlavhasi, annotatsiyalari va chiqish sxemasini ham qotiradi, shuning uchun bunday tool'ning lock'ingizdagi pin'i boshqacha bo'ladi.
| Tool | Tavsif | Pin |
|---|---|---|
| list_databases | List available ClickHouse databases | c457a294b7a2 |
| list_tables | List available ClickHouse tables in a database, including schema, comment, row count, and column count. Integers outside [-9007199254740991, 9007199254740991] in table metadata are returned as decimal strings. Pagination tokens are single-use and retained for up to one hour. | 53815e4b864d |
| run_query | Execute SQL queries in ClickHouse. Queries run in read-only mode by default. Bind optional params by name with {name:Type} placeholders, such as {name:String} or {vector:Array(Float32)}. Values may be JSON scalars, nulls, or arrays. Pass exact large integers as decimal strings. JSON lists and objects cannot bind to Tuple and Map types. Python percent formatting and $name$ raw binary parameters are not supported. Parameter values stay out of the MCP server's normal SQL log lines, but may appear in errors and backend logs. Set CLICKHOUSE_ALLOW_WRITE_ACCESS=true to allow DDL and DML operations. Set CLICKHOUSE_ALLOW_DROP=true to additionally allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE TABLE/PARTITION, CREATE OR REPLACE, CLEAR COLUMN/INDEX/PROJECTION, DETACH PERMANENTLY). That gate is a best-effort accident guard, not a security boundary. Integers outside [-9007199254740991, 9007199254740991] are returned as decimal strings. Two optional checks also run through this tool. Use DESCRIBE (<query>) when you need a query's output columns and types; it inspects the result schema and surfaces analysis errors such as an unknown column, but a query that describes cleanly can still fail at runtime. Consider EXPLAIN ESTIMATE <query> before a SELECT that could be expensive; it returns the estimated parts, rows and marks read from MergeTree family tables, which is not run time and not result size. Neither runs the query body, though analysis can execute scalar subqueries. | ba37d9a7c1c2 |
Bu tool'larni qotiring
mcp-clickhouse bugun sizga beradigan narsani qotiring, lock'ni commit qiling, va tool o'zgarganda pull request oldingi va keyingi matn bilan yiqiladi. MCP sozlamangizdagi paket versiyasini ham qotiring.
$ pip install verfy
$ verfy lock check --update # har bir tool'ni ko'rsatadi, keyin verfy.lock ni yozadi
$ git add verfy.lock# .github/workflows/verfy.yml, actions/checkout dan keyin
- uses: verfy-dev/verfy-action@v1Bu serverni yuritasizmi? O'z relizlaringizda xuddi shu tekshiruvni ishga tushiring va README'ga Locked by Verfy belgisini qo'shing.