What problem does it solve?
This Skill prevents production incidents caused by database schema changes by automating migration file generation, detecting breaking changes, and ensuring query safety.
Core Features & Use Cases
- Automated Migration Generation: Creates
up and down migration scripts for various ORMs (Prisma, TypeORM, SQLAlchemy, etc.) and raw SQL.
- Breaking Change Detection: Identifies risky schema modifications like adding NOT NULL columns without defaults or dropping tables.
- Query Analysis: Scans for SQL injection vulnerabilities and recommends missing indexes for performance.
- Use Case: Before deploying a new feature that modifies the user table, run this Skill to automatically generate the migration, flag a column rename as a breaking change requiring confirmation, and ensure the new
avatar_url column is nullable.
Quick Start
Use the db skill to analyze schema changes in the current git diff and generate migration files.