Field-by-field comparison
Compare the evidence before choosing an MCP.
Each signal stays separate, missing facts remain visible, and the column order follows your selection.
| Evidence field | MotherDuck MCP ServerWatchlist candidate | Redis MCPMCP100 Selected |
|---|---|---|
| Task fit | ||
| Best for |
|
|
| Not ideal for |
|
|
| Avoid when |
|
|
| Provenance | ||
| Provenance details | First-party MCP endpoint:https: · Publisher source ↗ | First-party MCP Redis · Publisher source ↗ |
| Maintenance | ||
| Maintenance details | Stale Repo: Not documented Package: Not documented | Repo: Aug 5, 2026 Package: Aug 5, 2026 |
| Popularity evidence | ||
| GitHub stars | Not documented | 568 GitHub stars · checked 2026-08-14T18:46:26.000Z |
| Package downloads / 30 days | No reliable download data | 22,058 package downloads / 30 days · checked 2026-08-14T18:46:26.000Z |
| Client coverage | ||
| Client coverage details | Not documented | Claude Code✓ Local stdio Claude Desktop✓ Local stdio Codex✓ Local stdio VS Code✓ Local stdio Cursor✓ Local stdio OpenCode✓ Local stdio |
| Client coverage note | Local stdio runs on your computer. Streamable HTTP connects to a remotely hosted MCP server. | |
| Access and data | ||
| Authentication | OAuth-based remote MCP authorization is documented by MotherDuck. | Supports Redis username/password URLs, individual credential options, TLS through `rediss://`, CA certificate verification, cluster mode, and Microsoft Entra ID authentication for Azure Managed Redis. |
| Cost | MotherDuck compute/storage and plan limits apply; MCP access does not imply free query execution. | The first-party server is open source and the PyPI package documents no MCP usage fee. Redis Cloud, infrastructure, network, container, and AI-client costs remain separate. |
| Permissions | MotherDuck documents isolated compute and read-only access by default; any enabled write/pipeline capabilities must follow the authenticated account and server configuration. | The server can read and write Redis keys and data structures, operate streams and pub/sub, manage search indexes, and inspect server information according to the connected Redis user's ACL. Redis ACL configuration is the effective permission boundary. |
| Data handling | Queries run in MotherDuck isolated compute; data accessed is the authenticated MotherDuck/DuckDB data available to that account. | The stdio server runs locally and sends Redis query inputs and returned key values to the connected MCP client. It connects directly to the configured Redis deployment. Credentials can be supplied in a URI, CLI arguments, or environment variables; avoid embedding them in shareable config and logs. |
| Limitations | ||
| Tradeoffs |
|
|
| Risk context | Strong product integration, but MCP-specific operational maturity and write/pipeline governance still need longer evidence for Selected. | A broad Redis tool set can expose or mutate application state, sessions, queues, cached records, and vector data. Use a dedicated database, a narrowly scoped ACL user, verified TLS, pinned releases, and backups. This review does not claim MCP100 execution testing. |
| Evidence date | ||
| Editorial review | 2026-09-13T00:00:00Z | 2026-07-24 |
| Candidate evidence | 2026-09-13T00:00:00Z | 2026-08-14T18:46:26.000Z |
Popularity, maintenance, fit, permissions, and client support are independent evidence fields.
Read the evidence method →