Postgres MCP
未申請Read-only-by-default MCP server for PostgreSQL. Query, introspect schemas, explain plans, health checks.
01 / クライアントを選択
03 / 設定を追加
claude mcp add --transport stdio 'yawlabs-postgres-mcp' -- 'npx' '-y' '@yawlabs/postgres-mcp@latest'04 / クライアントで確認
クライアントの MCP 設定で接続とツール一覧を確認してください。設定のコピーだけでは接続成功は確認できません。
Databasesの他のサーバー
ディレクトリ全体を見る未申請リスティング
このMCPサーバーはあなたのものですか？
このリスティングは公開情報から自動的にインデックスされました。申請することで、ページの編集、互換性の設定、成長ツールのアンロックができます。2分以内に完了します。
このサーバーを申請するセキュリティプロファイル
申請済みおよび認証済みのサーバーは毎週の静的スキャンを受け、コードが到達できる範囲（外部サービス、環境変数、シェルコマンド、エージェント設定フォルダ）と既知のアドバイザリを持つ依存関係が表示されます。このリスティングを申請すると利用できます。 セキュリティプロファイルの仕組み
23 件中 23 件
ドキュメントに記載されたツール (23)
プロジェクトのドキュメントに基づきます。サーバーのハンドシェイクは、各ツールの説明や動作を検証するものではありません。
pg_advisor
Rolled-up DBA lints in one call: sequence-exhaustion candidates, wraparound risk for both counters (per-database and per-table age(relfrozenxid) against autovacuumfreezemaxage, and mxidage(relminmxid) against autovacuummultixactfreezemaxage -- a lock-heavy workload can exhaust multixacts while xids
pg_describe_table
Kind, columns, PK, outgoing FKs, incoming FKs (referencedby), CHECK / UNIQUE / EXCLUDE constraints, indexes, and partition parent/children for a relation. Generated and identity columns are flagged (generated, identity, generationexpression) so an agent doesn't try to write to them. Constraints carr
pg_explain
EXPLAIN or EXPLAIN ANALYZE for a SQL statement. Text or JSON output. Planner options: buffers (on by default with analyze), settings, verbose, wal, costs, timing, plus genericplan (PG16+, plan a parameterized query with no values) and memory / serialize (PG17+). Optional hypotheticalindexes (require
pg_health
Server version, database size, connections against maxconnections, active queries with wait events and transaction age, pgstatdatabase rollup (deadlocks, temp files, cache hit ratio), table count.
pg_index_advisor
Recommend indexes for a workload and prove each one pays for itself first. Takes statements you pass or the top N from pgstatstatements, harvests candidate columns from what the planner reports as filters / join keys / sort keys (no SQL parser - every token is intersected with the real pgattribute c
pg_inspect_locks
Who is blocking whom right now (blocked PID, blocker PID, lock type, queries).
pg_io_stats
I/O observability: pgstatio read/write/extend/fsync counts, bytes and times per backend type and context (PG16+), plus in-flight async I/O handles from pgaios and the active iomethod (PG18+).
pg_kill
Cancel a running query or terminate a backend connection. Requires ALLOWWRITES=1.
pg_list_extensions
List installed extensions (pgvector, postgis, pgstatstatements, etc.) with versions.
pg_list_functions
List functions, procedures, and aggregates in a schema with signatures and return types.
pg_list_roles
Database roles with login/superuser/createdb flags and group memberships.
pg_list_schemas
List non-system schemas.
pg_list_tables
List tables (and optionally views) in a schema with estimated row counts. Paginated via limit/offset.
pg_list_views
List views and materialized views in a schema, including their SQL definitions.
pg_query
Run a SQL query. Writes gated by the role in DATABASEURL first, ALLOWWRITES second. Supports parameterized queries via params. Result fields include dataTypeName (e.g. int4, jsonb) alongside dataTypeID.
pg_readonly
Run a SQL statement with no persistent data changes - always inside BEGIN READ ONLY, regardless of ALLOWWRITES. The recommended tool for read access, and the one to auto-allow; pair it with a least-privileged role (why).
pg_replication_status
Replication slots, connected replicas, and current WAL position.
pg_search_columns
Find columns by name pattern across all user schemas. Case-insensitive, supports SQL LIKE wildcards.
pg_seq_scan_tables
Tables with heavy sequential scans - missing-index candidates. Returns the statsreset window alongside the rows, since the counters mean nothing without it. lastseqscan / lastidxscan on PG16+.
pg_table_bloat
Tables with high dead-tuple ratios - VACUUM candidates.
pg_table_privileges
Who has SELECT/INSERT/UPDATE/DELETE/etc. on a table or whole schema.
pg_top_queries
Top N queries by total/mean execution time. Requires the pgstatstatements extension. Returns statsreset (from pgstatstatementsinfo, a different clock from the other stats tools) and dealloc on extension 1.9+ - a non-zero dealloc means entries were evicted past pgstatstatements.max, so the ranking is
pg_unused_indexes
Non-unique, non-primary indexes with low scan counts - drop candidates. Also returns statsreset: a recently reset counter makes every index look unused, which is how a load-bearing index gets dropped. lastidxscan on PG16+.