drizzle-orm

Provide a type-safe SQL-first API for TypeScript database applications.

1|1|Updated May 15, 2025
One-click install
npx skills add https://github.com/raphaelandrews/fsx --skill drizzle-orm-raphaelandrews
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: drizzle-orm
Source: https://github.com/raphaelandrews/fsx/tree/main/.agents/skills/drizzle-orm
Command: npx skills add https://github.com/raphaelandrews/fsx --skill drizzle-orm-raphaelandrews

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Drizzle-ORM provides a type-safe SQL-first API for TypeScript to build robust database applications.

Core Features & Use Cases

  • Type-safe schema definitions and relations, enabling compile-time guarantees for your database layer.
  • Rich querying capabilities including joins, CTEs, window functions, and raw SQL integration.
  • Migrations and edge-runtime support with zero-runtime dependencies for fast, modern apps.

Quick Start

Install drizzle-orm, configure a database connection, and start building type-safe queries with a TypeScript-first API.

Frequently Asked Questions about drizzle-orm

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

FAQPage Schema
How do I build type-safe SQL queries in TypeScript?▼

You can build type-safe SQL queries in TypeScript by using a SQL-first ORM API that infers types directly from your schema definitions. This approach enforces compile-time guarantees for your database layer without adding runtime overhead.

Does this TypeScript ORM support raw SQL execution?▼

Yes, the TypeScript ORM provides first-class support for raw SQL integration alongside its query builder. You can execute raw SQL statements while maintaining type inference for safe database interactions.

How do I manage database schema migrations in TypeScript?▼

You manage database schema migrations in TypeScript by defining your schema and using the ORM's built-in migration tools. This handles schema versioning and relations across PostgreSQL, MySQL, and SQLite environments.

What is the best way to handle database transactions in a TypeScript ORM?▼

The best way to handle database transactions in a TypeScript ORM is using a tool with dedicated transaction and batch operation support. This ensures atomic multi-query execution while maintaining strict runtime type safety.

Can I use a TypeScript ORM with edge-runtime environments?▼

Yes, you can use this TypeScript ORM with edge-runtime environments because it features zero-runtime dependencies. This ensures fast execution and compatibility with modern serverless deployment platforms.

Does this ORM support PostgreSQL, MySQL, and SQLite?▼

Yes, the ORM supports PostgreSQL, MySQL, and SQLite. It provides a unified type-safe API to manage schema definitions, relations, and queries across all three database systems.