Manage PostgreSQL schema evolution with golang-migrate versioned SQL migrations.
npx skills add https://github.com/nhattran998/crossfire --skill database-nhattran998
Please help me install this Agent Skill. Skill: Database Source: https://github.com/nhattran998/crossfire/tree/main/.agents/skills/database Command: npx skills add https://github.com/nhattran998/crossfire --skill database-nhattran998
This Skill solves the problem of keeping PostgreSQL database schemas consistent and reproducible across environments by using version-controlled, reversible migrations.
Run your migration tool against your PostgreSQL database to apply the next schema version from your migrations directory.
High-intent search queries and answers about installing and using this skill.
PostgreSQL schema migrations are managed with golang-migrate by applying versioned up and down SQL files from a migrations directory, enabling deterministic schema updates and reliable rollback across environments.
Database schema consistency is maintained by using version-controlled, reversible migrations where each logical change is captured as a discrete SQL file, enabling safe team collaboration and reliable deployment across environments.
PostgreSQL features like JSONB, full-text search, indexes, constraints, window functions, CTEs, and partitioning are fully supported within schema migrations, allowing you to leverage database strengths directly in reversible SQL files.
A migrations directory containing reversible SQL files is required to version your PostgreSQL schema, as golang-migrate relies on this structured directory to track applied versions and execute deterministic up or down schema updates.
Safely altering columns and adding SQL constraints is accomplished by capturing each logical change as a discrete reversible migration file, enabling deterministic application and reliable rollback if deployment issues arise.
Database versioning is important for team workflows because it tracks schema evolution through versioned SQL files, preventing manual drift and ensuring every developer applies the same deterministic schema changes across environments.
openmeterioGenerate SQL migrations for ent framework schema changes on PostgreSQL.
akaszubskiAutomate database schema design, migrations, and query-optimization planning for PostgreSQL and MySQL.
FaysilAlshareefAutomate EF Core migration creation, application, and management in .NET projects.
JochenYangDesign database schemas and plan migrations across PostgreSQL, MySQL, MongoDB, and Redis.
