What is postgres-aiops?

A local operations tool for PostgreSQL, a database system. It helps investigate slow queries, database bloat, vacuum work, and blocking locks, with checks for audit records, budgets, undo, and risk levels.

Use it to find causes of slow queries, examine bloat and vacuum issues, investigate locks that block other work, and review the resulting database operations.

It organizes common database troubleshooting and DBA work while applying controls to potentially risky actions. The built-in governance harness helps track and limit that work.

postgres-aiops — MCP server by AIops-tools

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Clone the repo

git clone --depth 1 https://github.com/AIops-tools/Postgres-AIops

Made for: Claude Code.

Or install postgres-aiops, the plugin that ships this one along with the rest of its 1 skill, 1 MCP server.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/mcp/aiops-tools/postgres-aiops/postgres-aiops/github.svg)](https://agentmods.dev/mcp/aiops-tools/postgres-aiops/postgres-aiops)

Your own site

<a href="https://agentmods.dev/mcp/aiops-tools/postgres-aiops/postgres-aiops"><img src="https://agentmods.dev/badge/mcp/aiops-tools/postgres-aiops/postgres-aiops/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/mcp/aiops-tools/postgres-aiops/postgres-aiops"><img src="https://agentmods.dev/badge/mcp/aiops-tools/postgres-aiops/postgres-aiops.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session not measured What this adds to a session before it is invoked.

When invoked not measured Not applicable: nothing here is loaded into a session.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits

Socket warn 16 Oct 2026

How audits are shown

Origin original No closer match found in the catalogue.

Security

Grade A, and why

postgres-aiops scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 3d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.mcp.json · 11 lines

What it actually says

{
  "postgres-aiops": {
    "type": "stdio",
    "command": "uvx",
    "args": [
      "--from",
      "postgres-aiops==0.12.0",
      "postgres-aiops-mcp"
    ]
  }
}

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

3d ago Changed 8dfa0040e79a
1mo ago Changed 26f72a9a2fe2
1mo ago Changed 1585428601a2
1mo ago Changed f8f884bf08ad
1mo ago First seen · 11 lines scan A 6d9c862d7ca6

Subscribe to this mod's changes

postgres-aiops is an MCP server published in the GitHub repository AIops-tools/Postgres-AIops (0 stars, last pushed 3d ago), licensed MIT. Its token cost is not measured: an MCP server costs its tool schemas, not its config file. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Databases Debugging PostgreSQL agent-skills ai-ops dba mcp postgresql

postgres-aiops

Getting it into your agent

Wrote this? Show the measurements

Grade A, and why

Nothing flagged

What it actually says

What this file has done since we first saw it

Other mcp servers, from other repositories

pgmcp

supabase

dryrun

pgbot

postgres-mcp

local-knowledge-rag