drizzle

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

7 stars

byG1Joshi

View on GitHub Installation ↓

Best use case

drizzle is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

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

Teams using drizzle should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

You only need a quick one-off answer and do not need a reusable workflow.
You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/drizzle/SKILL.md --create-dirs "https://raw.githubusercontent.com/G1Joshi/Agent-Skills/main/skills/frameworks/drizzle/SKILL.md"

Manual Installation

Download SKILL.md from GitHub
Place it in .claude/skills/drizzle/SKILL.md inside your project
Restart your AI agent — it will auto-discover the skill

How drizzle Compares

Feature / Agent	drizzle	Standard Approach
Platform Support	Not specified	Limited / Varies
Context Awareness	High	Baseline
Installation Complexity	Unknown	N/A

Frequently Asked Questions

What does this skill do?

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

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

SKILL.md Source

# 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/)