ORM for you to settlecross-outship ship ship
backed by planetScale planetScale
JavaScript
TypeScript
Get Started
Documentation
Search Docs
with db with db front front
back back
board
Play
Normal
with db with db front front
back back love

We ship decently fast

Drizzle Team and Active Contributors

Andrew Sherman Andrew Sherman
Dan Kochetov Dan Kochetov
Alex Blokh Alex Blokh
Mykhailo Stratovych Mykhailo Stratovych
Roman Nabukhotnyi Roman Nabukhotnyi
Vladislav Stohnii Vladislav Stohnii
Serhii Reka Serhii Reka
Oleksii Khomenko Oleksii Khomenko
Artem Odiiko Artem Odiiko
Vitalii Staryk Vitalii Staryk
angelelz angelelz
rphlmr rphlmr
mario564 mario564
Simon Sardorf Simon Sardorf
v1.0 release
99.5%
June 2024
July 2024
August 2024
September 2024
  • Some Tweets
October 2024
  • ORM v0.36.0 release Row-Level Security Support for PostgreSQL
    • Manage roles
    • Manage policies
    • Enable RLS for tables
    • Enable RLS for views!
    • Special import drizzle-orm/neon for Neon
    • Special import drizzle-orm/supabase for Supabase
  • Kit v0.27.0 release Row-Level Security Support for PostgreSQL
    • Manage roles
    • Manage policies
    • Enable RLS for tables
    • Enable RLS for views!
    • Special import drizzle-orm/neon for Neon
    • Special import drizzle-orm/supabase for Supabase
  • Documentation site restructure and improvements
    • New "Get Started" section
    • New "Fundamentals" section
    • "Connect" is now flat and has proper navigation
    • The Kit section is gone, and you now have a "Migrations" section with full information about the Kit
    • Updated UI
    • Content restructuring
    • And more
  • ORM v0.34.0 release Breaking changes:
    • Added new dialect "Turso" that needs a newer libsql version
    Features:
    • LibSQL/Turso and SQLite migration updates
    • SQLite "generate" and "push" statement updates
    • LibSQL/Turso "generate" and "push" statement updates
    • New casing param in drizzle-orm
    • Monodriver: A new and easy way to start using Drizzle
    • Schema improvements: Optional names for columns and callback in Drizzle table
    • New "count" API
    • Ability to execute raw strings
    • Exposed db.$client
  • Kit v0.25.0 release Breaking changes:
    • Added new dialect "Turso" that needs a newer libsql version
    Features:
    • LibSQL/Turso and SQLite migration updates
    • SQLite "generate" and "push" statement updates
    • LibSQL/Turso "generate" and "push" statement updates
    • New casing param in drizzle-kit
November 2024
  • 🎉 OneDollarStats is now available in Open Alpha release! OneDollarStats is a $1 per month web analytics built by Drizzle Team
  • 🎉 New drizzle-seed package is now available For more info check our seed documentation
  • ORM v0.36.4 release
    • Added .$withAuth() API for Neon HTTP driver
    • Added OVERRIDING SYSTEM VALUE api to db.insert()
  • ORM v0.36.3 release
    • Support for UPDATE ... FROM in PostgreSQL and SQLite
    • Support for INSERT INTO ... SELECT in all dialects
  • Kit v0.28.1 release and ORM v0.36.2 release
    • Support more types in like, notLike, ilike and notIlike expressions
    • Fixed typos in repository: thanks @armandsalle, @masto, @wackbyte, @Asher-JH, @MaxLeiter
    • fix: wrong dialect set in mysql/sqlite introspect
    • Fixed .generated behavior with non-strict tsconfig
    • Fix Drizzle ORM for expo-sqlite
    • Fixed lack of schema name on columns in sql
    • fix: Adjust neon http driver entity kind
    • Export PgIntegerBuilderInitial type
    • [MySQL] Correct $returningId() implementation to correctly store selected fields
  • Kit v0.28.0 release and ORM v0.36.1 release
    • Added an OHM static imports checker to identify unexpected imports within a chain of imports in the drizzle-kit repo. For example, it checks if drizzle-orm is imported before drizzle-kit and verifies if the drizzle-orm import is available in your project.
    • Adding more columns to Supabase auth.users table schema
      Bug Fixes
    • [BUG]: Using sql.placeholder with limit and/or offset for a prepared statement produces TS error
    • [BUG] If a query I am trying to modify with a dynamic query (....$dynamic()) contains any placeholders, I'm getting an error that says No value for placeholder.... provided
    • [BUG]: Error thrown when trying to insert an array of new rows using generatedAlwaysAsIdentity() for the id column
    • [BUG]: Unable to Use BigInt Types with Bun and Drizzle
    • [BUG]: [drizzle-kit]: Fix breakpoints option cannot be disabled
    • [BUG]: drizzle-kit introspect: SMALLINT import missing and incorrect DECIMAL UNSIGNED handling
    • Unsigned tinyints preventing migrations
    • [BUG]: Can't parse float(8,2) from database (precision and scale and/or unsigned breaks float types)
    • [BUG]: PgEnum generated migration doesn't escape single quotes
    • [BUG]: single quote not escaped correctly in migration file
    • [BUG]: Migrations does not escape single quotes
    • [BUG]: Issue with quoted default string values
    • [BUG]: SQl commands in wrong roder
    • [BUG]: Time with precision in drizzle-orm/pg-core adds double-quotes around type
    • [BUG]: Postgres push fails due to lack of quotes
    • [BUG]: TypeError: Cannot read properties of undefined (reading 'compositePrimaryKeys')
    • [BUG]: drizzle-kit introspect generates CURRENT_TIMESTAMP without sql operator on date column
    • [BUG]: Drizzle-kit introspect doesn't pull correct defautl statement
    • [BUG]: Problem on MacBook - This statement does not return data. Use run() instead
    • [BUG]: Enum column names that are used as arrays are not quoted
    • [BUG]: drizzle-kit generate ignores index operators
    • dialect param config error message is wrong
    • [BUG]: Error setting default enum field values
    • [BUG]: drizzle-kit does not respect the order of columns configured in primaryKey()
    • [BUG]: Cannot drop Unique Constraint MySQL
  • Kit v0.27.2 release
    • Fix [BUG]: Undefined properties when using drizzle-kit push
    • Fix TypeError: Cannot read properties of undefined (reading 'isRLSEnabled')
    • Fix push bugs, when pushing a schema with linked policy to a table from drizzle-orm/supabase
  • Kit v0.27.1 release
    • Fix: [BUG]: When using RLS policies and Views, the view is the last clause generated
