This skill manages database schema updates and migrations using Drizzle and custom SQL scripts.
Install
mkdir -p .claude/skills/database-development && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/3851" && unzip -o skill.zip -d .claude/skills/database-development && rm skill.zipInstalls to .claude/skills/database-development
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Database migrations and Drizzle ORM guidelines for the vm0 projectKey capabilities
- →Generates SQL migration files from Drizzle schema
- →Manages sequential migration versioning
- →Executes local schema validation
- →Handles complex data backfills via TypeScript scripts
- →Generates custom SQL migration scaffolds
How it works
Executes Drizzle-kit commands and specific migration workflow scripts to synchronize schema and SQL artifacts.
Inputs & outputs
When to use database-development
- →Generating database migrations from schema changes
- →Executing pending migrations in the development environment
- →Creating custom SQL migration files
- →Backfilling data through scripted migrations
About this skill
Database Development
| Task | Read |
|---|---|
| Schema changes or data migration | Migration workflows and DB migrations |
| Selections, raw results, or SQL rewrites | Query contracts |
| Persisted shapes or deploy order | Deployment compatibility |
Use Drizzle to generate migration metadata; do not hand-edit journals or snapshots. Numbered external-data migration scripts are permanent historical records, even after their referenced schema is retired. Keep them self-contained and dry-run by default.
TypeScript generics do not decode PostgreSQL results. Use the first applicable schema column, installed Drizzle helper, or reviewed runtime decoder; preserve nullability, precision, and provenance. Query rewrites must preserve the whole SQL contract, including bindings, transactions, locks, and material plan costs. The query reference contains the complete decision order and examples.
When not to use it
- →Managing non-Drizzle projects
- →Manual database administration tasks
- →Direct editing of system journal files
Prerequisites
Limitations
- →Requires strict adherence to numbered file conventions
- →Custom SQL scripts require manual validation
How it compares
It enforces strict project-specific migration conventions and data-handling workflows instead of just running arbitrary SQL.
Compared to similar skills
database-development side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| database-development (this skill) | 1 | 3mo | Review | Intermediate |
| prisma-expert | 12 | 8mo | Review | Intermediate |
| supabase-migration-deep-dive | 1 | 2mo | Review | Intermediate |
| drizzle | 238 | 3mo | No flags | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by vm0-ai
View all by vm0-ai →You might also like
prisma-expert
davila7
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design, or database connection issues.
supabase-migration-deep-dive
jeremylongshore
Execute Supabase major re-architecture and migration strategies with strangler fig pattern. Use when migrating to or from Supabase, performing major version upgrades, or re-platforming existing integrations to Supabase. Trigger with phrases like "migrate supabase", "supabase migration", "switch to supabase", "supabase replatform", "supabase upgrade major".
drizzle
lobehub
Drizzle ORM schema and database guide. Use when working with database schemas (src/database/schemas/*), defining tables, creating migrations, or database model code. Triggers on Drizzle schema definition, database migrations, or ORM usage questions.
dbx-regenerate
storj
Regenerate DBX code after making changes to .dbx schema files. Runs code generation, shows diff summary, validates compilation, and reports any errors.
database-schema
alinaqi
Schema awareness - read before coding, type generation, prevent column errors
nop-orm-modeler
entropy-cloud
Generate, validate, and modify Nop ORM models from MySQL DDL/SQL or business requirements. Covers entity modeling, relationships, domains, dictionaries, displayName localization, and ORM file organization (Delta mode). Use for database-first or requirements-first ORM development.