Drizzle ORM

• Fixed broken View types when using Subquery in selection
• Fixed custom types’ JSON field API not being applied when column is used as a decoder on SQL fields
• Fixed codecs not getting applied to SQL field when .mapWith(column) is set (fixes #5724)
• Fixed Subquery fields’ columns’ codecs not being applied to subquery
• Fixed broken in rc.3 db.select in bun-sql/pg driver (fixes #5779)
• Updated SQLite db.$count builder to include .sync() executor for sync drivers
• Removed RQBv1 from sqlite, removed RQBv1 TSchema, TFullSchema arguments from sqlite entities’ generics
• Fixed instances of sqlite query errors not being wrapped in DrizzleQueryError (db.batch() excluded due to api incompatibility)
• Fixed type error on CockroachArrayBuilder constructor caused by referencing internal field’s type
• Removed mapResult method from PreparedQuery interface, removed mapResult, mapBatchResult from pg and sqlite raw queries
• Fixed wrong bun-sqlite run result type
• Switched sqlite RQBv2 to array mode
• Enabled optimized default query mappers for sqlite
• Reworked sqlite sessions: replaced per-driver PreparedQuery instances with executors passed via sessions, similar to current postgresql and mysql implementations, moved useJitMappers flag handling to dialect
• Fixed missing string overload on .comment(sqlCommenterComment) in query builders
• Supported nested transactions in @tursodatabase/database, @tursodatabase/database-wasm
• Added filesystem-free migrator for @tursodatabase/database-wasm at drizzle-orm/tursodatabase/wasm-migrator
• Split SQLite into async, effect versions (sync remains subtype of async)
• Removed SQLiteSyncDialect, SQLiteAsyncDialect, moved generic SQLite async\sync migrators to sqlite-core/async/session as migrateSync, migrateAsync
• Fixed sqlite cache using same cache entry for different execute methods
• Moved EffectDrizzlePgConfig to drizzle-orm/pg-core/effect/utils
• Made cache field in EffectCacheShape optional
• Split mysql into async, effect versions
• Added codec system to mysql
• Fixed mysql float rounding to either 6 digits or double
• Fixed mysql cropping .000 from timestamp(3)
• Moved subquery mapper selection from dialect.buildSelection to orderSelectedFields;
• [PG, MySQL] Improved codec system in set operators:
  • When different db types are crossed in a union, db casts them to type it deems as closest compatible to all types involved
  • If columns with codecs are set on both sides of union - codec of combined type will apply
  • If only the left-hand side of union has field with codec - left hand side’s codec is preserved
  • If left-hand side field is devoid of codecs - field is not processed by codecs;
  • Set operator queries are switched from [QUERY 1] UNION [QUERY 2] to SELECT ... FROM ([QUERY 1] UNION [QUERY 2]) "drizzle_union" so cast codecs would apply after union’s type mutation
  • Retrieved data of union with different types still may be lossy due to db’s own conversion
• Bump required effect package versions to 4.0.0-beta.83
• Fixed sql.param passing Placeholder as expected input value to encoder function instead of Placeholder’s value type
• Fixed unguarded Buffer reference in drizzle-orm/effect-schema that caused error in environments without Buffer
• Fixed sqlite blob column runtime-type default mode mismatch (fixes #1064)
• Improved typed sql operator - preserved nullability, inferred initial data type to mapWith callback argument, added .nullable() method to modify output type with | null (fixes #571):

    // Before:
    sql<Type | null>`...`.mapWith((v: any) => String(v)) // Output type: string
    // After:
    sql<Type | null>`...`.mapWith((v: Type) => String(v)) // Output type: string | null
    // `.nullable()` method:
    sql`...`.mapWith((v: unknown) => new Type(v)).nullable() // Output type: Type | null

• Fixed generatedByDefaultAsIdentity columns not being filtered from inserts in runtime in postgres dialect
• Improved db.insert(table).select(...): removed column order match requirement, allowed skipping selection for columns with defaults or nullability (fixes #3608)

Drivers

• Updated @tursodatabase/database, @tursodatabase/database-wasm to v0.6.0, updated session internals for asynchronous prepare on driver side
• Added @tursodatabase/serverless driver support
• Added @tursodatabase/sync driver support
• Added @effect/sql-pglite driver support
• Added @effect/sql-sqlite-node driver support
• Added @effect/sql-sqlite-bun driver support
• Added @effect/sql-sqlite-do driver support
• Added @effect/sql-sqlite-wasm driver support
• Added @effect/sql-libsql driver support
• Added @effect/sql-d1 driver support
• Added @effect/sql-mysql2 driver support
• Fixed @effect/sql-pg driver returning object response instead of raw response on db.execute
• pg-proxy: added dialect config to optional dialect creator callback

Drizzle Kit

• Fixed postgres pull from failing for non-admin roles (fixes #5568)

• Fixed: [mssql] INSERT includes generatedAlwaysAs (computed) columns in the column list: SQL Server error 271

Machine-readable output & programmatic SDK

• Added an --output text|json mode to generate, push, pull, up, export, and check. In json mode each command emits a typed JSON envelope (status, errors, payloads) for programmatic and agent consumption (see OUTPUT_MODES.md, JSON_CONTRACT.md)
• Shipped a public programmatic SDK at the drizzle-kit/cli subpath exposing generate(), push(), pull(), up(), exportSql(), and check() with typed options and results matching the CLI JSON contract (see SDK.md)
• Auto-detected non-interactive mode (--output json, or --output text with a non-TTY stdin) no longer renders interactive prompts. Instead, unresolved renames and destructive changes (confirm_data_loss) are surfaced as a missing_hints envelope (or a missing-decisions report under text) and resolved by supplying a structured hints array up front via --hints / --hints-file (see HINTS.md)

MCP server

• Added drizzle-kit mcp, a Model Context Protocol server over stdio that exposes the migration lifecycle (generate, push, check, export, up, pull) as MCP tools for any MCP-capable AI agent (see MCP.md)

Agent skills

• Added drizzle-kit skills, which installs Drizzle Kit’s bundled Agent Skills into your project for AI coding assistants. Ships 8 skills: drizzle, drizzle-generate, drizzle-hints, drizzle-migrations, drizzle-output-modes, drizzle-pull, drizzle-push, and drizzle-responses-and-errors (see drizzle-kit/skills folder)

Sources

• Published release
• Drizzle ORM changelog
• Drizzle Kit changelog