db-migration

Automate Atlas schema migrations and SQLC query generation workflows.

126|41|Updated Aug 4, 2018
One-click install
npx skills add https://github.com/hiromaily/go-crypto-wallet --skill db-migration
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-migration
Source: https://github.com/hiromaily/go-crypto-wallet/tree/main/.claude/skills/db-migration
Command: npx skills add https://github.com/hiromaily/go-crypto-wallet --skill db-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Managing database schema changes is error-prone when migrations, Atlas schemas, and SQLC queries drift out of sync. This Skill provides a repeatable workflow to coordinate Atlas-based migrations with SQLC code generation, ensuring consistency across environments.

Core Features & Use Cases

  • Atlas-driven migrations: generate, apply, and verify schema changes.
  • SQLC integration: regenerate type-safe queries after schema updates.
  • Validation & testing: run migrations in a controlled environment before deployment.

Quick Start

Run the Atlas migration workflow to generate and apply migrations for your current project, then regenerate SQLC queries.

Frequently Asked Questions about db-migration

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

FAQPage Schema
How do I keep Atlas database migrations in sync with SQLC query generation?

To keep Atlas migrations in sync with SQLC queries, this Skill automates the coordinated workflow of generating and applying schema migrations, then regenerating type-safe SQLC queries to prevent drift across environments.

What is the best way to automate database schema migrations in a Go project using Atlas?

Automating database schema migrations with Atlas involves a repeatable workflow to generate, apply, and verify schema changes, then triggering SQLC code generation to ensure query types match the updated database schema.

Do I need Make targets configured to run Atlas migrations and SQLC code generation?

Yes, this Skill requires the project's Make targets to execute migration generation, migration application, and SQLC code generation steps, ensuring a consistent and repeatable database schema update process.

Can I test Atlas schema migrations in a controlled environment before deploying to production?

Yes, you can validate and test Atlas schema migrations in a controlled environment before deployment, verifying that schema changes apply correctly and SQLC query generation succeeds without breaking existing queries.

Why do my SQLC generated queries fail after applying Atlas schema migrations?

SQLC query generation fails after Atlas schema migrations when the schema and generated code drift out of sync, a problem solved by coordinating Atlas migration application with immediate SQLC query regeneration.

Does this database migration workflow support Atlas and SQLC integration for Go projects?

Yes, this workflow specifically targets Go development environments by integrating Atlas-driven database schema migrations with SQLC type-safe query generation to maintain consistency across development stages.