# Drizzle

> Drizzle is a modern TypeScript ORM developers wanna use in their next project. It is lightweight at only ~7.4kb minified+gzipped, and it's tree shakeable with exactly 0 dependencies. It supports every PostgreSQL, MySQL, SQLite and SingleStore database and is serverless-ready by design.

- Skill: `hk-vk/drizzle` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add hk-vk/drizzle`
- Raw SKILL.md: https://api.skillmd.com/api/skills/hk-vk/drizzle/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: DevOps & Infra
- Author: hk-vk (https://skillmd.com/u/hk-vk)
- Updated: 2026-09-10
- Page: https://skillmd.com/skills/hk-vk/drizzle

---


# Drizzle

> Drizzle is a modern TypeScript ORM developers wanna use in their next project. It is lightweight at only ~7.4kb minified+gzipped, and it's tree shakeable with exactly 0 dependencies. It supports every PostgreSQL, MySQL, SQLite and SingleStore database and is serverless-ready by design.

Drizzle is a modern TypeScript ORM developers wanna use in their next project. It is lightweight at only ~7.4kb minified+gzipped, and it's tree shakeable with exactly 0 dependencies. It supports every PostgreSQL, MySQL, SQLite and SingleStore database and is serverless-ready by design.

## Available Resources

### meet drizzle

- **Get started with Drizzle**
  - URL: https://orm.drizzle.team/docs/get-started

- **Get Started with Drizzle and PostgreSQL**
  - URL: https://orm.drizzle.team/docs/get-started/postgresql-new

- **Get Started with Drizzle and PostgreSQL in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/postgresql-existing

- **Get Started with Drizzle and Gel**
  - URL: https://orm.drizzle.team/docs/get-started/gel-new

- **Get Started with Drizzle and Gel in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/gel-existing

- **Get Started with Drizzle and SingleStore**
  - URL: https://orm.drizzle.team/docs/get-started/singlestore-new

- **Get Started with Drizzle and SingleStore in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/singlestore-existing

- **Get Started with Drizzle and Neon**
  - URL: https://orm.drizzle.team/docs/get-started/neon-new

- **Get Started with Drizzle and Neon in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/neon-existing

- **Get Started with Drizzle and Supabase**
  - URL: https://orm.drizzle.team/docs/get-started/supabase-new

- **Get Started with Drizzle and Supabase in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/supabase-existing

- **Get Started with Drizzle and Xata**
  - URL: https://orm.drizzle.team/docs/get-started/xata-new

- **Get Started with Drizzle and Xata in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/xata-existing

- **Get Started with Drizzle and PGlite**
  - URL: https://orm.drizzle.team/docs/get-started/pglite-new

- **Get Started with Drizzle and PGLite in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/pglite-existing

- **Get Started with Drizzle and Nile**
  - URL: https://orm.drizzle.team/docs/get-started/nile-new

- **Get Started with Drizzle and Nile in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/nile-existing

- **Get Started with Drizzle and Vercel Postgres**
  - URL: https://orm.drizzle.team/docs/get-started/vercel-new

- **Get Started with Drizzle and Vercel Postgres in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/vercel-existing

- **Get Started with Drizzle and Effect PostgreSQL**
  - URL: https://orm.drizzle.team/docs/get-started/effect-postgresql-new

- **Get Started with Drizzle and Effect PostgreSQL in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/effect-postgresql-existing

- **Get Started with Drizzle and MySQL**
  - URL: https://orm.drizzle.team/docs/get-started/mysql-new

- **Get Started with Drizzle and MySQL in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/mysql-existing

- **Get Started with Drizzle and PlanetScale**
  - URL: https://orm.drizzle.team/docs/get-started/planetscale-new

- **Get Started with Drizzle and PlanetScale in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/planetscale-existing

- **Get Started with Drizzle and PlanetScale Postgres**
  - URL: https://orm.drizzle.team/docs/get-started/planetscale-postgres-new

- **Get Started with Drizzle and PlanetScale Postgres in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/planetscale-postgres-existing

- **Get Started with Drizzle and TiDB**
  - URL: https://orm.drizzle.team/docs/get-started/tidb-new

- **Get Started with Drizzle and TiDB in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/tidb-existing

- **Get Started with Drizzle and SQLite**
  - URL: https://orm.drizzle.team/docs/get-started/sqlite-new

- **Get Started with Drizzle and SQLite in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/sqlite-existing

- **Get Started with Drizzle and Turso Cloud**
  - URL: https://orm.drizzle.team/docs/get-started/turso-new

- **Get Started with Drizzle and Turso Cloud in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/turso-existing

- **Get Started with Drizzle and Turso Database**
  - URL: https://orm.drizzle.team/docs/get-started/turso-database-new

- **Get Started with Drizzle and Turso Database in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/turso-database-existing

- **Get Started with Drizzle and D1**
  - URL: https://orm.drizzle.team/docs/get-started/d1-new

- **Get Started with Drizzle and D1 in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/d1-existing

- **Get Started with Drizzle and SQLite Durable Objects**
  - URL: https://orm.drizzle.team/docs/get-started/do-new

- **Get Started with Drizzle and SQLite Durable Objects in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/do-existing

- **Get Started with Drizzle and Bun:SQLite**
  - URL: https://orm.drizzle.team/docs/get-started/bun-sqlite-new

- **Get Started with Drizzle and Bun:SQLite in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/bun-sqlite-existing

- **Get Started with Drizzle and SQLite Cloud**
  - URL: https://orm.drizzle.team/docs/get-started/sqlite-cloud-new

- **Get Started with Drizzle and SQLite Cloud in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/sqlite-cloud-existing

- **Get Started with Drizzle and Bun:SQLite**
  - URL: https://orm.drizzle.team/docs/get-started/bun-sql-new

- **Get Started with Drizzle and SQLite in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/bun-sql-existing

- **Get Started with Drizzle and MSSQL**
  - URL: https://orm.drizzle.team/docs/get-started/mssql-new

- **Get Started with Drizzle and MSSQL in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/mssql-existing

- **Get Started with Drizzle and CockroachDB**
  - URL: https://orm.drizzle.team/docs/get-started/cockroach-new

- **Get Started with Drizzle and CockroachDB in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/cockroach-existing

- **Get Started with Drizzle and Expo**
  - URL: https://orm.drizzle.team/docs/get-started/expo-new

- **Get Started with Drizzle and Expo in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/expo-existing

- **Get Started with Drizzle and OP-SQLite**
  - URL: https://orm.drizzle.team/docs/get-started/op-sqlite-new

- **Get Started with Drizzle and OP-SQLite in existing project**
  - URL: https://orm.drizzle.team/docs/get-started/op-sqlite-existing

- **Drizzle Sustainability**
  - URL: https://orm.drizzle.team/docs/sustainability

- **Drizzle ORM**
  - URL: https://orm.drizzle.team/docs/overview

- **Drizzle gotchas**
  - URL: https://orm.drizzle.team/docs/gotchas

### Upgrade to v1.0 RC

- **Upgrading to Drizzle v1 RC**
  - URL: https://orm.drizzle.team/docs/upgrade-v1

- **Migrating to Relational Queries version 2**
  - URL: https://orm.drizzle.team/docs/relations-v1-v2

### Fundamentals

- **Drizzle schema**
  - URL: https://orm.drizzle.team/docs/sql-schema-declaration

- **Drizzle Relations Fundamentals**
  - URL: https://orm.drizzle.team/docs/relations-schema-declaration

- **Database connection with Drizzle**
  - URL: https://orm.drizzle.team/docs/connect-overview

- **Drizzle Queries + CRUD**
  - URL: https://orm.drizzle.team/docs/data-querying

- **Drizzle migrations fundamentals**
  - URL: https://orm.drizzle.team/docs/migrations

### Connect

- **Drizzle \<\> PostgreSQL**
  - URL: https://orm.drizzle.team/docs/get-started-postgresql

- **Drizzle \<\> Gel**
  - URL: https://orm.drizzle.team/docs/get-started-gel

- **Drizzle \<\> MySQL**
  - URL: https://orm.drizzle.team/docs/get-started-mysql

- **Drizzle \<\> SQLite**
  - URL: https://orm.drizzle.team/docs/get-started-sqlite

- **Drizzle \<\> MSSQL**
  - URL: https://orm.drizzle.team/docs/get-started-mssql

- **Drizzle \<\> PostgreSQL**
  - URL: https://orm.drizzle.team/docs/get-started-cockroach

- **Drizzle \<\> SingleStore**
  - URL: https://orm.drizzle.team/docs/get-started-singlestore

- **Drizzle \<\> PlanetScale Postgres**
  - URL: https://orm.drizzle.team/docs/connect-planetscale-postgres

- **Drizzle \<\> Neon Postgres**
  - URL: https://orm.drizzle.team/docs/connect-neon

- **Drizzle \<\> Vercel Postgres**
  - URL: https://orm.drizzle.team/docs/connect-vercel-postgres

- **Drizzle \<\> Prisma Postgres**
  - URL: https://orm.drizzle.team/docs/connect-prisma-postgres

- **Drizzle \<\> Supabase**
  - URL: https://orm.drizzle.team/docs/connect-supabase

- **Drizzle \<\> Xata**
  - URL: https://orm.drizzle.team/docs/connect-xata

- **Drizzle \<\> PGlite**
  - URL: https://orm.drizzle.team/docs/connect-pglite

- **Drizzle \<\> Nile**
  - URL: https://orm.drizzle.team/docs/connect-nile

- **Drizzle \<\> Bun SQL**
  - URL: https://orm.drizzle.team/docs/connect-bun-sql

- **Drizzle \<\> Effect Postgres**
  - URL: https://orm.drizzle.team/docs/connect-effect-postgres

- **Drizzle \<\> PlanetScale MySQL**
  - URL: https://orm.drizzle.team/docs/connect-planetscale

- **Drizzle \<\> TiDB Serverless**
  - URL: https://orm.drizzle.team/docs/connect-tidb

- **Drizzle \<\> Turso Cloud**
  - URL: https://orm.drizzle.team/docs/connect-turso

- **Drizzle \<\> Turso Database**
  - URL: https://orm.drizzle.team/docs/connect-turso-database

- **Drizzle \<\> SQLite Cloud**
  - URL: https://orm.drizzle.team/docs/connect-sqlite-cloud

- **Drizzle \<\> Cloudflare D1**
  - URL: https://orm.drizzle.team/docs/connect-cloudflare-d1

- **Drizzle \<\> Bun SQLite**
  - URL: https://orm.drizzle.team/docs/connect-bun-sqlite

- **Drizzle \<\> Node SQLite**
  - URL: https://orm.drizzle.team/docs/connect-node-sqlite

- **Drizzle \<\> Cloudflare Durable Objects SQLite**
  - URL: https://orm.drizzle.team/docs/connect-cloudflare-do

- **Drizzle \<\> Expo SQLite**
  - URL: https://orm.drizzle.team/docs/connect-expo-sqlite

- **Drizzle \<\> OP SQLite**
  - URL: https://orm.drizzle.team/docs/connect-op-sqlite

- **Drizzle \<\> React Native SQLite**
  - URL: https://orm.drizzle.team/docs/connect-react-native-sqlite

- **Drizzle \<\> AWS Data API Postgres**
  - URL: https://orm.drizzle.team/docs/connect-aws-data-api-pg

- **Drizzle \<\> AWS Data API MySQL**
  - URL: https://orm.drizzle.team/docs/connect-aws-data-api-mysql

- **Drizzle HTTP proxy**
  - URL: https://orm.drizzle.team/docs/connect-drizzle-proxy

### Manage schema

- **PostgreSQL column types**
  - URL: https://orm.drizzle.team/docs/column-types/pg

- **MySQL column types**
  - URL: https://orm.drizzle.team/docs/column-types/mysql

- **SQLite column types**
  - URL: https://orm.drizzle.team/docs/column-types/sqlite

- **SingleStore column types**
  - URL: https://orm.drizzle.team/docs/column-types/singlestore

- **MSSQL column types**
  - URL: https://orm.drizzle.team/docs/column-types/mssql

- **CockroachDB column types**
  - URL: https://orm.drizzle.team/docs/column-types/cockroach

- **Indexes & Constraints**
  - URL: https://orm.drizzle.team/docs/indexes-constraints

- **Sequences**
  - URL: https://orm.drizzle.team/docs/sequences

- **Views**
  - URL: https://orm.drizzle.team/docs/views

- **Table schemas**
  - URL: https://orm.drizzle.team/docs/schemas

- **Drizzle relations**
  - URL: https://orm.drizzle.team/docs/relations-v2

- **Row-Level Security (RLS)**
  - URL: https://orm.drizzle.team/docs/rls

- **PostgreSQL extensions**
  - URL: https://orm.drizzle.team/docs/extensions/pg

- **MySQL extensions**
  - URL: https://orm.drizzle.team/docs/extensions/mysql

- **SQLite extensions**
  - URL: https://orm.drizzle.team/docs/extensions/sqlite

- **SingleStore extensions**
  - URL: https://orm.drizzle.team/docs/extensions/singlestore

- **Drizzle soft relations**
  - URL: https://orm.drizzle.team/docs/relations

### Migrations

- **Migrations with Drizzle Kit**
  - URL: https://orm.drizzle.team/docs/kit-overview

- **`drizzle-kit generate` **
  - URL: https://orm.drizzle.team/docs/drizzle-kit-generate

- **`drizzle-kit migrate`**
  - URL: https://orm.drizzle.team/docs/drizzle-kit-migrate

- **`drizzle-kit push`**
  - URL: https://orm.drizzle.team/docs/drizzle-kit-push

- **`drizzle-kit pull`**
  - URL: https://orm.drizzle.team/docs/drizzle-kit-pull

- **`drizzle-kit export` **
  - URL: https://orm.drizzle.team/docs/drizzle-kit-export

- **`drizzle-kit check`**
  - URL: https://orm.drizzle.team/docs/drizzle-kit-check

- **`drizzle-kit up`**
  - URL: https://orm.drizzle.team/docs/drizzle-kit-up

- **`drizzle-kit studio`**
  - URL: https://orm.drizzle.team/docs/drizzle-kit-studio

- **Migrations with Drizzle Kit**
  - URL: https://orm.drizzle.team/docs/kit-custom-migrations

- **Drizzle migrations for teams**
  - URL: https://orm.drizzle.team/docs/kit-migrations-for-teams

- **Drizzle migrations in web and mobile environments**
  - URL: https://orm.drizzle.team/docs/kit-web-mobile

- **Drizzle Kit configuration file**
  - URL: https://orm.drizzle.team/docs/drizzle-config-file

### Seeding

- **Drizzle Seed**
  - URL: https://orm.drizzle.team/docs/seed-overview

- **Generators**
  - URL: https://orm.drizzle.team/docs/seed-functions

- **Versioning**
  - URL: https://orm.drizzle.team/docs/seed-versioning

### Access your data

- **Drizzle Queries**
  - URL: https://orm.drizzle.team/docs/rqb-v2

- **SQL Select**
  - URL: https://orm.drizzle.team/docs/select

- **SQL Insert**
  - URL: https://orm.drizzle.team/docs/insert

- **SQL Update**
  - URL: https://orm.drizzle.team/docs/update

- **SQL Delete**
  - URL: https://orm.drizzle.team/docs/delete

- **Filter and conditional operators**
  - URL: https://orm.drizzle.team/docs/operators

- **Drizzle query utils**
  - URL: https://orm.drizzle.team/docs/query-utils

- **Link**: [Joins [SQL]](
  - URL: https://orm.drizzle.team/docs/joins)

- **Magical `sql` operator 🪄**
  - URL: https://orm.drizzle.team/docs/sql

- **Drizzle Queries**
  - URL: https://orm.drizzle.team/docs/rqb

### Performance

- **Query performance**
  - URL: https://orm.drizzle.team/docs/perf-queries

- **Drizzle Serverless performance**
  - URL: https://orm.drizzle.team/docs/perf-serverless

### Advanced

- **Set Operations**
  - URL: https://orm.drizzle.team/docs/set-operations

- **Generated Columns**
  - URL: https://orm.drizzle.team/docs/generated-columns

- **Transactions**
  - URL: https://orm.drizzle.team/docs/transactions

- **Batch API**
  - URL: https://orm.drizzle.team/docs/batch-api

- **Cache**
  - URL: https://orm.drizzle.team/docs/cache

- **Dynamic query building**
  - URL: https://orm.drizzle.team/docs/dynamic-query-building

- **Read Replicas**
  - URL: https://orm.drizzle.team/docs/read-replicas

- **Common way of defining custom types**
  - URL: https://orm.drizzle.team/docs/custom-types

### Validations

- **zod**
  - URL: https://orm.drizzle.team/docs/zod

- **valibot**
  - URL: https://orm.drizzle.team/docs/valibot

- **typebox**
  - URL: https://orm.drizzle.team/docs/typebox

- **arktype**
  - URL: https://orm.drizzle.team/docs/arktype

- **typebox-legacy**
  - URL: https://orm.drizzle.team/docs/typebox-legacy

- **effect-schema**
  - URL: https://orm.drizzle.team/docs/effect-schema

### Extensions

- **Drizzle extension for Prisma**
  - URL: https://orm.drizzle.team/docs/prisma

- **ESLint Drizzle Plugin**
  - URL: https://orm.drizzle.team/docs/eslint-plugin

- **drizzle-graphql**
  - URL: https://orm.drizzle.team/docs/graphql

### Guides

- **Guides**
  - URL: https://orm.drizzle.team/docs/guides

- **Conditional filters in query**
  - URL: https://orm.drizzle.team/docs/guides/conditional-filters-in-query

- **SQL Increment value**
  - URL: https://orm.drizzle.team/docs/guides/incrementing-a-value

- **SQL Decrement value**
  - URL: https://orm.drizzle.team/docs/guides/decrementing-a-value

- **Include or Exclude Columns in Query**
  - URL: https://orm.drizzle.team/docs/guides/include-or-exclude-columns

- **SQL Toggle value**
  - URL: https://orm.drizzle.team/docs/guides/toggling-a-boolean-field

- **Count rows**
  - URL: https://orm.drizzle.team/docs/guides/count-rows

- **Upsert Query**
  - URL: https://orm.drizzle.team/docs/guides/upsert

- **SQL Limit/Offset pagination**
  - URL: https://orm.drizzle.team/docs/guides/limit-offset-pagination

- **SQL Cursor-based pagination**
  - URL: https://orm.drizzle.team/docs/guides/cursor-based-pagination

- **SQL Timestamp as a default value**
  - URL: https://orm.drizzle.team/docs/guides/timestamp-default-value

- **Gel auth extension**
  - URL: https://orm.drizzle.team/docs/guides/gel-ext-auth

- **Select parent rows with at least one related child row**
  - URL: https://orm.drizzle.team/docs/guides/select-parent-rows-with-at-least-one-related-child-row

- **Empty array as a default value**
  - URL: https://orm.drizzle.team/docs/guides/empty-array-default-value

- **Update many with different values for each row**
  - URL: https://orm.drizzle.team/docs/guides/update-many-with-different-value

- **Unique and Case-Insensitive Email Handling**
  - URL: https://orm.drizzle.team/docs/guides/unique-case-insensitive-email

- **Vector similarity search with pgvector extension**
  - URL: https://orm.drizzle.team/docs/guides/vector-similarity-search

- **PostgreSQL full-text search**
  - URL: https://orm.drizzle.team/docs/guides/postgresql-full-text-search

- **Cloudflare D1 HTTP API with Drizzle Kit**
  - URL: https://orm.drizzle.team/docs/guides/d1-http-with-drizzle-kit

- **Point datatype in PostgreSQL**
  - URL: https://orm.drizzle.team/docs/guides/point-datatype-psql

- **PostGIS geometry point**
  - URL: https://orm.drizzle.team/docs/guides/postgis-geometry-point

- **How to setup PostgreSQL locally**
  - URL: https://orm.drizzle.team/docs/guides/postgresql-local-setup

- **How to setup MySQL locally**
  - URL: https://orm.drizzle.team/docs/guides/mysql-local-setup

- **Seeding Partially Exposed Tables with Foreign Key**
  - URL: https://orm.drizzle.team/docs/guides/seeding-with-partially-exposed-tables

- **Seeding using 'with' option**
  - URL: https://orm.drizzle.team/docs/guides/seeding-using-with-option

- **Full-text search with Generated Columns**
  - URL: https://orm.drizzle.team/docs/guides/full-text-search-with-generated-columns

### Tutorials

- **Tutorials**
  - URL: https://orm.drizzle.team/docs/tutorials

- **Drizzle with Netlify Edge Functions and Neon Postgres **
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-netlify-edge-functions-neon

- **Drizzle with Netlify Edge Functions and Supabase Database**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-netlify-edge-functions-supabase

- **Drizzle with Supabase Edge Functions**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-supabase-edge-functions

- **Drizzle with Vercel Edge Functions**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-vercel-edge-functions

- **Drizzle with Neon Postgres**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-neon

- **Drizzle with Nile Database**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-nile

- **Drizzle with Supabase Database**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-supabase

- **Drizzle with Turso**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-turso

- **Drizzle with Vercel Postgres**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-vercel

- **Drizzle with Xata**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-xata

- **Todo App with Neon Postgres**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-nextjs-neon

- **Drizzle with Encore**
  - URL: https://orm.drizzle.team/docs/tutorials/drizzle-with-encore

## How to Use This Skill

Reference these resources when working with Drizzle.