pg_list_schemas

MCP tool from MCP Database Server V2 by Nam088

List all database schemas.

How to use it

Project documentation lists pg_list_schemas for the MCP Database Server V2 MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install MCP Database Server V2

$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
FULL MCP DATABASE SERVER V2 LISTING

Other tools in MCP Database Server V2 (39)

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_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.