← Back to directory
COMPARE UP TO 4 SERVERS

Compare MCP servers

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

DimensionMySQL MCP ServerQuery MySQL databases through MCP with read-only defaults.MCP ClickHouseConnect ClickHouse to your AI assistants
FMRS50 / 100 · D79 / 100 · B
Reliability8 / 2012 / 20
Security and permissions10 / 2018 / 20
Maintenance9 / 2017 / 20
Documentation11 / 2017 / 20
Setup experience12 / 2015 / 20
Best for
  • Developers and data teams that need AI-assisted MySQL schema inspection or querying
  • Workflows that prefer read-only database access by default
  • Deployments requiring SSH, SSL/TLS, or PII-redaction capabilities
  • Teams already using ClickHouse who want AI assistants to access data directly.
  • Scenarios requiring fast, read-only data queries and schema exploration.
Not for
  • Environments that do not use MySQL
  • Workflows requiring write access by default without explicit permission configuration
  • Environments unable to provide suitable database credentials or network connectivity
  • 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 configuration for the MySQL host, port, username, password, and database name
  • The database user needs privileges matching the intended queries and any enabled write operations
  • Remote database access may require SSH tunnel configuration
  • When write flags are enabled, the server can perform the corresponding insert, update, or delete operations
  • 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
  • Although read-only by default, enabled write flags can modify or delete data
  • Database credentials are supplied through environment variables and should be protected
  • SQL queries may expose sensitive data; PII redaction can help reduce exposure
  • Misconfigured database privileges, SSL/TLS, or remote access may broaden data exposure
  • 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 CodeClaude Desktop
Tools14