How does it handle TypeScript types?

It leverages Drizzle's built-in type inference features like $inferSelect and $inferInsert to ensure end-to-end type safety without duplicating interfaces.

Does it support Drizzle's Relational Query API?

Yes, it provides detailed patterns for setting up relations and using the db.query syntax for efficient, nested data fetching.

Which databases does this Drizzle ORM skill support?

This skill supports PostgreSQL, MySQL, SQLite, Cloudflare D1, and Cloudflare Durable Objects, providing specific patterns for each.

Can it help with architectural patterns?

Absolutely. It includes specific guidance for implementing the Repository and Entity patterns to decouple database logic from your core business logic.

Drizzle ORM for TypeScript

Name: Drizzle ORM for TypeScript
Author: martinffx

bymartinffx

•

Database Management

Simplifies database management with type-safe SQL schemas, relational queries, and design patterns for Drizzle ORM in TypeScript.

This skill equips Claude with specialized knowledge for working with Drizzle ORM across multiple database engines including PostgreSQL, MySQL, SQLite, and Cloudflare D1. It provides optimized patterns for defining type-safe schemas, managing complex relational queries, and implementing robust architectural patterns like Repositories and Entities. Whether you are setting up migrations, performing CRUD operations, or architecting a clean data layer, this skill ensures best practices for type inference, optimistic locking, and data transformation are maintained throughout your development workflow.

Key Features

01Type-safe schema definitions for PostgreSQL, MySQL, SQLite, and Cloudflare D1

02Automatic type inference using $inferSelect and $inferInsert to avoid manual interface duplication

03Comprehensive support for transactions, complex joins, and optimistic locking mechanisms

0418 GitHub stars

05Implementation of Repository and Entity patterns for clean, scalable architecture

06Advanced Relational Query API setup with automated nested relation mapping

Use Cases

01Designing and migrating type-safe database schemas for modern TypeScript backends

02Developing serverless applications on Cloudflare Workers using D1 or Durable Objects

03Building scalable data access layers using the Repository and Entity design patterns

Key Features

01Type-safe schema definitions for PostgreSQL, MySQL, SQLite, and Cloudflare D1

02Automatic type inference using $inferSelect and $inferInsert to avoid manual interface duplication

03Comprehensive support for transactions, complex joins, and optimistic locking mechanisms

0418 GitHub stars

05Implementation of Repository and Entity patterns for clean, scalable architecture

06Advanced Relational Query API setup with automated nested relation mapping

Use Cases

01Designing and migrating type-safe database schemas for modern TypeScript backends

02Developing serverless applications on Cloudflare Workers using D1 or Durable Objects

03Building scalable data access layers using the Repository and Entity design patterns