skills.rest
sckroll
sckrollCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/sckroll/nextjs-mariadb-sample --skill drizzle-orm-sckroll
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
bluebricks-nlbluebricks-nl

prisma-database-setup

Configure Prisma ORM with PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, and CockroachDB.

Official
Intermediate
DexploarerDexploarer
7

drizzle-migration

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

Community
Intermediate
blockmaticblockmatic
88

Drizzle ORM

Build type-safe SQL queries and migrations for PostgreSQL, MySQL, and SQLite in TypeScript.

Official
Advanced
jagreehaljagreehal
3

strict-typescript

Enforce advanced TypeScript tsconfig flags and ESLint governance for compile-time safety.

Community
Advanced