Drizzle

Add a drizzle.config.empty.ts file

drizzle.config.empty.ts is a minimal drizzle-kit config that loads DATABASE_URL (preferring .env.local for non-production) and defines the target schema as itself. This config is used as a safe "empty schema" so drizzle-kit push --force can reset the database to no tables.

import * as dotenv from "dotenv"
import { defineConfig } from "drizzle-kit";

dotenv.config()

if (process.env.NODE_ENV !== "production") {
  dotenv.config({ path: ".env.local" })
}

if (!process.env.DATABASE_URL) {
  throw new Error("DATABASE_URL is not set")
}

export default defineConfig({
  dbCredentials: {
    url: process.env.DATABASE_URL,
  },
  dialect: "postgresql",
  schema: './drizzle.config.empty.ts',
});

Here's the script to reset the db then: npx drizzle-kit push --force --config ./drizzle.config.empty.ts

Quick Start

Use these scripts from package.json:

• •pnpm generate: generate SQL migrations from the Drizzle schema
• •pnpm push: push the current schema to the database
• •pnpm reset: force-reset the database using drizzle.config.empty.ts
• •pnpm studio: open Drizzle Studio

{
  "scripts": {
    "generate": "drizzle-kit generate",
    "push": "drizzle-kit push",
    "reset": "npx drizzle-kit push --force --config ./drizzle.config.empty.ts",
    "studio": "drizzle-kit studio"
  }
}