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.