December 2024
  • drizzle-seed v0.3.0 release
    • The seed function can now accept Drizzle Relations objects and treat them as foreign key constraints
  • ORM v0.38.3 release
    • Fix incorrect deprecation detection for table declarations
    • SingleStore dialect support for all validator packages
  • drizzle-seed v0.2.1 release
    • We are introducing a new parameter, version, to the seed function options. This parameter, which controls generator versioning, has been added to make it easier to update deterministic generators in the future.
    • interval unique generator was changed and upgraded to v2
    • string generators were changed and upgraded to v2
  • ORM v0.38.2 release
    • New features for MySQL users: USE INDEX, FORCE INDEX and IGNORE INDEX for MySQL
  • Kit v0.30.1 release
    • New command: drizzle-kit export
  • drizzle-seed v0.1.3 release
    • Added support for postgres uuid columns
    • Added support for postgres array columns
    • Added support for cyclic tables. You can now seed tables with cyclic relations.
      Bug Fixes
    • [BUG]: reset fails with a syntax error if using a - in pgTableCreator to prefix tables
    • seeding a table with columns that have .default(sql``) will result in an error
  • ORM bug fixes
    • [FEATURE]: publish packages un-minified
    • Don't allow unknown keys in drizzle-zod refinement
    • [BUG]:drizzle-zod not working with pgSchema
    • Add createUpdateSchema to drizzle-zod
    • [BUG]:drizzle-zod produces wrong type
    • [BUG]:Drizzle-zod:Boolean and Serial types from Schema are defined as enum when using CreateInsertSchema and CreateSelectSchema
    • [BUG]: Drizzle typebox enum array wrong schema and type
    • [BUG]:drizzle-zod not working with pgSchema
    • [BUG]: drizzle-zod not parsing arrays correctly
    • [BUG]: Drizzle typebox not supporting array
    • [FEATURE]: Export factory functions from drizzle-zod to allow usage with extended Zod classes
    • [FEATURE]: Add support for new pipe syntax for drizzle-valibot
    • [BUG]: drizzle-zod's createInsertSchema() can't handle column of type vector
    • [BUG]: drizzle-typebox fails to map geometry column to type-box schema
    • [BUG]: drizzle-valibot does not provide types for returned schemas
    • [BUG]: Drizzle-typebox types SQLite real field to string
    • [BUG]: drizzle-zod: documented usage generates type error with exactOptionalPropertyTypes
    • [BUG]: drizzle-zod does not respect/count db type range
    • [BUG]: drizzle-zod not overriding optional
    • [BUG]:drizzle-zod doesn't accept custom id value
    • [FEATURE]: Support for Database Views in Drizzle Zod
    • [BUG]: drizzle-valibot return type any
    • [BUG]: drizzle-zod Type generation results in undefined types
    • [BUG]: GeneratedAlwaysAs
    • [FEATURE]: $inferSelect on a view
    • [BUG]:Can't infer props from view in schema
  • ORM v0.38.0 release
    • Added new function getViewSelectedFields
    • Added $inferSelect function to views
    • Added InferSelectViewModel type for views
    • Added isView function
  • Kit v0.30.0 release Starting from this update, the PostgreSQL dialect will align with the behavior of all other dialects. It will no longer include IF NOT EXISTS, $DO, or similar statements, which could cause incorrect DDL statements to not fail when an object already exists in the database and should actually fail.
  • Kit v0.29.0 release and ORM v0.37.0 release
    • New dialect SingleStore is available in Drizzle
    • New driver for Durable Objects SQLite is available in Drizzle
    • [BUG]: $with is undefined on withReplicas
    • [BUG]: Neon serverless driver accepts authToken as a promise, but the $withAuth does not
January 2025
  • ORM v0.39.1 release
    • Fixed SQLite onConflict clauses being overwritten instead of stacked
    • Added view support to aliasedTable()
    • Fixed sql builder prefixing aliased views and tables with their schema
  • Kit v0.30.4 release
    • Fix bug that generates incorrect syntax when introspect in mysql
    • Fix a bug that caused incorrect syntax output when introspect in unsigned columns
    • Bug Fixes
    • Allow INSERT in CTEs (WITH clauses)]
    • Support Raw SQL in CTE Query Builder]
    • Include pre-defined database objects related to Neon Identity in drizzle-orm]
    • $count is undefined on withReplicas]
    • get[Materialized]ViewName, ie getTableName but for (materialized) views.]
    • $count API error with vercel-postgres]
    • Cannot use schema.coerce on refining drizzle-zod types]
    • Type Coercion in drizzle-zod]
    • The inferred type of X cannot be named without a reference ...
    • drizzle-zod excessively deep and possibly infinite types]
  • ORM v0.39.0 release
    • You can now use the new Bun SQL driver released in Bun v1.2.0 with Drizzle
    • WITH now supports INSERT, UPDATE, DELETE and raw sql template
    • New tables in /neon import
    • Added getViewName util function
  • Kit v0.30.3 release
    • As SingleStore did not support certain DDL statements before this release, you might encounter an error indicating that some schema changes cannot be applied due to a database issue. Starting from this version, drizzle-kit will detect such cases and initiate table recreation with data transfer between the tables
