setup-database

To set up Drizzle migrations with Neon Postgres, wire your DATABASE_URL connection string into your environment, configure the Drizzle ORM, and generate initial migration scripts with safe defaults. You then review the generated SQL before applying any schema changes.

The safest way to add columns and indexes is generating a schema migration that explicitly shows the SQL for review. You must confirm any destructive operations before execution, ensuring the ORM conventions verify changes through checks and studio visibility.

To fix a broken database migration, diagnose the migration state by inspecting your migration history. The system analyzes the sequence to explain what failed and outlines the exact next steps required to recover your schema safely.

Yes, you can use raw SQL for schema migrations. The system detects your ORM and supports Drizzle, Prisma, Kysely, and raw SQL conventions, generating reviewed migration steps that require explicit confirmation before running destructive operations.

Database setup requires SQL review to prevent destructive operations from breaking your application. Showing generated SQL before applying migrations ensures you explicitly confirm schema additions, changes, and constraint drops, maintaining migration safety.