Neon Serverless Postgres 완벽 가이드 — 브랜칭, Drizzle 통합, 2026 요금 총정리

패키지 설치
npm install drizzle-orm @neondatabase/serverless
npm install -D drizzle-kit

db/index.ts — Neon HTTP 드라이버 설정 (Vercel/Edge)
import { neon } from '@neondatabase/serverless';
import { drizzle } from 'drizzle-orm/neon-http';
import * as schema from './schema';

const sql = neon(process.env.DATABASE_URL!);
export const db = drizzle(sql, { schema });

db/schema.ts — 스키마 예시
import { pgTable, serial, text, timestamp } from 'drizzle-orm/pg-core';

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

drizzle.config.ts
import type { Config } from 'drizzle-kit';

export default {
  schema: './db/schema.ts',
  out: './drizzle',
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DATABASE_URL!
  }
} satisfies Config;

마이그레이션 실행
# 마이그레이션 파일 생성
npx drizzle-kit generate

# Neon DB에 적용
npx drizzle-kit migrate

.github/workflows/preview.yml — PR별 Neon 브랜치 자동 생성
name: Preview DB Branch
on:
  pull_request:
    types: [opened, synchronize, reopened]

jobs:
  create-branch:
    runs-on: ubuntu-latest
    steps:
      - uses: neondatabase/create-branch-action@v5
        id: create-branch
        with:
          project_id: ${{ secrets.NEON_PROJECT_ID }}
          api_key: ${{ secrets.NEON_API_KEY }}
          branch_name: preview/pr-${{ github.event.number }}
      
      - name: Comment PR with DB URL
        uses: actions/github-script@v7
        with:
          script: |
            github.rest.issues.createComment({
              issue_number: context.issue.number,
              owner: context.repo.owner,
              repo: context.repo.repo,
              body: 'Preview DB: `${{ steps.create-branch.outputs.db_url }}`'
            })