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.