← Back to directory
COMPARE UP TO 4 SERVERS

Compare MCP servers

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

DimensionMCP Server MotherduckSQL analytics and data engineering for AI Assistants and IDEsChEMBL MCP ServerUnofficial MCP server providing advanced access to the ChEMBL chemical database
FMRS60 / 100 · C75 / 100 · B
Reliability7 / 2012 / 20
Security and permissions13 / 2016 / 20
Maintenance12 / 2014 / 20
Documentation15 / 2018 / 20
Setup experience13 / 2015 / 20
Best for
  • Data scientists and analysts needing SQL analytics on local or remote databases
  • Developers wanting AI-assisted data engineering within IDEs
  • Teams needing to quickly explore DuckDB files
  • Users who want to incorporate MotherDuck cloud capabilities
  • 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 want a fully managed remote MCP service without local installation
  • Production environments with strict security requirements (default read-only mode still allows local filesystem access)
  • Third-party access without additional security configurations
  • 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
  • Access to local filesystem (to read DuckDB files or export data)
  • Reads environment variables for MotherDuck tokens and AWS credentials
  • Executes SQL queries in read-only mode by default; write access must be explicitly enabled
  • Optionally switches database connections at runtime (requires --allow-switch-databases)
  • 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
  • If write mode is enabled, data in databases could be modified or deleted
  • By default, when exposed to third parties, local filesystem or sensitive data may be accessed
  • MotherDuck tokens or AWS credentials could be leaked if misconfigured
  • Queries may consume significant resources (memory, CPU) or time out
  • 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, Claude Code, Codex, Gemini CLI, Cursor, VS Code, KiroClaude Desktop
Tools527