Name: Database
Author: JansenAnalytics

Skill Content

Manage PostgreSQL, SQLite, and Redis databases: create, migrate, backup, restore, query, optimize.

When to Use

Scripts

Script	Purpose	Usage
`backup.sh`	Backup/restore PostgreSQL or SQLite databases	`bash scripts/backup.sh backup\|restore <type> <db> [file]`
`migrate.sh`	Run SQL migration files in order	`bash scripts/migrate.sh <db-url> <migrations-dir>`
`health-check.sh`	Check database connectivity and basic stats	`bash scripts/health-check.sh <type> <connection>`

File	Contents
`postgresql-cheatsheet.md`	Common PostgreSQL commands and patterns
`sqlite-cheatsheet.md`	SQLite CLI and SQL reference
`redis-cheatsheet.md`	Redis commands and data structures
`backup-strategies.md`	Backup approaches for production databases

bash scripts/backup.sh backup sqlite /path/to/mydb.sqlite3

bash scripts/migrate.sh sqlite:///path/to/db.sqlite3 ./migrations/

bash scripts/health-check.sh postgres "host=localhost dbname=myapp user=admin"

Database | Skills Pool