← Back to directory
COMPARE UP TO 4 SERVERS

Compare MCP servers

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

DimensionDBMCP Database MCP ServerSingle-binary SQL database MCP server with built-in PII redaction and write-preventionMCP ClickHouseConnect ClickHouse to your AI assistantsChEMBL MCP ServerUnofficial MCP server providing advanced access to the ChEMBL chemical database
FMRS67 / 100 · C79 / 100 · B75 / 100 · B
Reliability9 / 2012 / 2012 / 20
Security and permissions15 / 2018 / 2016 / 20
Maintenance13 / 2017 / 2014 / 20
Documentation17 / 2017 / 2018 / 20
Setup experience13 / 2015 / 2015 / 20
Best for
  • Users who need safe, read-only AI access to SQL databases
  • Teams with data-privacy requirements needing PII redaction
  • Developers wanting a zero-dependency, single-binary deployment
  • Environments using multiple database backends
  • Teams already using ClickHouse who want AI assistants to access data directly.
  • Scenarios requiring fast, read-only data queries and schema exploration.
  • Drug discovery and computational chemistry researchers
  • Bioinformatics teams needing ChEMBL data through AI assistants
  • Developers comfortable with Node.js or Docker
Not for
  • Users who cannot supply or configure database credentials
  • Users expecting unrestricted write access without understanding write-mode risks
  • Users of databases other than MySQL/MariaDB, PostgreSQL, or SQLite
  • Scenarios requiring write access to the database without explicit opt-in.
  • Production environments with stringent security requirements that avoid default permission settings.
  • Production settings requiring official ChEMBL support (this is unofficial)
  • Users without a Node.js or Docker environment
  • General database tasks unrelated to ChEMBL
Required permissions
  • Requires database host, port, username, and password (DB_PASSWORD treated as a secret)
  • Read-only by default; disabling it lets the AI execute writes, and create/drop databases and tables
  • SSL/TLS connections require DB_SSL_CA/CERT/KEY certificate paths
  • Optional NER redaction requires a local ONNX model directory
  • Requires read-only access to ClickHouse database (default).
  • Optional: write access via CLICKHOUSE_ALLOW_WRITE_ACCESS.
  • Optional: destructive operations via CLICKHOUSE_ALLOW_DROP.
  • Outbound network access to https://www.ebi.ac.uk/chembl/api/data
  • Read-only access to public API data; no authentication credentials required
Risks and side effects
  • With read-only mode disabled, the AI can modify or delete data directly, including dropDatabase/dropTable
  • PII redaction is off by default; sensitive data in query results goes to the LLM unredacted unless enabled
  • Regex redaction is not foolproof, and ML/NER detection depends on model quality; v1 is English-only
  • HTTP mode may expose database access if allowed-origins/allowed-hosts are misconfigured
  • EXPLAIN ANALYZE actually executes the query, so beware of side effects and cost
  • 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.
  • Unofficial project with license marked NOASSERTION (README claims MIT); verify licensing yourself
  • Data accuracy depends on the ChEMBL REST API and the server's parsing may contain defects
  • 30-second request timeouts may constrain large batch queries
  • README inconsistency on tool count (22 vs 27) raises documentation reliability concerns
Supported clientsClaude Desktop, Cursor, Claude CodeClaude DesktopClaude Desktop
Tools13427