February 2025
  • Drizzle Studio updates:
    • Added the ability to create/alter tables.
    • Added the ability to create/alter views.
    • Added the ability to refresh db schema.
    • Improved dropdowns.
    • Improved style customization.
    • Added filter by entity type (table/view).
    • Revised dependency tree and reduced bundle size.
    • Added database metadata to bug report.
    • Added range selection with copy/paste capability.
  • ORM v0.40.0 release
    • Drizzle is getting a new Gel dialect with its own types and Gel-specific logic. In this first iteration, almost all query-building features have been copied from the PostgreSQL dialect since Gel is fully PostgreSQL-compatible. The only change in this iteration is the data types. The Gel dialect has a different set of available data types, and all mappings for these types have been designed to avoid any extra conversions on Drizzle's side. This means you will insert and select exactly the same data as supported by the Gel protocol.
  • Kit v0.30.5 release
    • Drizzle is getting a new Gel dialect with its own types and Gel-specific logic. Kit is getting new "gel" dialect option
March 2025
  • ORM v0.41.0 release
    • bigint, number modes for SQLite, MySQL, PostgreSQL, SingleStore decimal & numeric column types
    • Changed behavior of sql-js query preparation
    • Fixed MySQL, SingleStore varchar allowing not specifying length in config
    • Fixed MySQL, SingleStore binary, varbinary data\\type mismatches
    • Fixed numeric\\decimal data\\type mismatches
    • Fixed drizzle-studio + AWS Data Api connection issue
    • Fixed isConfig utility function checking types of wrong fields
    • Enabled supportBigNumbers in auto-created mysql2 driver instances
    • Fixed custom schema tables querying in RQBv1
    • Removed in-driver mapping for postgres types
    • Fixed SQLite buffer-mode blob sometimes returning number[]
  • Drizzle Studio updates:
    • Added new setting option for expanding subviews.
    • Added date and time pickers.
    • New settings option for pagination by page or limit offset.
    • Improved error handling for INSERT/UPDATE/DELETE statements in data table.
    • Added column type to header cell.
    • Added export in xlsx format.
    • Added callback on bug report button click.
    • Added ability to customize the error page.
    • Added css variable for run query button color.
    • Fixed issues with rowid.
    • Improved SQL console with snippet system.
  • ORM v0.40.1 release
    • Updates to neon-http for @neondatabase/serverless@1.0.0. Starting from this version, drizzle-orm will be compatible with both @neondatabase/serverless <1.0 and >1.0
