claude-code-framework/essential/skills/scaffolding/database-migration/SKILL.md
Creates database migration files for schema changes including adding columns, creating tables, and altering structures. Use when user says "create migration", "add column", "alter table", "database change", or mentions schema modifications.
npx skillsauth add tokenized2027/claude-initilization-v7 database-migrationInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
-- migrations/001_add_email_to_users.sql
-- Up Migration
ALTER TABLE users ADD COLUMN email VARCHAR(255) UNIQUE;
CREATE INDEX idx_users_email ON users(email);
-- Down Migration (for rollback)
-- DROP INDEX idx_users_email;
-- ALTER TABLE users DROP COLUMN email;
# Create migration
npx prisma migrate dev --name add_email_to_users
# Apply migration
npx prisma migrate deploy
# migrations/versions/001_add_email.py
from alembic import op
import sqlalchemy as sa
revision = '001'
down_revision = None
def upgrade():
op.add_column('users', sa.Column('email', sa.String(255), unique=True))
op.create_index('idx_users_email', 'users', ['email'])
def downgrade():
op.drop_index('idx_users_email', table_name='users')
op.drop_column('users', 'email')
development
Methodical debugging using reproducible steps, instrumentation, and root-cause analysis. Use when something is broken and you don't know why. Triggers on "bug", "broken", "not working", "error", "fails intermittently", "regression", "unexpected behavior".
development
Optimize prompts for Claude Code agents, API calls, and multi-agent orchestration. Use when writing system prompts, agent instructions, or refining LLM interactions. Triggers on "improve prompt", "write a prompt", "agent instructions", "system prompt", "prompt not working", "LLM output quality".
tools
Structured ideation and design review before any creative or constructive work. Use before building features, components, architecture, dashboards, or automation workflows. Triggers on "plan this", "design this", "brainstorm", "think through", "what should we build", "how should I approach".
testing
Generates test files for components and functions with setup, basic tests, and mocks. Use when user says "add tests", "create test", "test this component", or mentions testing.