| FMRS | 48 / 100 · D | 79 / 100 · B | 75 / 100 · B |
|---|
| Reliability | 7 / 20 | 12 / 20 | 12 / 20 |
|---|
| Security and permissions | 10 / 20 | 18 / 20 | 16 / 20 |
|---|
| Maintenance | 2 / 20 | 17 / 20 | 14 / 20 |
|---|
| Documentation | 16 / 20 | 17 / 20 | 18 / 20 |
|---|
| Setup experience | 13 / 20 | 15 / 20 | 15 / 20 |
|---|
| Best for | - Teams already on Snowflake who need to study or reproduce a legacy MCP integration for migration purposes
- Developers researching this project's architecture before moving to the official Snowflake MCP Server
| - 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 | - Any new project or production deployment, since the project is officially deprecated with no further fixes or features
- Users unfamiliar with Snowflake RBAC and SQL statement allowlisting who cannot audit the permission configuration themselves
| - 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 valid Snowflake credentials (username/password, PAT, key pair, OAuth, or SSO)
- Server behavior is fully bound by the RBAC permissions of the connecting role, which needs access to the target databases/schemas/warehouses/Cortex services
- Enabling SQL execution or object-management tools requires explicitly allowlisting SQL statement types (Create, Drop, Update, etc.) in the configuration file
| - 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 | - The project is officially marked deprecated and unmaintained, so unresolved security or functional issues may exist — not recommended for new deployments
- Misconfigured sql_statement_permissions or an 'Unknown' statement type set to True can allow destructive SQL (DROP, DELETE, UPDATE) to execute beyond intended scope
- Sensitive credentials (private keys, passwords) are passed via environment variables or CLI arguments, requiring careful protection of the deployment environment
- Programmatic Access Tokens (PATs) do not evaluate secondary roles, forcing a single broadly-privileged role and coarser permission control
| - 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 clients | Claude Desktop, Cursor, fast-agent, Codex, GitHub Copilot | Claude Desktop | Claude Desktop |
|---|
| Tools | 6 | 4 | 27 |
|---|