npm install corsair drizzle-orm
npx corsair init --orm drizzle

import { pgTable, text, timestamp, boolean } from 'drizzle-orm/pg-core'
import { relations } from 'drizzle-orm'

export const users = pgTable('users', {
  id: text('id').primaryKey(),
  email: text('email').notNull().unique(),
  name: text('name'),
  createdAt: timestamp('created_at').defaultNow(),
  updatedAt: timestamp('updated_at').defaultNow(),
})

export const posts = pgTable('posts', {
  id: text('id').primaryKey(),
  title: text('title').notNull(),
  content: text('content').notNull(),
  published: boolean('published').default(false),
  authorId: text('author_id').references(() => users.id),
  createdAt: timestamp('created_at').defaultNow(),
  updatedAt: timestamp('updated_at').defaultNow(),
})

export const usersRelations = relations(users, ({ many }) => ({
  posts: many(posts),
}))

export const postsRelations = relations(posts, ({ one }) => ({
  author: one(users, {
    fields: [posts.authorId],
    references: [users.id],
  }),
}))

import { defineConfig } from 'corsair'

export default defineConfig({
  orm: 'drizzle',
  database: {
    type: 'postgresql',
    url: process.env.DATABASE_URL,
  },
  schema: './src/db/schema.ts',
})

npx corsair generate

// Natural language
useCorsairQuery('all published posts with authors')

// Generates Drizzle query
db.query.posts.findMany({
  where: eq(posts.published, true),
  with: { author: true },
})

// One-to-many
useCorsairQuery('user with all their posts')

// Drizzle equivalent
db.query.users.findFirst({
  where: eq(users.id, userId),
  with: { posts: true },
})

// Date filtering
useCorsairQuery('posts created after January 1st 2024')

// Drizzle equivalent
db.select()
  .from(posts)
  .where(gte(posts.createdAt, new Date('2024-01-01')))

// Create
const { mutate } = useCorsairMutation('create post')
mutate({
  title: 'Hello World',
  content: 'My first post',
  authorId: userId,
})

// Drizzle equivalent
db.insert(posts).values({
  title: 'Hello World',
  content: 'My first post',
  authorId: userId,
})

// Transaction
const { mutate } = useCorsairMutation('create user with first post')

mutate({
  email: 'user@example.com',
  name: 'John Doe',
  post: {
    title: 'My First Post',
    content: 'Hello world',
  },
})

// Drizzle equivalent
db.transaction(async tx => {
  const [user] = await tx
    .insert(users)
    .values({
      email,
      name,
    })
    .returning()

  await tx.insert(posts).values({
    ...post,
    authorId: user.id,
  })
})

# Generate migration
npx drizzle-kit generate

# Apply migrations
npx corsair migrate apply

import type { Config } from 'drizzle-kit'

export default {
  schema: './src/db/schema.ts',
  out: './drizzle',
  driver: 'pg',
  dbCredentials: {
    connectionString: process.env.DATABASE_URL!,
  },
} satisfies Config