Generate schema-only SQL snapshots from PostgreSQL databases using pg_dump.
npx skills add https://github.com/GDSDN/kord-aios --skill db-snapshot
Please help me install this Agent Skill. Skill: db-snapshot Source: https://github.com/GDSDN/kord-aios/tree/main/src/features/builtin-skills/kord-aios/database/db-snapshot Command: npx skills add https://github.com/GDSDN/kord-aios --skill db-snapshot
This Skill provides a robust mechanism to create schema-only snapshots of a database, enabling quick rollbacks and version control for database schemas.
pre_deploy snapshot. If the deployment fails, you can use this snapshot to revert the schema to its previous state.Use the db-snapshot skill to create a snapshot labeled 'pre_migration'.
High-intent search queries and answers about installing and using this skill.
To create a PostgreSQL schema snapshot for rollback, use the db-snapshot skill to generate schema-only SQL outputs via pg_dump. It supports interactive and autonomous modes to capture, verify, and manage backups of your database structure.
Database schema versioning in Postgres is achieved by generating schema-only SQL snapshots that record structural changes over time. This allows you to track modifications and revert to a previous schema state if a migration fails or introduces unintended changes.
Yes, you can use pg_dump to create schema-only snapshots for migration safety. The skill automates generating these structural backups before deploying new application versions, allowing quick reversion if database schema modifications fail.
The database snapshot tool includes detailed error handling for connection, syntax, and transaction issues during the pg_dump process. This ensures schema backups are reliably verified and managed without silent failures.
You need a schema-only snapshot instead of a full database backup when you want to isolate structural changes for version control or rollback. This excludes data, focusing entirely on reverting database schema modifications caused by failed migrations.
To verify database schema changes before and after a migration, create labeled snapshots like 'pre_migration' using pg_dump. Comparing these schema-only SQL backups allows you to confirm exactly what structural modifications were applied.
pgplexValidate PostgreSQL schema drift by comparing pg_dump with pgschema outputs.
linenoizeGenerate rollback-aware database migration files and validate schema changes.
jabrenaManage Flyway database migrations in Micronaut applications.
joyz0Manage versioned database schema changes with transactional execution and automated rollback.