Blog
Technical Insights
Practical knowledge about PostgreSQL, Oracle, database automation, and AI-powered DBA operations.
pg_slow_query_digest — Find Slow Queries Before They Become Problems
Aggregated statistics on the slowest queries: call frequency, mean, max, P95, and total execution time. Built on pg_stat_statements.
pg_index_advisor — Automatically Detect Missing Indexes
Detects missing indexes based on sequential scans, identifies unused indexes, and generates CREATE INDEX statements. Built on pg_stat_user_tables and pg_stat_user_indexes.
pg_cache_hit_ratio — The Fastest PostgreSQL Health Check
Calculates the buffer cache hit ratio from pg_stat_database — a single value that instantly shows whether your database is healthy.
pg_gdpr_audit — Find Personal Data in Your PostgreSQL Database
Scans all schemas for PII columns (name, email, phone, date of birth) and assesses GDPR compliance status. Built on information_schema.columns.
pg_permission_audit — Who Has Access to What in PostgreSQL?
Maps all role grants, privilege chains, and access patterns — showing at a glance who can access which tables. Built on pg_roles and pg_auth_members.
pg_vault_connect — Connect to PostgreSQL via HashiCorp Vault with Zero Static Passwords
Dynamic database credentials from Vault's Database Secret Engine: AppRole login, lease management, and automatic connection pooling — zero static passwords.
pg_vault_rotate — Rotate Database Credentials Without Downtime
Revoke the Vault lease, fetch fresh credentials, and reconnect the connection pool automatically — requires confirmation because active connections are terminated.
pg_hba_analyze — Audit pg_hba.conf for Security Gaps
Automated analysis of PostgreSQL authentication rules: detect trust auth, expose overly broad CIDR ranges, flag missing SSL enforcement. Scored from 0 to 100.
pg_cnpg_dr_readiness — Measure DR Readiness Before It's Too Late
Calculates a DR readiness score from 0–100 with weighted checks across replica health, WAL archiving, replication lag, object store, and instance count.
pg_failover_readiness — Can I Safely Failover Right Now?
Scores failover readiness with a weighted formula: replication lag, sync state, replication slot health, and WAL receiver status. Delivers a clear yes/no answer.
/pg-perf — Complete Performance Check in One Workflow
The /pg-perf skill orchestrates three tools into a complete performance assessment: slow queries, missing indexes, and cache efficiency — with an aggregated score.
/pg-comply — Check GDPR Compliance in One Workflow
The /pg-comply skill orchestrates PII scanning, retention checking, and access log analysis into a complete compliance assessment with a score.
/pg-security — Security Audit in One Workflow
The /pg-security skill chains SSL audit, pg_hba analysis, password policy check, and privilege escalation detection into a complete security assessment with a score from 0 to 100.
/pg-dr — Cross-Cluster DR Drill in 3.5 Seconds
The /pg-dr skill runs a full disaster recovery drill: readiness check, replica promote, verification, demote, and re-check — a complete promote/demote cycle in one workflow.