drizzle-orm

Build type-safe SQL queries with Drizzle ORM in TypeScript.

Updated Jan 24, 2026
One-click install
npx skills add https://github.com/Ikki-Group/erp --skill drizzle-orm-ikki-group
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: drizzle-orm
Source: https://github.com/Ikki-Group/erp/tree/main/.agents/skills/drizzle-orm
Command: npx skills add https://github.com/Ikki-Group/erp --skill drizzle-orm-ikki-group

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Type-safe TypeScript-first ORM with zero runtime overhead helps developers build robust data access layers with compile-time guarantees and minimal runtime bloat.

Core Features & Use Cases

  • Type-safe schema definitions and queries with strong type inference
  • Seamless migrations and schema evolution
  • Edge/runtime friendly integration with SQL-first approach

Quick Start

Install drizzle-orm and initialize a Drizzle client in your project to start building type-safe queries.

Frequently Asked Questions about drizzle-orm

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

FAQPage Schema
What is a type-safe TypeScript ORM with zero runtime overhead?

A type-safe TypeScript ORM with zero runtime overhead enables developers to build robust data access layers with compile-time guarantees and minimal runtime bloat. It ensures type-safe schema definitions and queries through strong type inference.

How do I build type-safe SQL queries for serverless and edge environments?

To build type-safe SQL queries for serverless and edge environments, you initialize a Drizzle client in your project. This enables an edge-friendly, SQL-first approach to construct queries with compile-time type guarantees.

Can I manage database migrations and schema evolution with a SQL-first ORM?

Yes, you can manage database migrations and schema evolution seamlessly. This approach ensures your type-safe schema definitions evolve consistently across your application without disrupting existing query patterns.

Does a zero runtime overhead TypeScript ORM support complex query patterns like joins and CTEs?

A zero runtime overhead TypeScript ORM supports complex query patterns including joins, Common Table Expressions (CTEs), and window functions. It applies these patterns while maintaining strict type inference and compile-time guarantees.

What's the best way to define a type-safe database schema in TypeScript?

The best way to define a type-safe database schema in TypeScript is using a Drizzle client. It provides strong type inference for schema definitions and queries, ensuring compile-time guarantees with minimal runtime bloat.

Why use a SQL-first ORM for edge runtime environments?

Using a SQL-first ORM for edge runtime environments ensures minimal runtime bloat and seamless integration. It provides compile-time type guarantees for your data access layer without adding overhead to resource-constrained edge platforms.