@apilium/postgres-admin

PostgreSQL DBA toolkit skill for Mayros -- performance diagnostics, vacuum management, lock detection, replication monitoring, and backup.

Installation

Copy this skill directory into your Mayros skills folder:

cp -r skills/postgres-admin ~/.mayros/skills/postgres-admin

Or install via the Mayros CLI:

mayros skill install @apilium/postgres-admin

Prerequisites

Install PostgreSQL client tools:

# macOS
brew install postgresql

# Ubuntu/Debian
sudo apt-get install postgresql-client

# Verify
psql --version

Usage

Once configured, the agent can:

• Performance: Identify slow queries via pg_stat_statements, check cache hit ratio, find largest tables
• Vacuum: Monitor dead tuples, trigger manual vacuum, tune autovacuum parameters
• Locks: Detect blocking locks, identify lock chains, terminate blocking connections
• Connections: Monitor active/idle connections, identify long-running queries, manage connection limits
• Indexes: Find unused indexes, create indexes concurrently, detect duplicate indexes
• Replication: Monitor replication lag, check WAL status, verify replica health
• Backup: Generate pg_dump and pg_basebackup commands, point-in-time recovery guidance

Example prompts

"Show me the top 10 slowest queries in my PostgreSQL database"
"Which tables need vacuum? Check dead tuple counts"
"Are there any blocking locks in my database right now?"
"Find unused indexes that I can safely drop"
"Check the replication lag on my replica"
"Generate a pg_dump command for a compressed backup"

Semantic Predicates

| Predicate | Scope | Description | |-----------|-------|-------------| | pg:issue_detected | agent | Issues detected by the agent | | pg:recommendation | agent | DBA recommendations | | pg:admin_context | namespace | Admin context for enrichment |

License

MIT