drizzle-orm

Provides version-aware TypeScript/Drizzle ORM schema, query, and migration guidance for relational databases.

8|Updated Jan 19, 2026
One-click install
npx skills add https://github.com/OiAnthony/.agents --skill drizzle-orm-oianthony
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: drizzle-orm
Source: https://github.com/OiAnthony/.agents/tree/main/skills/drizzle-orm
Command: npx skills add https://github.com/OiAnthony/.agents --skill drizzle-orm-oianthony

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps developers use Drizzle ORM correctly and consistently across schema design, querying, migrations, and TypeScript typing, reducing version mismatch errors and database-specific mistakes.

Core Features & Use Cases

  • Schema design: Create PostgreSQL, MySQL, and SQLite tables, indexes, constraints, enums, and type-safe models.
  • Query workflows: Write relational queries, joins, filters, CRUD operations, transactions, and dynamic query builders with accurate type inference.
  • Migration guidance: Plan and run Drizzle Kit workflows while accounting for dialect limitations, relation syntax changes, and common gotchas.
  • Use case: When upgrading a TypeScript app or adding a new table, this Skill can recommend the right imports, relation style, and migration path for the installed Drizzle version.

Quick Start

Ask for Drizzle ORM help on your current schema, query, or migration task and include the database dialect and installed version so the Skill can generate version-aware TypeScript guidance.

Frequently Asked Questions about drizzle-orm

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define type-safe database schemas with Drizzle ORM in TypeScript?

Drizzle ORM schema design builds type-safe PostgreSQL, MySQL, and SQLite tables, indexes, and constraints. It generates TypeScript models with accurate type inference, ensuring database structures match relational query workflows.

What's the best way to run database migrations using Drizzle Kit?

Drizzle Kit migration workflows plan and execute schema changes while accounting for dialect limitations and relation syntax changes. It generates version-aware migration paths for PostgreSQL, MySQL, and SQLite, avoiding common upgrade gotchas.

How do relational queries and joins work with Drizzle ORM?

Drizzle ORM relational queries support joins, filters, CRUD operations, and dynamic query builders with precise type inference. It enables complex relational data retrieval across PostgreSQL, MySQL, and SQLite without losing TypeScript type safety.

Does Drizzle ORM support serverless relational database workflows?

Drizzle ORM supports serverless relational workflows across PostgreSQL, MySQL, and SQLite. It provides dialect-specific imports and version-aware API selection, ensuring type inference and CRUD operations function correctly in serverless environments.

Why does my Drizzle ORM migration fail after upgrading to a new version?

Drizzle ORM migrations can fail due to version mismatch errors, dialect limitations, or relation syntax changes between releases. Version-aware API selection and documentation-backed recommendations matching the installed Drizzle release resolve these inconsistencies.

Can I use Drizzle ORM for both PostgreSQL and SQLite in the same TypeScript project?

Drizzle ORM standardizes schema, query, and migration guidance across PostgreSQL, MySQL, and SQLite. It requires dialect-specific imports and version-aware API selection, allowing you to maintain type-safe models for multiple database dialects simultaneously.