"postgre" matching MCP tools:

• pg_readonlyA

  @yawlabs/postgres-mcpA

  Run SQL statements in a forced read-only transaction that rejects writes and always rolls back, enabling safe SELECT, EXPLAIN, SHOW, and other read-only queries.

  MIT

• pg_queryA

  @yawlabs/postgres-mcpA

  Execute SQL statements on a PostgreSQL database with read-only safety by default and parameterized queries to prevent SQL injection. Returns up to 1000 rows per query.

  MIT

  Destructive

• pg_query_sqlA

  readonly-postgres-mcpA

  Execute a single read-only SQL query (SELECT, WITH, EXPLAIN) on PostgreSQL with write protection, row limits, and bind parameters for safe data retrieval.

  MIT

• pg_killA

  @yawlabs/postgres-mcpA

  Cancel a running query or terminate a backend connection by PID. Use to stop problematic queries when pg_health shows active_queries or locks.

  MIT

  Destructive

• pg_table_bloatA

  @yawlabs/postgres-mcpA

  Estimate table bloat from dead tuples and free space, returning live/dead counts, dead-tuple ratio, and vacuum timestamps to identify tables needing VACUUM.

  MIT

• explain_queryA

  postgres-aiopsA

  Returns the JSON execution plan for a SQL statement via EXPLAIN. Set analyze=True to execute read-only SQL and capture real row counts and timing.

  MIT

• create_indexA

  postgres-aiopsA

  Create an index on a PostgreSQL table to speed queries, with optional CONCURRENTLY builds that avoid locking, dry-run previews, and reversible undo.

  MIT

  Destructive

• pg_search_columnsA

  @yawlabs/postgres-mcpA

  Search across all user schemas for columns matching a name pattern. Uses SQL LIKE wildcards for flexible, case-insensitive lookups to identify tables containing a given column.

  MIT

• pg_index_advisorA

  @yawlabs/postgres-mcpA

  Recommends cost-justified PostgreSQL indexes by planning your SQL workload, generating candidate indexes, costing them via HypoPG hypothetical indexes, and returning only those that measurably reduce estimated query cost.

  MIT

• pg_top_queriesA

  @yawlabs/postgres-mcpA

  Rank your slowest SQL queries by total or mean execution time to pinpoint optimization targets, using pg_stat_statements metrics like call count and cache hit ratio.

  MIT

• pg_io_statsA

  @yawlabs/postgres-mcpA

  Identify which PostgreSQL subsystem performs I/O and through which path. View cumulative per-backend-type I/O stats and in-flight asynchronous I/O to diagnose bottlenecks.

  MIT

• cancel_queryA

  postgres-aiopsA

  Stop a running PostgreSQL query by backend PID to end long-running or blocking statements. Preview with dry-run; pid and query are logged for audit.

  MIT

  Destructive

• update_settingA

  postgres-aiopsA

  Set or reset PostgreSQL configuration parameters via ALTER SYSTEM, with dry-run preview and captured prior state for undo.

  MIT

  Destructive

• pg_unused_indexesA

  @yawlabs/postgres-mcpA

  Identify unused or rarely used indexes that incur write overhead and disk cost, using scan counts and reset age to avoid false conclusions.

  MIT

• pg_inspect_locksA

  @yawlabs/postgres-mcpA

  Identify PostgreSQL lock contention: see which sessions are blocked, who blocks them, lock types, contested relations, and queries. Use when queries hang to pinpoint the blocking transaction.

  MIT

• run_vacuumA

  postgres-aiopsA

  Reclaim table storage and refresh planner statistics with VACUUM, FULL, or ANALYZE; preview changes via dry_run and record prior stats for audit.

  MIT

  Destructive

• list_environmentsA

  postgres-readonly-mcpA

  Lists configured PostgreSQL database environments, returning names and non-secret connection details to use as the env argument for other tools. Read-only.

  MIT

• whoop_auth_urlA

  whoop-postgres-mcpA

  Generate the OAuth authorization URL users open to connect a WHOOP account; after approval, pass the returned code to whoop_connect.

  MIT

• pg_list_schemasA

  @yawlabs/postgres-mcpA

  List user-defined schemas in a PostgreSQL database, excluding system schemas such as pg_catalog and information_schema.

  MIT

• pg_list_tablesA

  @yawlabs/postgres-mcpA

  Retrieve tables and views in a schema with their type and estimated row count. Paginate results with limit and offset for large schemas.

  MIT

• pg_describe_tableA

  @yawlabs/postgres-mcpA

  Describe a PostgreSQL table, view, or materialized view: get its kind, columns, keys, constraints, indexes, and partition info to understand structure and write correct SQL.

  MIT