M
MCP Directory CURATED DIRECTORY
911 MCP servers indexed
中文
← 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 IDEsMCP ClickHouseConnect ClickHouse to your AI assistantsChEMBL MCP ServerUnofficial MCP server providing advanced access to the ChEMBL chemical database
FMRS60 / 100 · C79 / 100 · B75 / 100 · B
Reliability7 / 2012 / 2012 / 20
Security and permissions13 / 2018 / 2016 / 20
Maintenance12 / 2017 / 2014 / 20
Documentation15 / 2017 / 2018 / 20
Setup experience13 / 2015 / 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
  • 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 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
  • 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
  • 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)
  • 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
  • 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
  • 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, Claude Code, Codex, Gemini CLI, Cursor, VS Code, KiroClaude DesktopClaude Desktop
Tools5427