DRZL

Zero‑friction codegen for Drizzle ORM. Analyze your schema. Generate validation, services, and routers fast.

Sponsor

• GitHub Sponsors: https://github.com/sponsors/omar-dulaimi
• Want something prioritized? Look for issues labeled sponsor-wanted (or open one) and DM @omardulaimidev so we can reserve it for you.
• Custom template/generator/adapter requests happen via X DM. Paid work ships back into DRZL so everyone benefits.

What’s Inside

• Analyzer: turns Drizzle schemas into a normalized analysis model
• Generators: Zod, Valibot, ArkType, TypeBox and Effect Schema validation; JSON Schema and OpenAPI; typed CRUD services; routers for oRPC, tRPC, Hono, Express, Fastify, NestJS and GraphQL; and an MCP server whose tools carry the table's CHECK constraints into what a model is allowed to write. Twenty-seven in all, and installing @drzl/cli brings every one of them
• Batteries: formatting, naming, reusable/shared schemas, relation support
• Monorepo: pnpm workspace, lockstep releases with Changesets

Verified against three real databases

Postgres in-process via PGlite, SQLite via node:sqlite, and MySQL as a CI service container, on every commit. The run behind this README printed:

    1476 probes against a real Postgres (41 columns)
    59 CHECK probes against a real Postgres (15 constrained columns)
    rows Postgres rejects and the validator accepts: DRZL 0, drizzle-orm 24
    32 CHECK probes against a real SQLite (10 constrained columns)
    37 probes against a real MySQL

Those lines are compared against the run itself, line by line, by scripts/verify/stages/35-docs-numbers.sh, so a number here that stops being true fails the build rather than sitting in a README nobody rechecks. See how it is verified.

Install & Use

• Install the CLI and init a config

pnpm add @drzl/cli -D
pnpm drzl init

• Generate code

pnpm drzl generate -c drzl.config.ts

Minimal config

// drzl.config.ts
import { defineConfig } from '@drzl/cli/config';

export default defineConfig({
  schema: 'src/db/schemas/index.ts',
  outDir: 'src/api',
  generators: [
    { kind: 'zod', path: 'src/validators/zod' },
    { kind: 'service', path: 'src/services', dataAccess: 'drizzle' },
    { kind: 'orpc', template: '@drzl/template-orpc-service' },
  ],
});

Runtime

• ESM / ES2021 output
• Node ≥ 22 for the drzl CLI, which is what its own dependencies require
• Node ≥ 18.17 for the generator and template libraries, if you call them directly

Packages

• packages/analyzer: schema analysis
• packages/cli: CLI (drzl)
• packages/generator-orpc: oRPC router generator
• packages/generator-trpc: tRPC v11 router generator
• packages/generator-hono: Hono route generator
• packages/generator-express: Express 5 router generator
• packages/generator-fastify: Fastify 5 plugin generator
• packages/generator-nestjs: NestJS DTO and entity class generator
• packages/generator-graphql: GraphQL SDL and resolver-stub generator
• packages/generator-effect-http: Effect Platform HttpApi generator
• packages/generator-h3: h3 and Nitro route handler generator
• packages/generator-elysia: Elysia route generator
• packages/generator-seed: constraint-satisfying seed data generator
• packages/generator-fast-check: constraint-bounded fast-check arbitrary generator
• packages/generator-pothos: Pothos schema builder generator
• packages/generator-ts-rest: ts-rest contract generator
• packages/generator-openapi-fetch: typed openapi-fetch client generator
• packages/generator-forms: react-hook-form and TanStack Form resolver and field-metadata generator
• packages/generator-ai: AI SDK tool generator
• packages/generator-mcp: Model Context Protocol tool generator
• packages/generator-next: Next.js server action generator
• packages/generator-tanstack-start: TanStack Start server function generator
• packages/generator-service: typed service generator
• packages/generator-zod: Zod generator
• packages/generator-valibot: Valibot generator
• packages/generator-arktype: ArkType generator
• packages/generator-typebox: TypeBox generator
• packages/generator-effect: Effect Schema generator
• packages/generator-json-schema: JSON Schema and OpenAPI generator
• packages/validation-core: shared validation utilities
• packages/template-orpc-service: oRPC router template (service‑backed)
• packages/template-standard: minimal oRPC router template

See each package’s README for details.

Development

• Install: pnpm install
• Build: pnpm -r run build
• Test: pnpm -r test
• Lint: pnpm lint

Examples

Runnable applications live in examples/. They are workspace members that depend on the workspace copy of @drzl/cli, so pnpm build and pnpm -r test cover them and a regression in a generator breaks them.

• examples/nextjs-server-actions: a Drizzle schema, drzl generate, and the emitted zod schemas validating what a form posts to a Next.js server action, with field errors attributed to the constraint that caused them.

Docs

VitePress site lives in docs/ (kept out of releases). Local dev:

pnpm -C docs dev

Funded Features

• None yet. Be the first! If you need a template, generator, or adapter that doesn’t exist yet, DM me on X (https://x.com/omardulaimidev) and we can scope a sponsored build. Funded work lands in this repo under Apache‑2.0 so everyone benefits.

Contributing

Contributions welcome. See CONTRIBUTING.md.

License

Apache-2.0