- Home
- Skills
- Data & Databases
- PostgreSQL Operations Diagnostics
More screenshots
Works with the AI Agents you already use
PostgreSQL Operations Diagnostics
Give your AI agent structured PostgreSQL investigation workflows through your own connected MCP-PostgreSQL-Ops server.
Free
About this skill
Give your AI agent structured PostgreSQL investigation workflows through your own connected MCP-PostgreSQL-Ops server.
This skill helps your agent select the relevant tools, establish the target database, gather evidence and explain what the results actually prove. It covers:
- Server identity, database inventory, active sessions, locks and wait events.
- Slow-query statistics when pg_stat_statements or pg_stat_monitor is available.
- Database, table and index I/O, buffer usage and checkpoint statistics.
- Storage usage, dead-tuple-based bloat estimates and autovacuum investigation.
- Running maintenance, last maintenance timestamps and cumulative counters.
- Schema structure, declared relationships, role information and focused settings.
- WAL, replication, slots and standby conflict inspection.
- Version-specific diagnostics, including PostgreSQL 17 wait-event catalogs and WAL summarizer inspection, and PostgreSQL 18 asynchronous/per-backend I/O tools.
The self-contained skill includes an individual operating guide for all 38 registered tools: 37 database inspection tools and one bundled-guidance tool. Each entry gives its source-matched signature, purpose, evidence and interpretation limits. Six symptom-driven playbooks connect those tools for health reviews, blocking, slow queries and I/O, bloat and autovacuum, schema review, and WAL and replication investigations. Illustrative calls show valid argument usage without presenting invented database results.
The instructions distinguish estimates from measurements, current snapshots from historical evidence, and recommendations from executed changes. They account for missing permissions, optional extensions, statistics resets, version-dependent fallbacks and partial tool results.
All workflows use inspection tools. The skill does not run VACUUM, terminate sessions, alter settings, create or drop indexes, install extensions, restart PostgreSQL or perform failover. It helps you prepare informed maintenance decisions; execution requires a separate authorized workflow.
Read-only investigation only. No support for executing maintenance, terminating sessions, or changing configuration. Requires pre-configured MCP server and database permissions.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 19 days ago
- Free with an Agensi account
Requires
Permissions
Uses the buyer's connected MCP-PostgreSQL-Ops server to inspect their PostgreSQL instance. The server operator supplies database endpoints, credentials, network access and appropriate monitoring permissions. These workflows query database state and statistics; they do not change database objects, settings, sessions or maintenance state. No agent access to local files, shell, browser or environment variables is required. Database traffic originates from the MCP server. Server-side connection configuration is not an agent permission grant. Query text, settings, role information and client addresses may be sensitive; collect only necessary evidence and sanitize shared output. The reviewed server can log database credentials at DEBUG level; avoid DEBUG logging and protect existing logs.