← Back to directory
COMPARE UP TO 4 SERVERS

Compare MCP servers

Compare scores, permissions, risks, and fit in one decision-focused table.

DimensionPare DBStructured database CLI operations as typed JSONMCP ClickHouseConnect ClickHouse to your AI assistants
FMRS32 / 100 · D79 / 100 · B
Reliability4 / 2012 / 20
Security and permissions5 / 2018 / 20
Maintenance7 / 2017 / 20
Documentation6 / 2017 / 20
Setup experience10 / 2015 / 20
Best for
  • AI coding tools that need to interact with PostgreSQL, MySQL, Redis, or MongoDB via typed JSON
  • Scripting and automation workflows involving database operations
  • Teams already using ClickHouse who want AI assistants to access data directly.
  • Scenarios requiring fast, read-only data queries and schema exploration.
Not for
  • Users requiring GUI or complex database administration features
  • Scenarios needing non-standard or specialized database CLIs
  • Scenarios requiring write access to the database without explicit opt-in.
  • Production environments with stringent security requirements that avoid default permission settings.
Required permissions
  • Requires local installation and execution of psql, mysql, redis-cli, or mongosh commands
  • Requires database connection credentials
  • Requires read-only access to ClickHouse database (default).
  • Optional: write access via CLICKHOUSE_ALLOW_WRITE_ACCESS.
  • Optional: destructive operations via CLICKHOUSE_ALLOW_DROP.
Risks and side effects
  • AI agents may execute destructive database operations (e.g., DELETE, UPDATE) if not careful
  • Potential exposure of sensitive data if credentials are present
  • Misconfiguration may lead to database connectivity or permission issues
  • If write access is enabled, AI might make unintended modifications.
  • If DROP access is enabled, data deletion could occur accidentally.
  • Credentials may be exposed via environment variables.
Supported clientsClaude Desktop, Claude Code, CursorClaude Desktop
Tools44