Quick start

Lets build a quick start app with PostgreSQL + postgresjs and run our first migration

npm install drizzle-orm postgres
npm install -D drizzle-kit

Lets declare our schema.ts

📦 <project root>
 ├ ...
 ├ 📂 src
 │ └ 📜 schema.ts
 └ 📜 package.json

schema.ts

import { serial, text, timestamp, pgTable } from "drizzle-orm/pg-core";
 
export const user = pgTable("user", {
  id: serial("id"),
  name: text("name"),
  email: text("email"),
  password: text("password"),
  role: text("role").$type<"admin" | "customer">(),
  createdAt: timestamp("created_at"),
  updatedAt: timestamp("updated_at"),
});

Now lets add drizzle configuration file

📦 <project root>
 ├ ...
 ├ 📂 src
 ├ 📜 drizzle.config.ts
 └ 📜 package.json

import type { Config } from "drizzle-kit";
 
export default {
  schema: "./src/schema.ts",
  out: "./drizzle",
} satisfies Config;

Add generate command to package.json and run our first migrations generation

package.json

{
  "name": "first time?",
  "version": "0.0.1",
  "scripts": {
    "generate": "drizzle-kit generate:pg",
  }, 
}

terminal

$ npm run generate
...
 
[✓] Your SQL migration file ➜ drizzle/0000_pale_mister_fear.sql 🚀

Done! We now have our first SQL migration file

📦 <project root>
 ├ 📂 drizzle
 │ ├ 📂 _meta
 │ └ 📜 0000_pale_mister_fear.sql
 ├ 📂 src
 ├ 📜 drizzle.config.ts
 └ 📜 package.json

Now lets run our first migration to the database

📦 <project root>
 ├ 📂 drizzle
 ├ 📂 src
 │ ├ 📜 schema.ts
 │ └ 📜 index.ts
 ├ 📜 drizzle.config.ts
 └ 📜 package.json

index.ts

import { drizzle } from "drizzle-orm/postgres-js";
import { migrate } from "drizzle-orm/postgres-js/migrator";
import postgres from "postgres";
 
const connectionString = "..."
const sql = postgres(connectionString, { max: 1 })
const db = drizzle(sql);
 
await migrate(db, { migrationsFolder: "drizzle" });

That's it, folks!
My personal congratulations 🎉

Overview Configuration