postgres-diagnostics: Read-only PostgreSQL Diagnostic Tool via pgbot

LinkTool

postgres-diagnostics is a skill for pgbot, providing deterministic, read-only PostgreSQL diagnostics. It assesses performance, bloat, autovacuum, indexes, and configuration without writing to the database.

Key points

  1. Read-only design: pgbot never executes write operations against the database.
  2. Deterministic engine: Findings are calculated in Go rather than generated by an AI model.
  3. Core use cases: Investigating slow queries, unused indexes, disk bloat, autovacuum status, and database health.
  4. Security audit status: Flagged as 'Fail' by Gen Agent Trust Hub, 'Warn' by Snyk, and 'Pass' by Socket.

Why it matters

Diagnosing production databases requires strict safety guarantees to prevent unintended changes. Deterministic checks implemented in code help avoid model hallucinations while inspecting critical infrastructure.

Analysis

The skill enforces a clear separation of concerns: pgbot acts as a deterministic source of truth written in Go, leaving interpretation and recommendations to the AI agent or developer. Prospective users should note mixed security audit results, including a failed check on Gen Agent Trust Hub.

Mentioned links

Found in

Summary generated by AI (Gemini 3.8 Flash, 27 September 2026). It may contain errors – the original source is authoritative.

Related entries

Similar in content, found by the AI search.

  • Link:SkillPatch

    SkillPatch: Directory for Security-Verified AI Agent Skills

    SkillPatch is a public registry for AI agent skills based on the open SKILL.md standard. The platform provides automated security assessments prior to publication and supports tools such as Claude Code, Cursor, and GitHub Copilot.

    AI & LLMs· Tool

  • Repository:NVIDIA/SkillSpector

    SkillSpector: Security Scanner for AI Agent Skills by NVIDIA

    SkillSpector is an open-source security scanner from NVIDIA designed to inspect extensions and skills for AI agents (such as Claude Code, Codex CLI, and MCP) for vulnerabilities and malicious patterns before installation.

    15.9kstarsPython

    AI & LLMs· Tool

  • Repository:cloudflare/security-audit-skill

    Cloudflare Open-Sources Security Audit Skill for Coding Agents

    Cloudflare's security-audit-skill is an open-source coding-agent workflow that orchestrates multi-phase security audits with independently verified, machine-readable findings.

    5.2kstarsJavaScript

    AI & LLMs· Tool

  • Repository:perplexityai/numbat

    numbat: Endpoint Visibility and Security for AI Agents

    numbat is an open-source tool by Perplexity AI providing on-device detection, forensic reconstruction, and optional pre-action blocking for AI agent activity.

    983starsGo

    AI & LLMs· Tool

  • Repository:CopilotKit/OpenBot

    OpenBot: Open-Source Platform for Isolated and Governed AI Coworkers

    OpenBot by CopilotKit is a self-hosted platform providing AI agents as coworkers. Each agent operates within its own dedicated computer environment, featuring a real browser, scoped file access, and explicit tool permissions.

    4.3kstarsTypeScript

    AI & LLMs· Tool

Back to the knowledge base

Let's talk about your project

Get in touch

Locations

  • Mattersburg
    Johann Nepomuk Bergerstraße 7/2/14
    7210 Mattersburg, Austria
  • Vienna
    Ungargasse 64-66/3/404
    1030 Wien, Austria

Parts of this content were created with the assistance of AI.