Db migrations
Create a database migration with Drizzle on a fresh Neon branch. Use when changing the packages/db schema or generating migrations.From its SKILL.md
npx -y skills add superset-sh/superset --skill db-migrationsAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
1.0 KB, as published. Nobody here has run it
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.