DB migrations
- Always spin up a new neon branch to create migrations. Update our root .env files to point at the neon branch locally.
- Use drizzle to manage the migration. You can see the schema at packages/db/src/schema. Never run a migration yourself.
- Create migrations by changing drizzle schema then running
bunx drizzle-kit generate --name="<sample_name_snake_case>" NEON_ORG_IDandNEON_PROJECT_IDenv vars are set in .env- list_projects tool requires org_id passed in
- NEVER manually edit files in
packages/db/drizzle/- this includes.sqlmigration files,meta/_journal.json, and snapshot files. These are auto-generated by Drizzle. If you need to create a migration, only modify the schema files inpackages/db/src/schema/and ask the user to rundrizzle-kit generate.
Source: superset-sh/superset → .agents/skills/db-migrations/SKILL.md