# Aiops Tools Postgres Aiops MCP server

Source: https://glimind.com/server/mcp-registry%2Fio.github.aiops-tools%2Fpostgres-aiops
Registry id: `mcp-registry/io.github.aiops-tools/postgres-aiops`
Status: unknown

## Install

```json
{
  "mcpServers": {
    "aiops-tools-postgres-aiops-mcp-server": {
      "command": "uvx",
      "args": [
        "postgres-aiops"
      ]
    }
  }
}
```

Claude Code:

```sh
claude mcp add aiops-tools-postgres-aiops-mcp-server -- uvx postgres-aiops
```

## Tools (35)

- `autovacuum_status`: Get autovacuum status.
- `bloat_and_vacuum_analysis`: Analyze bloat and vacuum needs.
- `blocking_lock_chain_rca`: Root cause analysis for blocking lock chains.
- `cancel_query`: Cancel a running query.
- `create_index`: Create an index.
- `drop_index`: Drop an index.
- `explain_query`: Explain a query plan.
- `index_bloat`: Analyze index bloat.
- `invalid_indexes`: Find invalid indexes.
- `list_activity`: List current database activity.
- `list_databases`: List all databases on the server.
- `list_extensions`: List installed PostgreSQL extensions.
- `list_locks`: List current locks.
- `list_roles`: List all PostgreSQL roles.
- `long_running_queries`: List long-running queries.
- `missing_index_hints`: Get missing index hints.
- `overview`: Get a high-level overview of the PostgreSQL server.
- `reindex`: Reindex a table or index.
- `replication_slots`: List replication slots.
- `replication_status`: Get replication status.
- `reset_query_stats`: Reset query statistics.
- `run_analyze`: Run ANALYZE on a table.
- `run_vacuum`: Run VACUUM on a table.
- `server_version`: Get the PostgreSQL server version.
- `show_settings`: Show current PostgreSQL configuration settings.
- `slow_query_rca`: Root cause analysis for slow queries.
- `table_bloat`: Analyze table bloat.
- `table_sizes`: Get table sizes.
- `terminate_backend`: Terminate a backend process.
- `top_queries`: Get top queries by resource usage.
- `undo_apply`: Apply an undo operation.
- `undo_list`: List available undo operations.
- `unused_indexes`: Find unused indexes.
- `update_setting`: Update a PostgreSQL configuration setting.
- `wal_status`: Get WAL status.

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.