skills.rest
pascallammers
pascallammersCOMMUNITY
Explore all skills by this author →
GitHub

drizzle

Define type-safe database schemas and queries with Drizzle ORM.

1|Updated Sep 26, 2025
Search Tags:#type safety#typescript#database#migrations#sql#drizzle orm#orm
One-click install
npx skills add https://github.com/pascallammers/mylo-travel-concierge-v2 --skill drizzle-pascallammers
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: drizzle
Source: https://github.com/pascallammers/mylo-travel-concierge-v2/tree/main/.factory/skills/drizzle
Command: npx skills add https://github.com/pascallammers/mylo-travel-concierge-v2 --skill drizzle-pascallammers

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies database interactions by providing a type-safe way to define schemas, write queries, and manage migrations, reducing common errors and improving developer productivity.

Core Features & Use Cases

  • Schema Definition: Define database schemas with type safety across multiple SQL dialects (PostgreSQL, MySQL, SQLite).
  • Type-Safe Queries: Build queries using a SQL-like syntax that is fully type-checked by TypeScript.
  • Relations: Define and query complex relationships (one-to-many, many-to-many, etc.) between tables with type safety.
  • Migrations: Supports flexible migration strategies for evolving your database schema.
  • Use Case: Automatically generate TypeScript types for your database schema, write complex JOIN queries without fear of runtime errors, and ensure your database structure is always in sync with your application code.

Quick Start

Use the drizzle skill to define a PostgreSQL schema for users and posts tables with a one-to-many relationship.

Frequently Asked Questions about drizzle

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

FAQPage Schema
How do I define type-safe database schemas in TypeScript?▼

Type-safe database schemas are defined by declaring table structures with typed columns, constraints, and indexes directly in TypeScript, ensuring compile-time validation across PostgreSQL, MySQL, and SQLite dialects.

Can I query complex relationships like many-to-many using type-safe SQL?▼

Yes, type-safe SQL queries support complex relationships including one-to-many, one-to-one, and many-to-many relations, allowing you to build relational queries and JOINs with full TypeScript type checking.

Does Drizzle ORM work with PostgreSQL, MySQL, and SQLite?▼

Drizzle ORM works across PostgreSQL, MySQL, and SQLite dialects, providing a unified type-safe syntax for schema definition, query building, and relation mapping tailored to each specific SQL database.

What is the best way to manage database migrations with a TypeScript ORM?▼

The best way to manage database migrations involves leveraging flexible migration strategies provided by the ORM to evolve your database schema while keeping it strictly in sync with your TypeScript application code.

How do I handle self-referencing tables and generated columns in SQL?▼

Self-referencing tables and generated columns are handled through advanced schema definition patterns, enabling type-safe recursive relations and computed column declarations within your TypeScript database schema structure.

Related Skills

Explore More Software Engineering Skills→
gil00pitagil00pita

kysely

Construct type-safe SQL queries in TypeScript with PostgreSQL, MySQL, and SQLite support.

Community
Advanced
dmzoneilldmzoneill
2

data-migration-verify

Verify database migration correctness across PostgreSQL, MySQL, and SQLite.

Community
Advanced
ehylandehyland

trpc

Build and consume type-safe tRPC APIs with shared TypeScript types.

Community
Intermediate
HollowvynHollowvyn

kysely

Build type-safe SQL queries for TypeScript applications with Kysely generics.

Official
Intermediate