Skip to main content
CRUD, Not an ORM

Type-Safe SQL for
Modern Codebases

A PostgreSQL Query Builder and Migration Manager for TypeScript, from the future. Experience type safety and robust migration management.

Get StartedGitHub
import { asc, eq } from "durcno";
import { db } from "./db/index.ts";
import { Users } from "./db/schema.ts";

// Fully typed result inferred from schema
const admins = await db
  .from(Users)
  .select({
    id: Users.id,
    name: Users.name,
    email: Users.email
  })
  .where(eq(Users.type, "admin"))
  .orderBy(asc(Users.name))
  .limit(10);

// admins: { id: bigint; name: string; email: string }[]
Agentic DX

Built for AI Agents

Durcno ships with an official Agent Skill. Empower your AI agents with deep knowledge of Durcno and its robust type-safety.

$npx skills add https://github.com/durcno/durcno --skill durcno

Works with your favorite runtime

Node.jsNode.js
BunBun
DenoDeno

Built for the Postgres Ecosystem

Fully validated and optimized for production use.

PostgreSQLPostgreSQL
PGlitePGlite

Smart Migrations

Auto-generated, reversible, and squashable migrations. Roll back safely or consolidate history with a single command — production-ready schema management out of the box.

Zod Validation

Runtime validation made easy. Durcno automatically generates Zod schemas inferred directly from your table definitions alongside strict TypeScript types.

PostGIS Built-in

First-class support from day one. Use built-in geography columns with geojson date types and fully type-safe spatial operations & filters.

Loved by Developers?

"Finally a query builder that doesn't get in your way. 🚀 @durcno"

"Durcno's migration system is rock-solid. Auto generated, reversible and squashable migrations."

"Durcno is like PostgreSQL but type-safe. It's like using PostgreSQL on steroids."

Sponsors

Be the first to sponsor Durcno!

+ Your Logo Here