PostgreSQL Tools
PostgreSQL-specific admin, query, and tuning tools
PostgreSQL Backup Command Generator
Generate full and incremental PostgreSQL backup shell commands
PostgreSQL Restore Command Generator
Generate PostgreSQL restore workflows from backup files
pg_dump Command Generator
Build pg_dump commands with format, compression, and scope options
pg_restore Command Generator
Build pg_restore commands for custom-format dumps
PostgreSQL Connection String Builder
Build libpq URIs, JDBC, and Node.js PostgreSQL connection strings
PostgreSQL User Creation Command
Generate CREATE ROLE and GRANT commands for new PostgreSQL users
PostgreSQL Role Permission Generator
Generate GRANT and REVOKE statements for schemas, tables, and sequences
PostgreSQL Table Size Query Generator
Generate queries to list table and index sizes
PostgreSQL Database Size Query
Generate queries for database and tablespace size monitoring
PostgreSQL Index Bloat Checker Query
Generate queries to detect bloated and unused indexes
PostgreSQL Vacuum Command Helper
Generate VACUUM, VACUUM FULL, and autovacuum tuning commands
PostgreSQL Analyze Command Helper
Generate ANALYZE commands and statistics maintenance queries
PostgreSQL Replication Slot Checker
Generate queries to monitor replication slots and lag
PostgreSQL WAL Size Calculator
Estimate WAL generation and disk requirements
PostgreSQL Log Analyzer
Parse PostgreSQL log lines and summarize errors and slow queries
PostgreSQL Config Checker
Review postgresql.conf settings and tuning recommendations
PostgreSQL Port Checker
Generate commands to verify PostgreSQL port and connectivity
PostgreSQL SSL Connection Helper
Generate SSL connection strings and verify TLS configuration
PostgreSQL Query Formatter
Format and beautify PostgreSQL SQL queries
PostgreSQL JSON Query Helper
Generate JSONB operators and path queries for PostgreSQL
PostgreSQL Date Query Helper
Generate date, interval, and timezone queries for PostgreSQL
PostgreSQL Lock Query Generator
Generate queries to find blocking locks and deadlocks
PostgreSQL Slow Query Analyzer
Analyze pg_stat_statements and log-based slow query output
PostgreSQL Upgrade Checklist
Step-by-step checklist for major PostgreSQL version upgrades
PostgreSQL DBA Report Generator
Generate a PostgreSQL health and configuration audit report