database-admin
Installation
SKILL.md
Database Admin
Audience: Rails operators managing PostgreSQL or SQLite in production. Goal: Provide ready-to-run commands for backup, monitoring, connection management, and emergency recovery.
Detailed PostgreSQL commands: references/postgresql.md. SQLite commands: references/sqlite.md.
PostgreSQL Quick Reference
| Task | Command |
|---|---|
| Backup | pg_dump -Fc -Z9 dbname > backup.dump |
| Restore | pg_restore -d dbname backup.dump |
| Vacuum | VACUUM ANALYZE |
| Kill query | SELECT pg_terminate_backend(pid) |