db-migrate
SolidCreate and apply a Prisma migration safely against the remote (tunneled) PostgreSQL. Use for schema changes - "create a migration", "apply migrations", "add a column/table".
API & Backend 79 stars
19 forks Updated 6 days ago MIT
Install
Quality Score: 82/100
Stars 20%
Recency 20%
Frontmatter 20%
Documentation 15%
Issue Health 10%
License 10%
Description 5%
Skill Content
# DB migrate
The database is remote; `DATABASE_URL` points at the SSH tunnel's local port (5433). All
commands are `bun --cwd=apps/api run …`.
1. Confirm the tunnel is up (`bunx prisma migrate status` from `apps/api`). If it isn't, ask the
user to run `bun run db:tunnel` in a separate terminal - don't start it yourself.
2. Edit the schema - split by domain under `apps/api/prisma/schema/*.prisma`.
3. `db:migrate` - creates the migration SQL only (`--create-only`), never applies.
4. Read the generated SQL and confirm it matches intent. Prisma turns renames into drop + add -
hand-edit to `ALTER` when data must survive.
5. `db:migrate:apply`, then `db:generate`.
Never run `db:reset` without explicit user confirmation - it wipes the remote database.
Details
- Author
- suxrobGM
- Repository
- suxrobGM/jobpilot
- Created
- 6 months ago
- Last Updated
- 6 days ago
- Language
- TypeScript
- License
- MIT
Integrates with
Similar Skills
Semantically similar based on skill content — not just same category
API & Backend Listed
db-migration
Instructions for modifying the database schema and generating migrations.
0 Updated 2 months ago
syniol API & Backend Listed
database-migrations
Use when writing or reviewing schema migrations. Covers zero-downtime Postgres patterns (concurrent indexes, instant defaults, expand-contract) and tool-specific CLI workflows and gotchas for Prisma, Drizzle, Kysely, Django, TypeORM, and golang-migrate.
2 Updated 1 weeks ago
Mixard API & Backend Listed
db-migration-generator
Generate database schema migration scripts (Prisma/TypeORM/Alembic) based on model changes.
1 Updated 1 weeks ago
RMAzrim