# Drizzle

> Drizzle TypeScript ORM with SQL-like syntax. Use for database access.

- Skill: `g1joshi/drizzle` (Agent Skill)
- Install (CLI): `npx skillmds@latest add g1joshi/drizzle`
- Raw SKILL.md: https://api.skillmd.com/api/skills/g1joshi/drizzle/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: G1Joshi (https://skillmd.com/u/g1joshi)
- Updated: 2026-09-10
- Page: https://skillmd.com/skills/g1joshi/drizzle

---


# Drizzle ORM

Drizzle is the lightweight challenger to Prisma. v0.30+ (2025) focuses on **SQL-like** syntax, zero dependencies at runtime, and extreme cold-start performance.

## When to Use

- **Serverless**: Zero runtime overhead makes it perfect for Lambdas.
- **SQL Lovers**: You prefer `db.select().from(users)` over object APIs.
- **Performance**: Faster query building than Prisma.

## Core Concepts

### Schema Definition

Define tables in TS. `export const users = pgTable('users', { ... })`.

### Query Builder

Composable, type-safe SQL builder.

### Relational API

`db.query.users.findMany({ with: { posts: true } })` (Prisma-like convenience).

## Best Practices (2025)

**Do**:

- **Use `drizzle-kit`**: For migration management.
- **Use `run`**: Explicit execution model.
- **Use Driver Specifics**: Drizzle embraces database-specific features (JSONB, Arrays).

**Don't**:

- **Don't over-abstract**: Drizzle shines when you stay close to SQL.

## References

- [Drizzle ORM Documentation](https://orm.drizzle.team/)