mcp-server-db
Advanced tools
MCP server exposing Postgres, Redis, Elasticsearch, MySQL, MongoDB, and LDAP as tools, with lazy connection management, retry, circuit breaking, per-connection read-only mode, and optional database drivers.
mcp-server-db is a universal, production-grade Model Context Protocol (MCP) server that empowers AI assistants to interact with Postgres, Redis, Elasticsearch, MySQL, MongoDB, and LDAP through a unified suite of 113+ high-performance tools.
Built with resilience in mind, it features background lazy connection management, exponential backoff retries, circuit breaker patterns, strict read-only security enforcement, and on-demand dynamic driver loading.
pg, ioredis, mongodb, mysql2, @elastic/elasticsearch, ldapts) are dynamically loaded only when a connection to that database engine is initialized.| Database Engine | Default Driver | Supported Versions | Key Features & Guardrails |
|---|---|---|---|
| PostgreSQL | pg (optional) | 10+ | Table/Index stats, Health diagnostics, Session-level read_only, Statement timeouts |
| Redis | ioredis (optional) | 5+ | Key/String/Hash/Set/List operations, Automatic 1000-item result truncation cap |
| Elasticsearch | @elastic/elasticsearch / es7-client | 7.x, 8.x, 9.x | Dual-API version facade (v7 legacy & v8/v9 modern), Cluster health, Query DSL |
| MySQL / MariaDB | mysql2 (optional) | 5.7+, 8.0+ | DDL extraction (SHOW CREATE), Processlist management, Indexes & Triggers, Session read-only |
| MongoDB | mongodb (optional) | 4.4+ | Aggregation pipelines, Distinct queries, Index management, Execution plan explain |
| LDAP | ldapts (optional) | v3 directories (OpenLDAP, AD, etc.) | Search/compare, Add/modify/delete entries, Bulk entry seeding |
When installed globally (npm install -g mcp-server-db) or run via npx -y mcp-server-db, npm automatically includes all supported database drivers (pg, ioredis, @elastic/elasticsearch, mysql2, mongodb, ldapts) out of the box via optionalDependencies.
# Global installation (includes all drivers out of the box)
npm install -g mcp-server-db
# Local project installation
npm install mcp-server-db
If you install mcp-server-db locally using --no-optional to keep your node_modules lightweight, you can install only the specific drivers you need:
# PostgreSQL
npm install pg
# Redis
npm install ioredis
# Elasticsearch
npm install @elastic/elasticsearch # For v8 & v9
npm install es7-client # For v7 legacy
# MySQL / MariaDB
npm install mysql2
# MongoDB
npm install mongodb
# LDAP
npm install ldapts
Add mcp-server-db directly to your MCP client config file (e.g. Claude Desktop, Claude Code, Gemini CLI, Cursor):
{
"mcpServers": {
"mcp-server-db": {
"type": "stdio",
"command": "npx",
"args": ["-y", "mcp-server-db"],
"env": {
"POSTGRES_URL": "postgresql://user:password@localhost:5432/mydb",
"REDIS_URL": "redis://localhost:6379",
"MONGODB_URL": "mongodb://localhost:27017",
"LDAP_URL": "ldap://localhost:389",
"LDAP_BIND_DN": "cn=admin,dc=example,dc=com",
"LDAP_BIND_PASSWORD": "admin-password"
}
}
}
}
Define connection strings in env to start immediately without a configuration file:
POSTGRES_URL=postgresql://user:password@localhost:5432/mydb
REDIS_URL=redis://localhost:6379
ELASTICSEARCH_URL=http://localhost:9200
MYSQL_URL=mysql://user:password@localhost:3306/mydb
MONGODB_URL=mongodb://localhost:27017
LDAP_URL=ldap://localhost:389
LDAP_BIND_DN=cn=admin,dc=example,dc=com
LDAP_BIND_PASSWORD=admin-password
POSTGRES_READ_ONLY=true
REDIS_READ_ONLY=true
MYSQL_READ_ONLY=true
MONGODB_READ_ONLY=true
LDAP_READ_ONLY=true
db_status: Inspect connection states (idle, connecting, connected, retrying, failed, circuit_open), read-only mode, and error logs across all configured databases.db_reload_config: Hot-reload databases.config.yml from disk and reconcile connections dynamically without interrupting active queries.pg_query: Execute read-only SELECT queries (enforces single-statement extended query protocol).pg_execute_sql: Execute write SQL statements (INSERT, UPDATE, DELETE, DDL). Blocked in read-only mode.pg_list_tables: List tables in a target schema.pg_describe_table: Inspect column data types, ordinal position, and nullability.pg_list_schemas: List all database schemas.pg_list_views: List all views in a schema.pg_list_indexes: List indexes and index definitions for a table.pg_list_triggers: List triggers and action statements in a schema.pg_table_stats: Get total size, table size, index size, and estimated row count.pg_list_constraints: List primary keys, foreign keys, and check constraints.pg_explain_query: Inspect query execution plans with EXPLAIN.pg_active_queries: Retrieve running non-idle queries and durations from pg_stat_activity.pg_list_functions: List user-defined functions, arguments, and return types.pg_list_sequences: List sequence objects in a schema.pg_database_info: Get database name, current user, PostgreSQL version, and database size.pg_kill_query: Terminate a running backend process by PID. Blocked in read-only mode.pg_vacuum_analyze: Run VACUUM ANALYZE to update statistics and reclaim dead tuples. Blocked in read-only mode.pg_list_materialized_views: List materialized views in a schema.pg_refresh_materialized_view: Refresh a materialized view (supports CONCURRENTLY). Blocked in read-only mode.pg_index_usage: Inspect index scan counts and tuple fetch statistics.pg_lock_info: Retrieve active database locks and query durations.pg_get_top_queries: Get slow queries from pg_stat_statements.pg_explain_hypothetical_index: Simulate hypothetical index performance using hypopg.pg_database_health: Run health audit (connections utilization, buffer cache hit ratio, dead rows, replication lag).pg_sizes_overview: Breakdown storage sizes for database, tables, and indexes.pg_unused_indexes: Identify zero-scan candidate indexes to drop.pg_duplicate_indexes: Find overlapping or redundant indexes.pg_long_running_queries: Find queries exceeding a duration threshold.pg_missing_indexes: Identify high-sequential-scan tables needing indexes.pg_bloat_estimate: Estimate table bloat ratio based on dead tuple count.redis_get: Get string value at key.redis_set: Set key value. Blocked in read-only mode.redis_mset: Set multiple key/value pairs in a single command (e.g. for seeding). Blocked in read-only mode.redis_del: Delete key. Blocked in read-only mode.redis_keys: List keys matching a glob pattern (capped at 1000 items).redis_ttl: Get remaining TTL in seconds.redis_hget: Get hash field value.redis_hset: Set hash field value. Blocked in read-only mode.redis_hdel: Delete hash fields. Blocked in read-only mode.redis_hgetall: Get all hash fields and values.redis_hexists: Check hash field existence.redis_sadd: Add member to set. Blocked in read-only mode.redis_srem: Remove member from set. Blocked in read-only mode.redis_smembers: List set members (capped at 1000 items).redis_sismember: Test set membership.redis_lpush: Prepend element to list. Blocked in read-only mode.redis_rpush: Append element to list. Blocked in read-only mode.redis_lpop: Remove and return first list element. Blocked in read-only mode.redis_rpop: Remove and return last list element. Blocked in read-only mode.redis_lrange: Get range of list elements (capped at 1000 items).redis_llen: Get list length.redis_exists: Check key existence.redis_expire: Set key expiration in seconds. Blocked in read-only mode.redis_type: Retrieve data type of key.redis_incr: Increment integer key. Blocked in read-only mode.redis_decr: Decrement integer key. Blocked in read-only mode.redis_flushdb: Clear current Redis database. Blocked in read-only mode.es_cluster_health: Get status (green/yellow/red), node counts, and shard metrics.es_list_indices: List indices, doc counts, store size, and status.es_index_stats: Get detailed metrics for a specific index.es_search: Execute search using Query DSL.es_count: Count documents matching a query.es_get_doc: Fetch document by ID.es_index_doc: Index or overwrite document. Blocked in read-only mode.es_bulk_index: Index multiple documents into one index in a single _bulk request, with per-document success/failure reporting (e.g. for seeding). Blocked in read-only mode.es_update_doc: Partially update document fields. Blocked in read-only mode.es_delete_doc: Delete document by ID. Blocked in read-only mode.es_delete_by_query: Delete documents matching Query DSL. Blocked in read-only mode.mysql_query: Execute read-only SELECT/SHOW/EXPLAIN queries.mysql_execute_sql: Execute write SQL (INSERT, UPDATE, DELETE, DDL). Blocked in read-only mode.mysql_list_databases: List databases on server.mysql_list_tables: List tables in database.mysql_list_views: List views and security options.mysql_describe_table: Show column definitions and metadata.mysql_show_create_table: Extract raw CREATE TABLE DDL statement.mysql_show_create_view: Extract raw CREATE VIEW DDL statement.mysql_list_indexes: Show table indexes (SHOW INDEX).mysql_list_triggers: List database triggers.mysql_list_routines: List stored procedures and functions.mysql_list_constraints: List foreign keys and constraints.mysql_table_stats: Retrieve estimated rows, data length, and index size.mysql_active_queries: Retrieve running threads (SHOW FULL PROCESSLIST).mysql_kill_query: Kill running process by ID. Blocked in read-only mode.mysql_explain_query: Analyze query execution plan (EXPLAIN).mysql_global_status: Query server global status metrics.mysql_analyze_table: Run ANALYZE TABLE to refresh statistics. Blocked in read-only mode.mongo_list_databases: List databases on MongoDB cluster.mongo_list_collections: List collections in database.mongo_find: Query documents with filter, projection, sort, limit, and skip.mongo_distinct: Get unique field values.mongo_aggregate: Execute MongoDB aggregation pipeline.mongo_count_documents: Count documents matching filter.mongo_insert_one: Insert single document. Blocked in read-only mode.mongo_insert_many: Insert array of documents. Blocked in read-only mode.mongo_update_one: Update single document matching filter. Blocked in read-only mode.mongo_update_many: Update multiple documents. Blocked in read-only mode.mongo_delete_one: Delete single document. Blocked in read-only mode.mongo_delete_many: Delete multiple documents. Blocked in read-only mode.mongo_create_index: Create collection index. Blocked in read-only mode.mongo_drop_index: Drop collection index by name. Blocked in read-only mode.mongo_list_indexes: List all collection indexes.mongo_db_stats: Get database storage statistics.mongo_collection_stats: Get storage, index size, and object count for collection.mongo_explain: Get query planner execution plan and index scan metrics.mongo_server_status: Get cluster memory, connection, and operation stats.ldap_search: Search a directory by base DN, filter, and scope (capped at 500 entries).ldap_compare: Compare an attribute/value pair against an entry.ldap_add: Create a new entry. Blocked in read-only mode.ldap_add_bulk: Create multiple entries in one call (e.g. for seeding), with per-entry success/failure reporting. Blocked in read-only mode.ldap_modify: Add, replace, or delete an attribute's values on an entry. Blocked in read-only mode.ldap_delete: Delete an entry. Blocked in read-only mode.For complex setups with multiple named databases, create config/databases.config.yml (copy config/databases.config.example.yml):
connections:
- id: primary-pg
type: postgres
connectionString: ${POSTGRES_URL}
defaultSchema: public
statementTimeoutMs: 30000
readOnly: true
- id: app-cache
type: redis
connectionString: ${REDIS_URL}
readOnly: false
- id: search-logs
type: elasticsearch
connectionString: ${ELASTICSEARCH_URL}
apiVersion: "9"
readOnly: true
- id: legacy-cluster
type: elasticsearch
connectionString: ${LEGACY_ELASTICSEARCH_URL}
apiVersion: "7"
readOnly: true
- id: analytics-mysql
type: mysql
connectionString: ${MYSQL_URL}
statementTimeoutMs: 30000
readOnly: true
- id: document-store
type: mongodb
connectionString: ${MONGODB_URL}
defaultDatabase: production
readOnly: true
- id: directory
type: ldap
connectionString: ${LDAP_URL}
bindDn: ${LDAP_BIND_DN}
bindPassword: ${LDAP_BIND_PASSWORD}
readOnly: false
git clone https://github.com/Nam088/mcp-database-server-v2.git
cd mcp-database-server
npm install
npm run build # Compiles TypeScript to dist/
npm test # Runs Vitest test suite
{
"mcpServers": {
"mcp-server-db": {
"type": "stdio",
"command": "node",
"args": ["/absolute/path/to/mcp-database-server/dist/index.js"],
"env": {
"DATABASES_CONFIG_PATH": "/absolute/path/to/mcp-database-server/config/databases.config.yml"
}
}
}
}
claude mcp add --scope user mcp-server-db node /absolute/path/to/mcp-database-server/dist/index.js --env DATABASES_CONFIG_PATH=/absolute/path/to/mcp-database-server/config/databases.config.yml
~/Library/Application Support/Claude/claude_desktop_config.json~/.claude.json~/.gemini/config/mcp_config.json.mcp.jsonDistributed under the MIT License. See LICENSE for details.
FAQs
MCP server exposing Postgres, Redis, Elasticsearch, MySQL, MongoDB, and LDAP as tools, with lazy connection management, retry, circuit breaking, per-connection read-only mode, and optional database drivers.
The npm package mcp-server-db receives a total of 7 weekly downloads. As such, mcp-server-db popularity was classified as not popular.
We found that mcp-server-db demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Security News
The PHP Foundation says Chainguard broke a security embargo ahead of critical RCE patches, as leaks disrupted the coordinated release.
Security News
PHP releases emergency patches for two critical RCE vulnerabilities as agencies urge organizations to take unpatched sites offline.
Threat Research
/Security News
A supply chain attack compromised LiteLLM 1.107.0 on PyPI and Docker, spreading malware that steals cloud credentials, developer secrets, and AI provider keys.