Anydb MCP vs Redis MCP Server

A side-by-side look at the Anydb MCP and Redis MCP Server MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.

Anydb MCP logoAnydb MCPDatabases · Local subprocess (stdio)One MCP server for five databases — PostgreSQL, MySQL, SQLite, MongoDB and Redis — with named connection profiles, so database passwords never enter the model's context window.59GoodAuth: not declaredRedis MCP Server logoRedis MCP ServerDatabases · Local subprocess (stdio)Read-first Redis MCP: SCAN key explorer, keyspace/TTL/memory/slowlog stats, DBA advisor63GoodAuth: not declared

Verdict: choose Anydb MCP for databases work as a local process; choose Redis MCP Server for databases as a local process. You can also run both side by side in one mcpServers block.

Which MCP server should you choose?

Anydb MCP logoChoose Anydb MCP when

  • You need dedicated capabilities in the Databases domain.
  • You prefer a local stdio subprocess transport.
  • You want tools like db_list, db_query, db_schema.
Explore Anydb MCP

Redis MCP Server logoChoose Redis MCP Server when

  • You need dedicated capabilities in the Databases domain.
  • You prefer a local stdio subprocess transport.
  • You have the keys it needs: REDIS_URL, ALLOW_WRITES, REDIS_COMMAND_TIMEOUT_MS, REDIS_CONNECT_TIMEOUT_MS, REDIS_MAX_KEYS, REDIS_MAX_VALUE_BYTES.
  • You want tools like redis_scan, redis_key_info, redis_get.
Explore Redis MCP Server

Feature & specification comparison

Rows where the two servers differ are marked.

SpecAnydb MCP logoAnydb MCPRedis MCP Server logoRedis MCP Server
CategoryDatabasesDatabases
Quality signal59/100 · Good63/100 · Good
Install commandConfirmedConfirmed
TransportLocal subprocess (stdio)Local subprocess (stdio)
AuthNot declaredNot declared
PricingFreeNot declared
Required env varsNone listedREDIS_URLALLOW_WRITESREDIS_COMMAND_TIMEOUT_MSREDIS_CONNECT_TIMEOUT_MSREDIS_MAX_KEYSREDIS_MAX_VALUE_BYTES
Verified ownerCommunity listingCommunity listing
GitHub stars12
Directory activity 1 views 0 installs 0 upvotes 1 views 0 installs 0 upvotes
Tools57

Tools & capabilities

Anydb MCP tools 5

  • db_listList the connection profiles from the anydb config file (~/.anydb/db.json): name, description, driver, which one is the default, and whether it is read-only. Call this first whenever you do not already know a profile name, then pass the name to the other tools as "profile". The result never contains a connection string, a host, a username or a password -- not masked, absent -- because this text goes into your context window and a config file is writable by anyone who can write files. If there is no config file, use "uri" with the other tools instead.
  • db_queryRun one statement against one database (PostgreSQL, MySQL/MariaDB, SQLite, MongoDB or Redis, inferred from the connection). READ-ONLY BY DEFAULT: writes are refused unless "readOnly" is false, and statements that change schema or privileges additionally require "allowDestructive" to be true. Call db_list and db_schema first so table and column names are not guessed, and prefer "params" over inlining values in "query" so the values never appear in the statement text. Put a LIMIT in every query: results are capped anyway, and a cap you did not ask for is how a table gets silently half-read. MongoDB: "collection" is required and "action" picks the operation -- find, count, distinct, aggregate and explain read; insert, update, updateOne, replace, delete and deleteOne write and need "readOnly": false. Prefer the *One actions: one document, not every match. Redis: "query" is a single command such as GET or SCAN.
  • db_schemaDescribe the structure of a database: tables and their columns for SQL, collections with their indexes for MongoDB, keyspace statistics for Redis. Call it before writing a query so names are not guessed -- it is almost always cheaper than a failed query. Runs read-only introspection statements only, never a statement of yours, and "table"/"collection" are bound as parameters wherever the driver allows rather than pasted into SQL. "detail": "full" adds foreign keys, index definitions, primary and unique constraints, row estimates, and inferred field schemas for MongoDB.
  • db_explainReturn the execution plan for a statement WITHOUT running it. Read-only by construction: the statement is planned and not executed, so this is the safe way to catch a sequential scan over a large table and the cheapest way to find a missing index. ANALYZE variants are refused here on purpose, because "EXPLAIN ANALYZE" runs the statement it plans. MongoDB: pass "collection" and a find filter as "query"; a pipeline cannot be explained, use db_query action "aggregate" with a small limit. Redis has no plans, so this tool refuses it.
  • db_healthAsk the database about itself: reachable or not, server version, the role this server authenticated as, whether that role or the server is read-only, object counts, and this server's pool and cache state. Use it instead of guessing at why a connection or a write failed. Note what "readOnly": false does and does not do: it is a request to THIS server, not a security boundary. The boundary is the database role -- a role holding INSERT will succeed whatever these flags say, and a role without them will fail however many are set.

