{"slug":"alyiox/mcp-clickhousex","name":"mcp-clickhousex","description":"A read-only MCP server for ClickHouse that supports metadata discovery, parameterized queries, and query analysis.","category":"database","tags":[],"official":false,"stars":0,"transport":"stdio","install":[{"cmd":"npx -y @modelcontextprotocol/inspector","imports":[]}],"tools":[{"name":"list_profiles","description":"List configured profiles. Each entry includes name and optional description."},{"name":"get_cluster_properties","description":"Get cluster properties and execution limits. Returns ClickHouse server version plus enforced limits (max rows, timeouts) for the profile."},{"name":"run_query","description":"Execute read-only SELECT or WITH … SELECT. One statement; DML, DDL, SET, SYSTEM, and similar are rejected. Returns {data, row_count} where data is an RFC 4180 CSV string. Pass snapshot=true to persist the result to disk and receive {snapshot_uri, row_count} instead; fetch the CSV via the snapshot resource URI. Max-rows cap; overflow sets truncated and row_limit. Same SQL validation as analyze_query."},{"name":"run_show","description":"Execute SHOW introspection statement. One statement per call; INTO OUTFILE rejected. Interactive row limits apply (default 500, hard ceiling 1 000). Same timeout as run_query."},{"name":"analyze_query","description":"Explain read-only SELECT or WITH … SELECT. Returns plan, pipeline, and/or syntax text. Default types plan and pipeline. Uses query timeout and optional database; no max-rows cap unlike run_query."},{"name":"list_databases","description":"List databases. Rows from system.databases visible to the connection."},{"name":"list_tables","description":"List tables and views in a database. Rows from system.tables: name, engine, primary_key, sorting_key, partition_key, total_rows, total_bytes for query planning."},{"name":"list_columns","description":"List columns for a table or view. Rows from system.columns for the resolved database and table."}],"env_vars":[],"auth_type":"none","github":"https://github.com/alyiox/mcp-clickhousex","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}