Postgres AIops MCP Server: Install & Setup

Install Postgres AIops in Claude Code

Claude Code

claude mcp add postgres-aiops -- uvx postgres-aiops

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

{
  "mcpServers": {
    "postgres-aiops": {
      "command": "uvx",
      "args": [
        "postgres-aiops"
      ]
    }
  }
}

Frequently asked questions

What does the Postgres AIops MCP server do?

Governed PostgreSQL DBA operations: slow-query, bloat and lock analysis, index management, vacuum and replication lag, with audit logs and rollback.

Is the Postgres AIops MCP server free?

Yes, most likely. Open source and no paid account or API key is mentioned in the listing. Check the provider for current pricing.

Does Postgres AIops run locally or remotely?

Local. Runs on your machine (stdio). You install it with npx, uvx, Docker or from source.

How do I add Postgres AIops to Claude Code?

Run: claude mcp add postgres-aiops -- uvx postgres-aiops

More databases MCP servers

View all

Queue AIops

AIops-tools/Queue-AIops

Governed Redis + RabbitMQ operations — memory-pressure, latency, backlog, and churn RCA, plus guardrailed queue and key operations (28 tools) with unbypassable audit logging (MCP + CLI), budget/runaway guards, and undo/rollback.

LocalFreePython

MySQL AIops

AIops-tools/MySQL-AIops

Governed MySQL + MariaDB DBA operations — slow-query, lock-wait/deadlock, replication, and fragmentation RCA, plus guardrailed writes (35 tools) with unbypassable audit logging (MCP + CLI), budget/runaway guards, dry-run, and undo/rollback.

LocalFreePython

LakehouseBox

Query and write Apache Iceberg tables hosted in Europe, and open public datasets, with DuckDB SQL.

RemoteAccount needed

JSON MCP Lite

scoretracker4321/json-mcp-lite

Serve any JSON file (catalogue, FAQ, price list) as read-only list, keyword search and get-by-id tools over stdio, configured with CLI flags.

LocalFreeTypeScript

Prisma

Manage Prisma Postgres databases and run migrations.

RemoteAccount needed

Elekto MCP for SQL

elekto-com-br/elekto-mcp-sql

Read-only SQL Server introspection for .NET projects: schema, DDL, dependency graphs, index health and data profiling, reading connection strings from appsettings.json or web.config, and reporting which GRANTs the login lacks.

LocalFreeC#