Verfy

MCP serverlar / mcp-clickhouse

MCP tool o'zgarishlari

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.6.0 → 0.7.0

minor reliz, 2026-yil 21-sentabr
run_query: tavsif va kiritma sxemasi o'zgardi; yangi argumentlar: params
Oldin (0.6.0)
Execute SQL queries in ClickHouse. Queries run in read-only mode by default. 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.
Keyin (0.7.0)
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.

0.5.0 → 0.6.0

minor reliz, 2026-yil 3-sentabr

list_databases: kiritma sxemasi o'zgardi

list_tables: tavsif va kiritma sxemasi o'zgardi
Oldin (0.5.0)
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. Args: database: The database to list tables from like: Optional LIKE pattern to filter table names not_like: Optional NOT LIKE pattern to exclude table names page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50, must be greater than 0) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas. Returns: A JSON-encoded string of an object containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters
Keyin (0.6.0)
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.

run_query: kiritma sxemasi o'zgardi

0.4.1 → 0.5.0

minor reliz, 2026-yil 1-sentabr
list_tables: tavsif va kiritma sxemasi o'zgardi
Oldin (0.4.1)
List available ClickHouse tables in a database, including schema, comment, row count, and column count. Args: database: The database to list tables from like: Optional LIKE pattern to filter table names not_like: Optional NOT LIKE pattern to exclude table names page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas. Returns: A JSON-encoded string of an object containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters
Keyin (0.5.0)
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. Args: database: The database to list tables from like: Optional LIKE pattern to filter table names not_like: Optional NOT LIKE pattern to exclude table names page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50, must be greater than 0) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas. Returns: A JSON-encoded string of an object containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters
run_query: tavsif o'zgardi
Oldin (0.4.1)
Execute SQL queries in ClickHouse. Queries run in read-only mode by default. Set CLICKHOUSE_ALLOW_WRITE_ACCESS=true to allow DDL and DML operations. Set CLICKHOUSE_ALLOW_DROP=true to additionally allow destructive operations (DROP, TRUNCATE).
Keyin (0.5.0)
Execute SQL queries in ClickHouse. Queries run in read-only mode by default. 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.

0.4.0 → 0.4.1

patch reliz, 2026-yil 17-iyul

Birorta tool ta'rifi o'zgarmadi.

0.3.0 → 0.4.0

minor reliz, 2026-yil 3-iyun

list_databases: sarlavha, annotatsiyalar yoki chiqish sxemasi o'zgardi

list_tables: tavsif o'zgardi
Oldin (0.3.0)
List available ClickHouse tables in a database, including schema, comment, row count, and column count. Args: database: The database to list tables from like: Optional LIKE pattern to filter table names not_like: Optional NOT LIKE pattern to exclude table names page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas. Returns: A dictionary containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters
Keyin (0.4.0)
List available ClickHouse tables in a database, including schema, comment, row count, and column count. Args: database: The database to list tables from like: Optional LIKE pattern to filter table names not_like: Optional NOT LIKE pattern to exclude table names page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas. Returns: A JSON-encoded string of an object containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters

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.

0.7.0 dagi tool'lar
ToolTavsifPin
list_databasesList available ClickHouse databasesc457a294b7a2
list_tablesList 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_queryExecute 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@v1

Bu serverni yuritasizmi? O'z relizlaringizda xuddi shu tekshiruvni ishga tushiring va README'ga Locked by Verfy belgisini qo'shing.