drizzle-orm

Define TypeScript database schemas and queries for PostgreSQL, MySQL, and SQLite.

Updated Mar 11, 2026

Search Tags:#type safety #typescript #database #migrations #sql #drizzle orm #orm

Ready to run

npx skills add https://github.com/sckroll/nextjs-mariadb-sample --skill drizzle-orm-sckroll

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: drizzle-orm
Source: https://github.com/sckroll/nextjs-mariadb-sample/tree/main/.agents/skills/drizzle-orm
Command: npx skills add https://github.com/sckroll/nextjs-mariadb-sample --skill drizzle-orm-sckroll

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies database interactions in TypeScript applications by providing a type-safe way to define schemas, write queries, and manage migrations, eliminating runtime errors and improving developer productivity.

Core Features & Use Cases

Type-Safe Queries: Write SQL queries directly in TypeScript with full type checking.
Schema Definition: Define database schemas using a familiar TypeScript syntax.
Migrations: Generate and apply database schema changes using Drizzle Kit.
Use Case: When building a new feature that requires complex data retrieval and manipulation, use Drizzle ORM to ensure all database operations are type-safe and efficient, preventing common bugs related to data mismatches.

Quick Start

Use the drizzle-orm skill to set up a new PostgreSQL database schema with users and posts tables.

Frequently Asked Questions about drizzle-orm

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

FAQPage Schema

How do I write type-safe SQL queries in TypeScript without runtime overhead?▼

A type-safe ORM like Drizzle enables type-safe SQL queries in TypeScript with zero runtime overhead, offering compile-time checking and SQL-like syntax for database operations.

What's the best way to define database schemas for PostgreSQL and MySQL in TypeScript?▼

Defining database schemas for PostgreSQL and MySQL in TypeScript is best done with an ORM that supports familiar TypeScript syntax, ensuring type safety across PostgreSQL, MySQL, and SQLite engines.

How do I generate and apply database migrations using Drizzle Kit?▼

You generate and apply database migrations using Drizzle Kit to manage schema changes. It automates migration generation and application, ensuring schema updates are tracked and applied efficiently for PostgreSQL, MySQL, and SQLite.

Does this TypeScript ORM support relations and transactions?▼

Yes, this TypeScript ORM supports relations and transactions. It facilitates schema definition, query writing, relations, and transactions for PostgreSQL, MySQL, and SQLite, enabling efficient database operations with compile-time safety.

Can I use Drizzle ORM for complex data retrieval and manipulation in TypeScript?▼

Yes, you can use Drizzle ORM for complex data retrieval and manipulation in TypeScript. It ensures all database operations are type-safe and efficient, preventing common bugs related to data mismatches during feature development.