skills.rest
promptlylabs
promptlylabsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

drizzle-orm

Enable type-safe SQL queries for TypeScript projects with Drizzle ORM.

Updated Aug 23, 2026
Search Tags:#typescript#drizzle#migrations#queries#sql#orm#edge-runtime
One-click install
npx skills add https://github.com/promptlylabs/skills --skill drizzle-orm-promptlylabs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: drizzle-orm
Source: https://github.com/promptlylabs/skills/tree/main/plugins/promptly-skills/skills/drizzle-orm
Command: npx skills add https://github.com/promptlylabs/skills --skill drizzle-orm-promptlylabs

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Type-safe SQL-first data access for TypeScript projects with minimal runtime overhead, eliminating unsafe string-building and drift between schema and queries.

Core Features & Use Cases

  • Type-safe schema definitions and queries for PostgreSQL, MySQL, and SQLite with first-class TS types
  • Rich query builder with joins, relations, aggregates, CTEs, and window functions
  • Zero-runtime-dependency runtime, fast cold starts, and excellent tree-shakeability for edge/servers
  • Integrated migrations via drizzle-kit and introspection for existing databases

Quick Start

Install drizzle-orm and drizzle-kit, configure a DB connection, define a table, and run a simple query.

Frequently Asked Questions about drizzle-orm

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

FAQPage Schema
What is a zero-runtime type-safe SQL ORM for TypeScript?▼

It enables type-safe schema definitions and queries for PostgreSQL, MySQL, and SQLite with first-class TypeScript types, eliminating unsafe string-building and drift between schema and queries.

How do I run database migrations in TypeScript using drizzle-kit?▼

You configure a database connection, define your TS schema, and use drizzle-kit to generate and run migrations, enabling introspection for existing databases to keep schemas synchronized.

Does this type-safe ORM work with edge runtime environments?▼

Yes, the zero-runtime-dependency design ensures fast cold starts and excellent tree-shakeability, making it highly suitable for edge runtime and serverless TypeScript deployments.

Can I use raw SQL and complex query patterns like CTEs with a TypeScript ORM?▼

Yes, the query builder offers first-class support for raw SQL alongside complex patterns including joins, relations, aggregates, CTEs, and window functions for advanced data access.

What is the best way to avoid schema drift in TypeScript SQL projects?▼

Using a type-safe SQL-first ORM with integrated migrations and introspection prevents drift by keeping TypeScript schema definitions and database queries strictly synchronized at compile-time.

Why choose a zero-runtime ORM over other TypeScript database tools?▼

A zero-runtime ORM delivers compile-time type safety and SQL-first query building without the runtime overhead of traditional ORMs, ensuring fast cold starts and optimal tree-shakeability for edge servers.

Related Skills

Explore More Software Engineering Skills→
dduquennedduquenne
1

databasix

Design, migrate, and secure Supabase data layers for TypeScript apps.

Community
Advanced
jayantrohila57jayantrohila57

atelier-typescript-drizzle-orm

Define SQL schemas and write type-safe queries with Drizzle ORM.

Community
Advanced
DexploarerDexploarer
7

drizzle-migration

Generate and apply Drizzle Kit SQL migrations from TypeScript schema changes.

Community
Intermediate
raphaelandrewsraphaelandrews
1

drizzle-orm

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

Community
Advanced