Redis MCP Server tools 7

  • redis_scanEnumerate keys with cursor-based SCAN -- NEVER the O(N) KEYS command, so this is safe to run against a production instance with millions of keys (SCAN yields the event loop between batches). Returns up to REDIS_MAX_KEYS keys (default 1000) matching an optional glob `match` pattern (e.g. `user:*`, `session:??`). When more keys remain, `truncated` is true and `cursor` is non-'0' -- pass that `cursor` back to continue from where you left off. Optionally filter by value `type` (string/list/set/zset/hash/stream). Within one call duplicate keys are removed; across a resumed scan a key may reappear (SCAN's guarantee is no key present for the whole scan is missed, not that none repeats).
  • redis_key_infoInspect a single key without reading its (possibly huge) value: type, TTL (seconds and ms, -1 = no expiry, -2 = key missing), internal encoding (`listpack`, `hashtable`, `intset`, ...), serialized memory footprint in bytes (MEMORY USAGE), and idle time. Use this before `redis_get` on an unfamiliar key to avoid pulling a multi-megabyte value into context, and to spot big keys / missing TTLs.
  • redis_getRead a key's value, dispatching by type so you get the right shape without knowing the type in advance: string -> the value (byte-windowed at REDIS_MAX_VALUE_BYTES, default 256 KiB, with `truncated` + full `length` when capped); hash -> field/value object; list -> array (LRANGE windowed by `limit`); set -> member array; zset -> [member, score] pairs (ZRANGE WITHSCORES, windowed); stream -> recent entries (XREVRANGE, windowed). Collection reads are capped at `limit` (default REDIS_MAX_KEYS) so a million-element list can't blow out context. The size and `truncated` fields come before the payload, so a host that caps tool results below REDIS_MAX_VALUE_BYTES (Yaw MCP: 100,000 bytes by default) cuts payload, not them. Always read-only.
  • redis_commandRun a single Redis command through the safety gate. Read-only commands (GET, HGETALL, LRANGE, TYPE, TTL, INFO, ...) always run. Mutating commands (SET, DEL, EXPIRE, HSET, ...) require ALLOW_WRITES=1. KEYS is blocked (use redis_scan). Arbitrary-execution commands (EVAL, FUNCTION, SCRIPT, MULTI, MONITOR, SHUTDOWN, CLUSTER, ...) are never exposed, even with ALLOW_WRITES=1 -- the gate is a curated allowlist, not a blanket 'anything when writes are on'. Use this for commands without a dedicated tool; prefer the typed tools (redis_get, redis_scan, redis_key_info) where they exist.
  • redis_healthOne-call health snapshot rolled up from INFO + DBSIZE + recent SLOWLOG: server version and mode, uptime, memory used vs maxmemory + eviction policy, connected clients + blocked clients, ops/sec, keyspace hit/miss ratio, total keys per database (and how many lack a TTL), persistence (RDB/AOF) status, replication role, and the most recent slow commands. Use as a connection sanity check and the first stop in 'why is Redis slow / using so much memory?' triage.
  • redis_slowlogRecent entries from the Redis slow log -- commands that took longer than `slowlog-log-slower-than` microseconds (default 10000 = 10ms). Each entry has the command, execution time in microseconds, a unix timestamp, and the client address/name (Redis 4+). The fastest way to find which specific commands are slow. Read-only (SLOWLOG GET); SLOWLOG RESET would need ALLOW_WRITES and is intentionally not exposed here.
  • redis_advisorRolled-up Redis health lint pass -- one call returns four categories of findings, each with a severity and an actionable fix: - big_keys: sampled keys whose memory footprint or element count is large enough to make operations O(N) and risk blocking the event loop on delete/expire. - missing_ttls: share of sampled keys with no expiry -- the classic 'cache fills up and OOMs' setup. - eviction_pressure: used/maxmemory ratio, active evictions, and the dangerous `noeviction` + no-TTL combination that turns a full instance into failed writes. - fork_latency_risk: long last-fork time, large dataset + active persistence, and failed background saves -- the causes of periodic latency spikes and durability gaps. Keys are sampled via SCAN (never KEYS), so it is safe on a large production instance; the big-key / missing-TTL findings are over the SAMPLE, not the whole keyspace.

Ready-to-paste client configs

Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.

Anydb MCP

mcpServers (Claude Desktop / Cursor)
{
  "mcpServers": {
    "anydb-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "anydb-mcp"
      ]
    }
  }
}

Redis MCP Server

mcpServers (Claude Desktop / Cursor)
{
  "mcpServers": {
    "redis-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/redis-mcp@latest"
      ],
      "env": {
        "REDIS_URL": "YOUR_REDIS_URL_HERE",
        "ALLOW_WRITES": "YOUR_ALLOW_WRITES_HERE",
        "REDIS_COMMAND_TIMEOUT_MS": "YOUR_REDIS_COMMAND_TIMEOUT_MS_HERE",
        "REDIS_CONNECT_TIMEOUT_MS": "YOUR_REDIS_CONNECT_TIMEOUT_MS_HERE",
        "REDIS_MAX_KEYS": "YOUR_REDIS_MAX_KEYS_HERE",
        "REDIS_MAX_VALUE_BYTES": "YOUR_REDIS_MAX_VALUE_BYTES_HERE"
      }
    }
  }
}

Frequently asked questions

Anydb MCP is categorized under Databases and uses a local stdio subprocess. Redis MCP Server belongs to Databases and uses a local stdio subprocess. Pick Anydb MCP for databases work and Redis MCP Server for databases.

Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.

Anydb MCP is listed as free. Redis MCP Server has no declared pricing — check the project's own site. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.

Yes. MCP clients support multiple servers: add anydb-mcp and redis-mcp-server as separate keys in the same mcpServers object, and your assistant will call tools from either one.

On AllMCPs, Anydb MCP has a quality signal of 59/100 (Good) with 1 views, 0 installs and 1 GitHub stars. Redis MCP Server has 63/100 (Good) with 1 views, 0 installs and 2 GitHub stars.