← Back to directory
COMPARE UP TO 4 SERVERS

Compare MCP servers

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

DimensionUniversal DB MCPConnect AI to Your Database with Natural LanguageMCP ClickHouseConnect ClickHouse to your AI assistants
FMRS49 / 100 · D79 / 100 · B
Reliability5 / 2012 / 20
Security and permissions9 / 2018 / 20
Maintenance10 / 2017 / 20
Documentation13 / 2017 / 20
Setup experience12 / 2015 / 20
Best for
  • Developers and data analysts who need to access databases from multiple AI platforms and IDEs using natural language
  • Scenarios requiring connection to diverse databases including Chinese domestic databases
  • Environments that need read-only safe access to prevent accidental modifications
  • Teams already using ClickHouse who want AI assistants to access data directly.
  • Scenarios requiring fast, read-only data queries and schema exploration.
Not for
  • Scenarios that require write operations (INSERT, UPDATE, DELETE) without permission restrictions (read-only by default)
  • Environments with strict security policies that cannot rely on third-party connectors
  • Scenarios requiring write access to the database without explicit opt-in.
  • Production environments with stringent security requirements that avoid default permission settings.
Required permissions
  • Read database connection configuration information
  • Execute SQL queries (read-only by default, can be extended to write with configuration)
  • Access database schema and metadata
  • 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
  • Enabling full write mode could lead to data corruption or loss
  • Database credentials may be stored in plaintext in config files; handle with care
  • Remote access (HTTP) may face unauthorized access risk; use API keys and network security measures
  • 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, Cursor, Windsurf, VS Code, ChatGPTClaude Desktop
Tools94