Database

Manage PostgreSQL schema evolution with versioned golang-migrate migrations.

Updated Feb 12, 2026
One-click install
npx skills add https://github.com/harrytran998/crossfire --skill database-harrytran998
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Database
Source: https://github.com/harrytran998/crossfire/tree/main/.agents/skills/database
Command: npx skills add https://github.com/harrytran998/crossfire --skill database-harrytran998

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires golang-migrate, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a robust and version-controlled method for managing database schemas, ensuring reproducible states and facilitating team collaboration.

Core Features & Use Cases

  • Schema Versioning: Track all database schema changes using discrete, reversible migrations.
  • Database Agnostic Migrations: Supports various database drivers through the golang-migrate tool.
  • Use Case: When deploying a new feature that requires database schema modifications, use this Skill to apply migrations in a controlled and auditable manner, ensuring consistency across development, staging, and production environments.

Quick Start

Use the database skill to apply all pending migrations to the PostgreSQL database.

Frequently Asked Questions about Database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage PostgreSQL schema changes with version control?

PostgreSQL schema version control applies discrete, reversible migrations using golang-migrate. This ensures reproducible database states across development, staging, and production environments while maintaining data integrity through constraints and audit trails.

What is the best way to apply database migrations in a team workflow?

Database migrations in team workflows require version-controlled, reproducible state management. Golang-migrate facilitates collaboration by tracking discrete schema changes, ensuring consistency across environments, and providing auditable deployment processes for new features.

Does golang-migrate support complex data modeling and audit trails?

Yes, golang-migrate supports complex data modeling with advanced SQL features and ensures data integrity through constraints and audit trails. It manages schema evolution by applying version-controlled migrations that maintain consistent, reproducible database states.

Can I use this for schema migrations across development, staging, and production?

Yes, schema migrations across development, staging, and production are supported via version-controlled state management. This ensures consistency by applying discrete, reversible migrations in a controlled, auditable manner during feature deployments.

Why do I need version-controlled database schema management?

Version-controlled database schema management ensures reproducible states and facilitates team collaboration. It tracks schema evolution using reversible migrations, preventing inconsistent states when deploying features requiring database modifications across multiple environments.

Are database migrations reversible if a deployment fails?

Yes, database migrations are reversible using golang-migrate, which tracks discrete schema changes. This version-controlled approach allows rolling back database state modifications in a controlled, auditable manner if a feature deployment encounters issues.