# Database Development

> Choose migration workflows or Drizzle runtime decoding and SQL construction rules

- Skill: `vm0-ai/database-development` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add vm0-ai/database-development`
- Raw SKILL.md: https://api.skillmd.com/api/skills/vm0-ai/database-development/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: vm0-ai (https://skillmd.com/u/vm0-ai)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/vm0-ai/database-development

---


# Database Development

| Task                                     | Read                                                                                                          |
| ---------------------------------------- | ------------------------------------------------------------------------------------------------------------- |
| Schema changes or data migration         | [Migration workflows](references/migrations.md) and [DB migrations](../../../turbo/packages/db/MIGRATIONS.md) |
| Selections, raw results, or SQL rewrites | [Query contracts](references/query-contracts.md)                                                              |
| Persisted shapes or deploy order         | [Deployment compatibility](../../../docs/deployment-compatibility.md)                                         |

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.

