MCP Database Server V2

Unclaimed

by Nam088

No description provided.

Install

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

Unclaimed listing

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Tools (40)

db_reload_config

Hot-reload databases.config.yml from disk and reconcile connections dynamically without interrupting active queries.

db_status

Inspect connection states (idle, connecting, connected, retrying, failed, circuitopen), read-only mode, and error logs across all configured databases.

pg_active_queries

Retrieve running non-idle queries and durations from pgstatactivity.

pg_bloat_estimate

Estimate table bloat ratio based on dead tuple count.

pg_database_health

Run health audit (connections utilization, buffer cache hit ratio, dead rows, replication lag).

pg_database_info

Get database name, current user, PostgreSQL version, and database size.

pg_describe_table

Inspect column data types, ordinal position, and nullability.

pg_duplicate_indexes

Find overlapping or redundant indexes.

pg_execute_sql

Execute write SQL statements (INSERT, UPDATE, DELETE, DDL). Blocked in read-only mode.

pg_explain_hypothetical_index

Simulate hypothetical index performance using hypopg.

pg_explain_query

Inspect query execution plans with EXPLAIN.

pg_get_top_queries

Get slow queries from pgstatstatements.

pg_index_usage

Inspect index scan counts and tuple fetch statistics.

pg_kill_query

Terminate a running backend process by PID. Blocked in read-only mode.

pg_list_constraints

List primary keys, foreign keys, and check constraints.

pg_list_functions

List user-defined functions, arguments, and return types.

pg_list_indexes

List indexes and index definitions for a table.

pg_list_materialized_views

List materialized views in a schema.

pg_list_schemas

List all database schemas.

pg_list_sequences

List sequence objects in a schema.

pg_list_tables

List tables in a target schema.

pg_list_triggers

List triggers and action statements in a schema.

pg_list_views

List all views in a schema.

pg_lock_info

Retrieve active database locks and query durations.

pg_long_running_queries

Find queries exceeding a duration threshold.

pg_missing_indexes

Identify high-sequential-scan tables needing indexes.

pg_query

Execute read-only SELECT queries (enforces single-statement extended query protocol).

pg_refresh_materialized_view

Refresh a materialized view (supports CONCURRENTLY). Blocked in read-only mode.

pg_sizes_overview

Breakdown storage sizes for database, tables, and indexes.

pg_table_stats

Get total size, table size, index size, and estimated row count.

pg_unused_indexes

Identify zero-scan candidate indexes to drop.

pg_vacuum_analyze

Run VACUUM ANALYZE to update statistics and reclaim dead tuples. Blocked in read-only mode.

redis_del

Delete key. Blocked in read-only mode.

redis_get

Get string value at key.

redis_hget

Get hash field value.

redis_hset

Set hash field value. Blocked in read-only mode.

redis_keys

List keys matching a glob pattern (capped at 1000 items).

redis_mset

Set multiple key/value pairs in a single command (e.g. for seeding). Blocked in read-only mode.

redis_set

Set key value. Blocked in read-only mode.

redis_ttl

Get remaining TTL in seconds.