Database | Verge Kit

Verge Kit uses Cloudflare D1 and Drizzle by default. For a self-hosted server, use the Node.js + MySQL preset.

The Drizzle schema is in src/config/schema.ts.

Binding and usage

The default preset exposes D1 through the DB binding in wrangler.jsonc. See the D1 binding reference for configuration details.

Keep database queries in server modules.

Import the configured database client from @/db:

import { db } from '@/db';

const rows = await db.select().from(user);

Schema and migrations

Drizzle Kit stores generated SQL and migration history in migrations/. Use the project scripts instead of drizzle-kit push or drizzle-kit migrate.

Command	Task
`npm run db:generate`	Generate SQL from the schema
`npm run db:migrate:local`	Apply migrations to local D1
`npm run db:migrate:remote`	Apply migrations to remote D1

The migration flow is: edit the schema, generate SQL, review it, migrate locally, and commit the files. Migrate remote D1 before deploying dependent code.

See the D1 migrations guide for migration behavior and the Time Travel guide for recovery.

Production D1

Create the production database once:

npx wrangler d1 create vk

Copy the returned database_id into the DB binding in wrangler.jsonc.

Apply the migrations before you deploy code that needs them:

npm run db:migrate:remote

Use a separate D1 database for each deployed environment. See the Wrangler D1 command reference for more commands.