April 2025
  • Drizzle ORM Beta branch:
    • Relational Queries V2 released in Beta!
  • Drizzle Studio updates:
    • Added fontSize settings option.
    • Added a multiline editor.
    • Changed JSON editor ui.
    • Fixed incorrect bigserial value handling.
  • ORM v0.43.1 release
    • Fixed incorrect types of schema enums in PostgreSQL
  • ORM v0.43.0 release
    • Added cross join
    • Added lateral left, inner, cross joins to PostgreSQL, MySQL, Gel, SingleStore
    • Added drizzle connection attributes to SingleStore's driver instances
    • Removed unsupported by dialect full join from MySQL select api
    • Forced Gel columns to always have explicit schema & table prefixes due to potential errors caused by lack of such prefix in subquery's selection when there's already a column bearing same name in context
    • Added missing export for PgTextBuilderInitial type
    • Removed outdated IfNotImported type check from SingleStore driver initializer
    • Fixed incorrect type inference for insert and update models with non-strict tsconfigs
    • Fixed invalid spelling of nowait flag
  • Kit v0.31.0 release
    • Enum DDL improvements
    • esbuild version upgrade
    • [[BUG]: Error on Malformed Array Literal](https://github.com/drizzle-team/drizzle-orm/issues/2715)
    • [[BUG]: Postgres drizzle-kit: Error while pulling indexes from a table with json/jsonb deep field index](https://github.com/drizzle-team/drizzle-orm/issues/2744)
    • [goog-vulnz flags CVE-2024-24790 in esbuild 0.19.7](https://github.com/drizzle-team/drizzle-orm/issues/4045)
  • ORM v0.42.0 release
    • Duplicate imports removal. When importing from drizzle-orm using custom loaders, you may encounter issues such as: SyntaxError: The requested module 'drizzle-orm' does not provide an export named 'eq'
    • pgEnum and mysqlEnum` now can accept both strings and TS enums
    • Make inArray accept ReadonlyArray as a value
    • Pass row type parameter to @planetscale/database's execute
    • New InferEnum type
May 2025
  • Drizzle ORM pre-release features: List of features that are currently in open beta and will soon go live.
    • Fully updated alternation engine for drizzle-kit. This change also increased drizzle-kit tests from 600 to 3000+ so far and is growing
    • MSSQL Support
    • CockroachDB Support
  • Drizzle Studio updates:
    • Fixed saving bug in json cell editor.
    • Fixed resizing of columns in Safari browser.
    • Fixed a bug where FK constraints were not displayed if CHECK constraints existed.
  • ORM v0.44.0 release
    • Error handling
      • Starting from this version, we've introduced a new DrizzleQueryError that wraps all errors from database drivers and provides a set of useful information:
    • Cache layer support. Sponsored by Upstash
  • drizzle-zod v0.8.1 release This version was released to resolve several compatibility issues with the ZodObject type, which were fixed in drizzle-orm@0.8.1, so version 0.8.0 was skipped
    • Support for Zod v4: Starting with this release, drizzle-zod now requires Zod v3.25.1 or later
    • TS language server performance improvements
  • Kit v0.31.1 release
    • Fixed drizzle-kit pull bugs when using Gel extensions
June 2025
  • Drizzle ORM/Kit pre-release features: alternation-engine branch
    • Updated test cases for defaults values across all dialects
    • Updated test cases for constraints values across all dialects
    • Make each test run ~6-7 scenarios for generate, push and pull
    • Grow from 600 test cases to >7k test units
    • Implement Cockroach support in validator packages
    • Implement MSSQL support in validator packages
  • Drizzle Seed pre-release features: alternation-engine branch
    • Add support for CockroachDB
    • Add support for MSSQL
    • Add support for SingleStore
  • Drizzle Studio updates
    • Introduced a new page(Database studio) for managing the full database schema.
    • Integrated introspection and alternation engine from drizzle-kit.
    • Fixed JSONB datatype when exporting to csv.
    • Fix relation names.
    • Added data reload to cmd+R.
  • ORM v0.44.2 release
    • [BUG]: Fixed type issues with joins with certain variations of tsconfig: #4535, #4457
  • OneDollarStats updates
    • B2B solutions: embedded UI and infrastructure
    • Database migration (accelerated by ~14x)
    • Time range comparison charts
    • Filters
    • Date range picker
July 2025
  • ORM v0.44.3 release
    • Fixed types of $client for clients created by drizzle function
    • Added the updated_at column to the neon_auth.users_sync table definition.
  • Drizzle ORM pre-release features: beta branch
    • Possibility to split defineRelations into several configs
    • Type performance improvements
  • Drizzle ORM/Kit pre-release features: alternation-engine branch
    • More work on defaults handling for push and pull commands
  • Drizzle Studio updates
    • Added support for roles, privileges and policies.
    • When create a table, the default schema is the one selected in the sidebar.
    • Show empty view if the schema is empty.
    • Fixed text selection while sidebar resizing.
    • Fixed bigints in json
  • OneDollarStats updates
    • Standardized charts for time zones using UTC
    • New stepped chart view
    • Added functionality to compare data with the previous time period.
    • Switched to UTM to standardize charts across different time zones.
    • Added a new stepped chart variant for the dashboard.
August 2025
  • ORM v0.44.5 release
    • Fixed invalid usage of .one() in durable-sqlite session
    • Fixed spread operator related crash in sqlite blob columns
    • Better browser support for sqlite blob columns
    • Improved sqlite blob mapping
  • ORM v0.44.4 release
    • Fix wrong DrizzleQueryError export. thanks @nathankleyn
  • Drizzle Studio updates
    • Added some love ♡.
    • Added support for partitioned tables in PostgreSQL introspection (treated as ordinary tables).
    • Added layout direction support for the SQL console.
September 2025
  • KIT v0.31.5 release
    • Add casing support to studio configuration and related functions
  • Drizzle Studio updates
    • Improved SQL console performance.
    • Added support for SQL files import in the SQL Console.
    • Fixed BigInt handling in filters.
October 2025
  • KIT v0.31.6 release
    • [BUG]: Importing drizzle-kit/api fails in ESM modules
  • ORM v0.44.7 release
    • fix durable sqlite transaction return value #3746 - thanks @joaocstro
  • ORM v0.44.6 release
    • feat: add $replicas reference #4874
  • Drizzle Studio updates
    • Improved data browser performance.
    • Reworked the schema viewer in the SQL console.
    • Added Explain/Analyze support in the SQL console.
November 2025
  • KIT v0.31.7 release
    • [BUG]: Drizzle Kit push to Postgres 18 produces unecessary DROP SQL when the schema was NOT changed
  • Drizzle Studio updates
    • Enhanced range selection for copying/pasting data between cells.
    • Added support for CSV files import.
    • Added the ability to expand a row in the right-side panel.
    • Added SQL editor for default values and generated expressions.
    • Fixed an issue with multi-dimensional arrays.
December 2025
  • Drizzle Beta v1.0.0-beta.8 release
      Seed Features
    • ignore column in refinements
    • Added min, max parameters to time generator
    • Added min, max parameters to timestamp generator
    • Added min, max parameters to datetime generator
    • PostgreSQL sequences updating after seed
      Bug Fixes
    • [BUG]: drizzle seed doesn't work with libSQL
    • [BUG]: Seed UUIDs not compatible with Zod/v4
    • [BUG]: drizzle seed generates invalid input value (number) for enum strings (pg)
    • [BUG]: drizzle seed breaks serial sequence sync with Postgres serial type
  • Drizzle Beta v1.0.0-beta.7 release
      Bug Fixes
    • [BUG]: Drizzle-kit does not consider prefix when generating migrations
    • [BUG]: drizzle-kit push removes migration table (doesn't recognize custom migration table name)
    • [BUG]:Drizzle pull generate invalid autosummarize
    • [BUG]: drizzle-kit pull generated wrong syntax
    • [BUG]: [drizzle-kit] MSSQL - Foreign Key Constraints Generated via drizzle-kit generate are not scoped to the Correct Schema=
    • [BUG]: findFirst fails with TypeError: null is not an object (evaluating 'row[selectionItem.key]') if no results are found
    • Push command now respects a custom migration schema or/and table from drizzle.config and ignores them during the execution
  • Drizzle Beta v1.0.0-beta.6 release
      Bug Fixes
    • [BUG]: 1.0.0-beta.2 - drizzle-kit push does consider json (jsonb) key order relevant
    • [BUG]: drizzle-kit pull generates string instead of sql statement for default value
    • [BUG]: Failed schema with d1 table
    • [BUG]: drizzle-kit: push runs already applied migration
    • [BUG]: Drizzle-Kit detects change when Composite Primary Key Columns are in different order than in schema definition
    • [BUG]: drizzle-kit push always shows columns with custom types as changed even tho the type didn't change;
  • Drizzle Beta v1.0.0-beta.5 release
      Bug Fixes
    • [BUG]: error: type "serial" does not exist
    • [BUG]: jsonb default with boolean literals gets generated truen instead of true
    • [BUG]: MSSQL view incorrect syntax
    • Fixed blob columns in MySQL to work properly with RQB mapper
  • Drizzle Beta v1.0.0-beta.4 release
      Bug Fixes
    • [BUG]: migrations.sort in migrator.js does nothing - migrations run in wrong order on Linux
    • [BUG]: drizzle-kit generate not working without error
    • [BUG]: drizzle-kit check wrongly tries to use AWS Data API
  • Drizzle Beta v1.0.0-beta.3 release
      Bug Fixes
    • [BUG]: migrations.sort in migrator.js does nothing - migrations run in wrong order on Linux
    • [BUG]: drizzle-kit generate not working without error
  • Drizzle Beta v1.0.0-beta.2 release
    • MySQL use/force/ingore index now accepts unique constraints
      Bug Fixes
    • [BUG]: truncated tables on ALTER COLUMN statements
    • [BUG]: Drizzle generates incorrect SQL migration for policy permission string changes
    • [BUG]: Introspect PG _text type not recognized as an array
    • [BUG]: drizzle-kit pull fails if db includes views which are not in "tablesFilter"
    • [BUG]: AnySQLiteColumn in generated schema is not prefixed by "type" keyword
    • [BUG]: drizzle-kit generate fails with "undefined" is not valid JSON
    • [BUG]: Primary key migration fails when changing from one column to another
    • [BUG]: Operator precedence of = and IS NULL is disrespected when using eq and isNull
  • ORM v1.0.0-beta.2 release
    • MSSQL dialect support
    • CockroachDB dialect support
    • Relational Query Parts
    • Folders v3 migrations
    • Full drizzle-kit rewrite
    • Added drizzle-kit pull --init
    • schemaFilter behavior update
    • .enableRLS() deprecation
    • MySQL new column types
    • 164 bugs fixed
  • ORM v0.45.1 release
    • Fixed pg-native Pool detection in node-postgres transactions breaking in environments with forbidden require() (#5107)
  • ORM v0.45.0 release
    • Fixed pg-native Pool detection in node-postgres transactions
    • Allowed subqueries in select fields
    • Updated typo algorythm => algorithm
    • Fixed $onUpdate not handling SQL values (fixes #2388, tests implemented by L-Mario564 in #2911)
    • Fixed pg mappers not handling Date instances in bun-sql:postgresql driver responses for date, timestamp types (fixes #4493)
  • Drizzle Studio updates
    • Added query telemetry in the SQL console for Postgres and MySQL.
    • Added an option to sort tables by count (when counts are enabled).
    • Improved count retrieval logic (approximate first, then precise if < 100k).
January
  • Drizzle Beta v1.0.0-beta.12 release
    • .generatedAlwaysAs() know only accepts sql` and () => sql`
    • Postgresql dialect now have extra schema errors in ts files on generate and push commands:
    • SQLite dialect now have extra schema errors in ts files on generate and push commands:
      Bug fixes
    • [BUG]: drizzle-kit generate silently exits with code 1
    • [BUG]:Unable to resolve module node:crypto
    • [BUG]: The package at "node_modules/.bun/drizzle-orm@1.0.0-beta.2-6565b14+35e4bda3077d71da/node_modules/drizzle-orm/migrator.js" attempted to import the Node standard library module "node:crypto". It failed because the native React runtime does not include the Node standard library.
    • [BUG]: Problem with backslash in check constraint
    • [BUG]: drizzle-kit up throws error "Cannot convert undefined or null to object"
    • Fixed bun-sqlite db.get(...) returning data in array mode instead of object mode
    • Fixed effect-postgres driver ignoring cache config option
    • [BUG]: Types do not allow for placeholder usage in onConflictDoUpdate.set
    • [BUG]: alias doesn't work with views (Postgres)
    • [BUG]: select()...for("...", { of: table }) uses qualified name of table
    • [BUG]: arrayContains() generates incorrect SQL parameters for PostgreSQL, leading to operator does not exist: text[] @> record error
    • [BUG]: Params not inlined for single-table selects
  • Drizzle Studio updates
    • Fixed MySQL auto-increment.
    • Fixed issue with uppercase letters in enum column types.
    • Fixed issue with adding foreign keys.
  • Drizzle Beta v1.0.0-beta.11 release
    • Defaulted PgTimestampString timezone offset to be +00 when value gets returned as Date instance
    • Pg: Cache is now used only when explicitly defined. In recent beta versions caching was still applied even when no cache was configured
    • Separated date and int-exclusive column methods from common pg builder (separated .defaultNow(), .generatedAlwaysAsIdentity(), .generatedByDefaultAsIdentity())
    Bug fixes
    • [BUG]:drizzle-kit pull generates incorrect schema for functional/computed index
    • [BUG]: drizzle-kit pull generates invalid code for MySQL datetime with DEFAULT CURRENT_TIMESTAMP ON UPDATE
    • [BUG]: Drizzle-kit - push tries to delete non-public schemas by default (pscale_extensions)
    • [BUG]: JSON.stringify cannot serialize BigInt
    • Commutativity for MySQL now(N) and CURRENT_TIMESTAMP(N)
      MySQL pull command:
    • Creation of a primary key when a column had only UNIQUE and NOT NULL
    • varbinary() config was ignored in a ts schema file
    • Foreign key column duplication when constraint names matched across multiple databases
    • Inconsistent casing between schema.ts and relations.ts
    • Cyclic references are generated as inline .references((): AnyMySqlColumn => ...) to avoid type errors for single-column references
      Common:
    • Relation name collisions with column names during introspection. If a relation name collides with a column name - the relation is renamed to Relation
  • Drizzle Beta v1.0.0-beta.9 release
    • Native @effect/sql-pg driver support
    • Reworked PgColumn type chain
    • Fixed lack of query result recalculation on pg dynamic update with joins
    • Switched MySQL2 default client from CallbackPool to Pool
February
  • Drizzle Studio updates
    • Improved performance.
  • Drizzle Beta v1.0.0-beta.15 release
    • We've stopped maintaining separate validator packages (e.g., drizzle-zod, drizzle-valibot) and moved them into the drizzle-orm repo. This consolidates everything into a single package and eliminates the need to manage separate peer dependencies and versioning.
    • New validation package is available: drizzle-orm/effect-schema
    • Fixed sqlite select not allowing SQL.Aliased in .orderBy(...), .groupBy(...)
    • Made name argument in .prepare(name) optional in Gel, Postgres, Cockroach dialects (generated automatically if not passed)
  • Drizzle Beta v1.0.0-beta.14 release
    • The migrator now applies all changes that are missing in the database. Previously the migrator only looked for local migrations with a creation date later than the last migration applied in the database
    Bug fixes
    • [BUG]: Cache is not invalidated after table updates
    • [BUG]: Composite index with sort outputs a malformed SQL
    • [BUG]: db introspection generates broken schema.ts syntax
    • random property is set on Array.prototype with enumerable: true
    • Fixed error TS7056 appearing when using "declaration": true in defineRelations with reworked PgColumns
    • [BUG]: mssql transaction is not a function
    • Fixed an error when seeding a composite unique column that includes a foreign key
    • Postgres: DROP INDEX statement did not respect schema
    • Restricted usage of async functions in sync drivers' transactions
  • Drizzle Beta v1.0.0-beta.13 release
    • Enabled top-level await in drizzle-kit.config and schema files on Node.js by replacing require() with async loadModule() using jiti
    • Fixed [FEATURE]: Support Top-level await in drizzle.config.ts
    • Fixed [BUG]: SyntaxError: Cannot use import statement outside a module with drizzle-kit
    • Native Effect Logger integration
    • New Effect Cache configuration
March
  • Drizzle Beta v1.0.0-beta.18 release
    • resolved tsconfig path aliases in drizzle-kit loader using get-tsconfig + jiti alias mapping
    • added fixtures and tests covering wildcard and non-wildcard path aliases
    • ensured schema load succeeds for alias imports
    • Updated to hanji@0.0.8 - native bun stringWidth, stripANSI support, errors for non-TTY environments
    • [BUG]: drizzle-kit@1.0.0-beta.13 regression in module resolution
    • [BUG]: drizzle-kit does not support node:sqlite
  • KIT v0.31.8 release
    • Updated to hanji@0.0.8 - native bun stringWidth, stripANSI support, errors for non-TTY environments
    • We've migrated away from esbuild-register to tsx loader, it will now allow to use drizzle-kit seamlessly with both ESM and CJS modules
    • We've also added native Bun and Deno launch support, which will not trigger tsx loader and utilise native bun and deno imports capabilities and faster startup times
  • Drizzle Beta v1.0.0-beta.17 release
    • New SQLite driver node-sqlite
    • Additional checks for migrations table upgrade
  • Drizzle Beta v1.0.0-beta.16 release Fixed a regression for migrations we had in beta branch. Here is a set of important changes:
    • Added migration table versioning
    • In a new version we've added the name column that stores the full folder name of the migration
    • Matching by folder name instead of timestamps
    • Automatic upgrade with smart backfilling
    • New commutativity checks (drizzle-kit check)
  • Drizzle Studio updates
    • Reworked pagination.
    • Added column reordering.
    • Added a separate component for sorting (not only via column header clicks).
    • Added right-click support on selected cells for copy/paste.
    • Added dynamic naming for subviews if they are not explicitly renamed.
    • Added filter value validation.
April
  • Drizzle Beta v1.0.0-beta.22 release
    • drizzle-kit generate fails to generate correct migrations.js file on Windows
    • [BUG]: MSSQL real() column returns imprecise float64 values -- missing mapFromDriverValue
    • Object key collision
    • [BUG]:beta20 Migration to Cloudflare D1 fails
    • [BUG]: drizzle-kit migrate: migration SQL failures exit with code 1 but print no error (MigrateProgress hides rejection)
    • [BUG]: MS SQL Filtered Index - Drizzle Kit incorrectly generates fully qualified column name in WHERE clause
    • [BUG]: [Drizzle-kit][Pg] Altering a UNIQUE constraint: generated SQL ignores the new changes
    • [BUG]: Non-commutative migration false positive: create_index commutativity check ignores table name
    • Commutativity checks were updated for PostgreSQL and MySQL. Before, create_index statements could be reported as non-commutative even when they targeted different tables, and --ignore-conflicts could still collapse multi-parent history down to a single parent. Now index/table/schema footprints are resolved more accurately, unrelated index branches are accepted, and --ignore-conflicts preserves all open leaf parents for the next migration
    • fix: mark mssql and @types/mssql as optional peer dependencies
  • Drizzle Beta v1.0.0-beta.20 release
    • Fixed sql.identifier(), sql.as() escaping issues. Previously all the values passed to this functions were not properly escaped causing a possible SQL Injection (CWE-89) vulnerability
  • Drizzle Beta v1.0.0-beta.19 release
    • sql commenter feature
    • Fixed error message for the defineRelations function
    • [BUG]: drizzle-kit push attempts to drop policies in excluded schemas (e.g. cron) despite schemaFilter: ["public"]
    • [BUG]: error attempting to drizzle-kit migrate table with char array field generated using drizzle-kit generate
    • [BUG]: Ignore Vim *.swp files in drizzle-kit generate
    • [BUG]: drizzle-kit pull outputs access method name instead of operator class for ivfflat indexes
    • [BUG]: drizzle-kit pull generates not enough data provided to build the relation
    • drizzle-kit push fails with Turso/libSQL on table recreation: "cannot commit - no transaction is active"
    • [BUG]: Cannot read properties of undefined (reading 'requestLayout') when running drizzle-kit introspect (MySQL)
    • [BUG (beta)]: RDS Data API pulling schema error
    • [BUG]: drizzle-kit commutative migrations takes only last leaf migration into account
    • Updated migrate() function for mysql dialect to correctly manage multiple databases
    • The behavior for reading schema files has been updated. From now only files with the following extensions will be processed: .js .mjs .cjs .jsx .ts .mts .cts .tsx. All other file types will be ignored
  • Drizzle Studio updates
    • Improved performance.
May
  • Drizzle Beta v1.0.0-rc.3 release Porting all the changes that were made in PostgreSQL to other dialects. This release is about MySQL:
    • Removed RQBv1 from mysql dialect (._query)
    • Internal MySQL sessions refactoring and moving to a unified query preparation function
    • Fallback to regular queries on iterators for drivers that don't support streaming instead of throwing an error for compatibility
    • Enabled optimized non-jit mappers for regular queries for MySQL dialect
    • Switched RQBv2 to array mode querying, disabled root query level JSON conversions
    • Fixed MySQL proxy driver not using lastInsertId, affectedRows from dedicated response fields
  • Drizzle Beta v1.0.0-rc.2 release
    • Disabled default codec type selectors for custom columns (fixes #5711)
    • Сallback type overload for codec selector in custom pg columns (codec: (config) => config?.withTimeZone ? 'timestamptz' : 'timestamp')
    • Extended list of postgis types for codecs (improvement for #5711)
    • Updated codecs: geometry -> geometry(point), geometry:tuple -> geometry(point):tuple
    • Switched PG transactions from class properties back to class methods (fixes #5709)
    • Updated AWS Data Api codecs, removed query typings, improved input param mapping
    • Removed prepared query typings field from all builders
    • Added column argument to CastParam,CastArrayParam codecs
    • Fixed DrizzleQueryError and TransactionRollbackError constructors to properly set the error name for better instanceof checks
    • Fixed error handling in aws-data-api to properly show database error messages
  • Drizzle Beta v1.0.0-rc.1 release
    • ⚠️ This release introduced a breaking change into our casing API and removed RQB v1 ._query
    • Effect v4 native support
    • JIT row mappers to reduce ORM overhead to ~0
    • Reworked casing API (breaking change)
    • Drizzle for LLM agents (preview)
  • Drizzle Studio updates
    • Fixed index introspection for partitioned tables.
    • Fixed schema introspection failing for non-admin users.
June
  • Drizzle Beta v1.0.0-rc.4 release SQLite query improvements, more Turso and Effect drivers, and Drizzle Kit tools for scripts and AI coding agents.
    • SQLite now uses optimized row mappers and array-mode results for Relational Queries v2. The old relational query API (db._query) has been removed from SQLite.
    • Added Turso serverless and sync drivers, plus Effect drivers for PGlite, SQLite, libSQL, D1 and MySQL.
    • Added nested transactions for Turso database and WASM drivers, plus a filesystem-free WASM migrator.
    • Typed sql expressions now preserve nullability through .mapWith(), with a new .nullable() method for possibly null results.
    • db.insert(table).select(...) no longer requires matching column order and can omit columns with defaults or nullable columns.
    • Added MySQL codecs and fixed value conversions in SQL expressions, subqueries and unions, along with MySQL float and timestamp handling.
    • Drizzle Kit now offers JSON output and a typed SDK at drizzle-kit/cli. Scripts can supply hints for renames and data-loss decisions without interactive prompts.
    • Added drizzle-kit mcp to expose migration commands to AI agents, and drizzle-kit skills to install the accompanying agent instructions.
  • Drizzle Studio updates
    • Added the ability to copy rows to the clipboard in addition to exporting.
    • Added drag-and-drop support for column ordering.
    • Added a subview in the SQL console results panel to show which query a result belongs to.
    • Improved support for SQLite BLOB columns.
    • Added Cmd/Ctrl+A shortcut for selecting all rows.
July
  • Drizzle Studio updates
    • Added enum values to the filters.
    • Added the ability to update table/view counts in the menu.
    • Added the ability to sort by multiple columns.
    • Added Cmd/Ctrl+A shortcut for selecting all rows.
    • Added Option/Alt+N shortcut for adding a new row.
    • Added Option/Alt+F shortcut for filtering rows.
    • Added the ability to copy table creation statements to the clipboard.
    • Added the ability to export and copy rows in SQL format (insert statements).
    • Reworked header cell sorting functionality.
    • Reworked refresh shortcuts: Cmd/Ctrl+R refreshes rows, while Shift + Cmd/Ctrl+R refreshes schema and rows.
August
  • Drizzle Studio updates
    • Added support for SHOW statements to render DDL as SQL in the SQL console.
September
  • Drizzle Studio updates
    • Improved the calendar converter to make better assumptions of timestamps in SQLite and added the ability to change them manually.
    • Fixed AWS Data API codecs system.
this month
  • Drizzle Beta v1.0.0-rc.5 release More ways to query relations, smaller PostgreSQL migration snapshots, and fixes across drivers and dialects.
    • Relational Queries v2 now supports CockroachDB and MSSQL, ordering by related data, and using subqueries as relational entities.
    • Improved relational query plans on PostgreSQL, MySQL, CockroachDB and MSSQL with a new default query strategy.
    • Added relational query caching with withCache, enabled by default for caches using the all strategy.
    • Added incremental PostgreSQL migration snapshots: the initial snapshot stores the full schema, and later snapshots store only each migration's changes.
    • Added Aurora DSQL adapters for postgres-js and node-postgres, async queries for expo-sqlite, and PostgreSQL transaction snapshot support.
    • Fixed transaction connection leaks, cache invalidation for nested and aliased queries, and React Native blob handling.
    • Improved drizzle-kit pull results for relations, constraints and indexes, and fixed migration generation and SQLite table recreation issues.
    • Changed withReplicas() to send queries to the primary by default, with explicit replica reads through db.$replica.
    • Relational filters now reject undefined and accept EmptyFilter for intentionally omitted conditions. Empty relation filters are skipped; true and false check for related rows' presence and absence.
    • Fixed postgres-js serialization of dates, times and JSON values in raw SQL and driver calls.
    • Query errors now omit parameters by default, with a paramsInErrors option to include them.
    • SQLite proxy now takes separate run, all and get executors. SQLite columns with both .$defaultFn() and .default() now use the function when inserting without a value.
  • Drizzle Studio updates
    • Reworked the Schema page and entity alteration logic.
    • Prevented loading the entire bytea content.
    • Improved bytea support with content type detection and preview capability.
Performance
Drizzle doesn't slow you down
Go to benchmark results
Drizzle
v1.0.0-beta.2
Bun Logo
Prisma
v7.1.0
Bun Logo
avg latency: 0.0ms
avg latency: 0.0ms
avg: 0 req/sec
Failed requests
Drizzle handled xNaN less requests
0
avg: 0 req/sec
Failed requests
Drizzle handled xNaN less requests
0
avg CPU load: 0.0%
avg CPU load: 0.0%
Go to benchmark results
Live on the edge
We support every major serverful and serverless runtime
live on the edge
Cloud Partner
Railway
our sponsor
Appwrite
Cloudflare Workers
Supabase functions
Vercel functions
Created by potrace 1.15, written by Peter Selinger 2001-2017
Created by potrace 1.15, written by Peter Selinger 2001-2017
Deno deploy
Bun Logo
Bun Logo
Bun
Image
Image
Lagon
Fly.io
ElectronJS
Expo
React Logo
React Logo
React Native
Browser
Connect to any database
We support all platform-specific, tcp, http and websocket based drivers
connect everywhere
our sponsor
PlanetScale
SingleStore
our sponsor
Neon
Supabase
our sponsor
Turso
PostgreSQL
our sponsor
Xata
MySQL
our sponsor
TiDB
LiteFS
our sponsor
Appwrite
image/svg+xml
image/svg+xml
SQLite
not yet sponsor
Prisma Postgres
SQLite Cloud
Drizzle Studio

We never wanted to build a database browser

Can't believe this either

Point `drizzle-kit studio` at your config and get a browser for your local database — for a quick look at your data while you build.

One Docker image in your own infrastructure, connected to all your databases. Your whole team gets a database browser on a link.

A Chrome extension that renders Studio right on top of your vendor's console — no local setup, no connection strings.

The embeddable web component behind the platforms you already use — Studio inside your own product, themed to match.

A native desktop database browser, with everything Studio does and none of the terminal — in the works.

Explore Studio Live demo
Our Sponsors
Thanks to you, Drizzle team is rich
🌧️ Cloud Partners
Our Cloud Partner
Become a sponsor
Pricing
Just kidding, Drizzle is free and open-source
You can still make your contribution!
test
Give us a star Join our community

Buy us some ramen 🍜

test
Developers love Drizzle ORM!
thdxr
Dax
I hate Drizzle
anthonysheww
Anthony Shew
I hate @DrizzleOrm so much that I wrote the Auth.js adapter for it.
adamdotdev
Adam
i know this won't get me on the homepage, but @DrizzleORM is so good
dont_know
Some Body
Django had it in 2008
EddyVinckk
Eddy Vinck
I love @DrizzleORM that's it, that's the tweet
JacobWolf
Jacob Wolf 🐝
I love @DrizzleORM.
t3dotgg
Theo
Drizzle is terrible. It doesn’t even support Mongo.
BrodaNoel
Broda Noel
Is this a joke? Because if this is a joke, it's really really really bad joke, because now I'm fucking hating @DrizzleORM without even knowing who they are. I mean, this is not a good marketing strategy if this was a marketing-joke. And if it's actually true, I'll hate them more.
imfelquis
Ofelquis Gimenes
unpredictable results is what feeds the human race, ban Drizzle now and all this typing gibberish all together
james_r_perkins
James Perkins
Sorry @DrizzleORM you suck!
James Perkins
tslamoon1
tslamoon
I'll shave my head if drizzle adds MSSQL support by the end of September.
FredKSchott
fks
Astro DB is powered by Drizzle! ... and we regret everything omg this thing sucks
_raynirola
Ray
DrizzleOrm is not an "ORM", it's merely a overrated typesafe sql wrapper, not even a query builder.
saltyAom
SaltyAom
Prisma Bun: 1.4 MB/s Drizzle Bun: 9.8 MB/s
SaltyAom
chribjel
Christoffer Bjelke
How many times has this little shit snuck into your dependencies?
Christoffer Bjelke
hisbvdis
Roma Zvarych
I have finally switched from @prisma to @DrizzleORM. It was not easy. Dear Drizzle Team, you have created an awesome orm with awfull documentation. Anyway, good for you, thanks and good luck.
jacobmparis
@jacobparis.com
@DrizzleORM can you put me on the homepage? gf says it’s drizzling outside and I want to send a link to your site
aokijs
Aoki
Honestly, fuck the benchmarks. I don‘t care which one‘s faster. All I can say is that Drizzle made my life working with databases dramastically better and that‘s all that matters for me. Thanks for your hard work 🙏🏻
silvenon
Matija Marohnić
Every time I hear about @DrizzleORM.
Matija Marohnić
spacesexdragon
Joseph Mama 🐀
Joseph Mama 🐀
aarondfrancis
Aaron Francis
Y'all should just copy everything Eloquent has
lroal
Lars-Erik Roald
Complete rewrites of core systems + new type system + new dialects + new migration engine = recipe for unexpected bugs. Claiming it'll fix 70% of existing bugs while introducing a whole new generation of them is peak software optimism

Headless TypeScript ORM with a head.