__drizzle_migrations table

// drizzle.config.js
import 'dotenv/config'
import { defineConfig } from 'drizzle-kit'

/** @type { import("drizzle-kit").Config } */
export default defineConfig({
  schema: 'src/db/schema.*',
  out: 'src/db/migrations',
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DATABASE_URL,
  },
  verbose: true,
  strict: false,
  schemaFilter: ['public'],
})

// src/db/index.ts
import { drizzle } from 'drizzle-orm/node-postgres'
import { Client } from 'pg'
import * as schema from './schema'

export const client = new Client(process.env.DATABASE_URL)
export const db = drizzle(client, { schema })

// src/db/migrate.ts
import 'dotenv/config'
import { resolve } from 'path'
import { client, db } from './'
import { migrate } from 'drizzle-orm/node-postgres/migrator'
export default async () => {
  await client.connect()
  await migrate(db, { migrationsFolder: resolve(__dirname, './migrations') })
  await client.end()