Skills
.Work. You
Rest

aim-database-migration

Community

Make PostgreSQL migrations repeatable and safe.

Software Engineering#postgresql#migration#database schema#docker compose#go test#sqlc#idempotent ddl
Authorhellopoisonx
Version1.0.0
Installs0

System Documentation

What problem does it solve?

It prevents failed AIM database migrations and broken local deployments by enforcing a repeatable, deterministic PostgreSQL migration workflow for the auth and logic domains.

Core Features & Use Cases

  • Idempotent DDL enforcement: ensures CREATE/ALTER statements can run multiple times without “already exists” failures, especially when Docker volumes cause migrate containers to re-run.
  • Deterministic migration ordering: mandates NNN_description.sql naming so migrations execute in correct dictionary order via the compose migrate init container.
  • End-to-end validation: requires running sqlc generate and go test after adding or changing migration SQL to keep generated models consistent.

Quick Start

When you modify or add a migration SQL file, run sqlc generation and then execute go tests for the affected domain packages to confirm the new schema and queries work correctly.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: aim-database-migration
Download link: https://github.com/hellopoisonx/aim/archive/main.zip#aim-database-migration

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.