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 | Prisma Postgres MCPShortlist candidate | Redis MCPMCP100 Recommended |
|---|---|---|
| Task fit | ||
| Best for |
|
|
| Not ideal for |
|
|
| Avoid when |
|
|
| Provenance | ||
| Provenance details | First-party MCP reviewed-detail:prisma-postgres-mcp · Publisher source ↗ | First-party MCP Redis · Publisher source ↗ |
| Maintenance | ||
| Maintenance details | Repo: Not documented Package: Not documented | Repo: Sep 21, 2026 Package: Not documented |
| Popularity evidence | ||
| GitHub stars | Not documented | 628 GitHub stars · checked 2026-09-24T04:14:26.347000Z |
| 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 | Hosted HTTP server authenticates through Prisma Console on first use and grants access to the workspace the user selects. | 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 | Prisma Postgres / object-store plan and usage pricing applies. | 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 | Permissions follow the authenticated Prisma workspace/account. Tools include resource creation and access-key management, not just read operations. | 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 | Can read workspace/database metadata and manage Prisma Postgres databases and object-store resources, including permanent bucket deletion. | 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 | High. Permanent deletion, database creation, and credential generation are consequential. Require explicit human confirmation and separation from production where possible. | 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-11 | 2026-07-24 |
| Candidate evidence | 2026-09-11T00:00:00.000Z | 2026-09-24T04:25:05.554391Z |
Popularity, maintenance, fit, permissions, and client support are independent evidence fields.
Read the evidence method →