## drizzle-team/drizzle-orm — v1.0.0-rc.3…v1.0.0-rc.4

_193+ commits._

### Features
- **Move the drizzle-kit SDK to the drizzle-kit/cli subpath and add a drizzle-kit/payload surface** (1948b2f)
- **New test cases, fixed `PgColumn` `shouldDisableInsert()` not taking into account identity generations, improved `INSERT INTO table SELECT ...`** (ad90365)
- **Add the `pull` / `up` / `export` machine-readable surface and expand the installable skills catalog** (46ca9b4)
- **Add RED MCP test suite covering tool registration, annotations, envelopes, and stdout purity** (5a7eb4f)
- **Add Docker-free generate `missing_hints` fixture for MCP tests** (e58c8fc)
- **Add `@modelcontextprotocol/sdk` devDependency and bump `zod` to `^\3.25`** (1824015)
- **Add `check` conformance scenarios and extend `runners.ts` / `conformance.test.ts` for `check` command** (c25d497)
- **Extract `checkOptions`/`prepareCheck`/`runCheck` from the inline `check` brocli command, add `CheckOptions` derived type, and wire `check()` SDK export** (f6f9cd7)
- **Forced bigint support to `true` in `bun-mysql`, `mysql2`, removed unused codecs** (efa079f)
- **Add `check` composite GitHub Action posting `drizzle-kit check` results as a sticky PR comment** (6adfcd1)
- **Add machine-readable `--output text|json` to `drizzle-kit check`** (68d4592)
- **Add umbrella `drizzle` skill and a pre-publish CI gate enforcing `metadata.revision` bumps on `drizzle-kit/skills/**`** (bcec518)
- **Add run-tests repo skill teaching the test setup workflow** (2e67d58)
- **Add postgres-vector clause to compose/wait.sh and fail on unknown db** (fe3273f)
- **Add drizzle-kit .env template and ignore the local copy** (e484118)
- **Add compose/mariadb.yml and extend compose/wait.sh for mariadb** (a79f5ed)
- **Add typed pushMissingHint overload to drop as MissingHint cast in prompts resolver** (c8a74f4)
- **Add singlestore DDL-error guard, switch add_unique entity to constraint name, throw on misnamed rename hint** (1b4b60c)
- **Add fk_target_not_unique flat test for push singlestore** (9329104)
- **Add 3 singlestore confirm_data_loss describes — table, column, add_not_null** (2ae33cb)
- **Add 3 cockroach confirm_data_loss describes — primary_key, add_not_null, add_unique** (af02b95)
- **Add 4 cockroach confirm_data_loss describes — table, view, column, schema** (b755bec)
- **Add rename_schema_unsupported flat structural-error test for push mssql** (87736a8)
- **Add 3 mssql confirm_data_loss describes — add_not_null × 2, add_unique** (6cd6bae)
- **Add 4 mssql confirm_data_loss describes — table, column, schema, primary_key** (282bdb4)
- **Add UnsupportedSchemaChangeError import to push-mssql** (6385941)
- **Add sqlite confirm_data_loss recreate_table single and multi json-mode tests** (d7fa41a)
- **Add sqlite confirm_data_loss table and column-drop json-mode tests** (77c9df5)
- **Add imports and inline sqliteDbFrom helper for sqlite confirm_data_loss tests** (36fcb73)
- **Add mysql confirm_data_loss tests for type_change add_unique and structural error tests** (72a1f72)
- **Add allow_recreate hint scaffolding and unsupported schema change error** (4c6071a)
- **Add mysql and pg to seeder tests pipeline** (aaa70a6)
- **Refactor CLI context handling and enhance JSON mode support** (afd2724)
- **Finish up command JSON support** (74e9299)
- **Add JSON state support for up commands** (6a87f03)

### Fixes
- **Make the drizzle skill staleness check monorepo-aware, fix its upgrade-prompt direction, and bump the bundle revision** (710fb17)
- **Fix tsc SIGABRT under moduleResolution:"node" in `registerTool` and `hintSchema` inference** (80ec482)
- **Add credential-leak regression and bring full MCP suite green** (f30775e)
- **Implement `src/mcp/server.ts` MCP adapter and fix `writeDrizzleConfig` fixture** (d27801d)
- **Skip the public-surface dist regression with a warning when dist is unbuilt outside CI and filter `default` from the CJS probe** (c8e21f6)
- **Update `drizzle-responses-and-errors` skill for `check()` SDK export; bump umbrella skill revision to 8; fix `drizzle-output-modes` YAML parse** (aaf8806)
- **Extend `no-stdout` regression for `check`, add `public-surface` post-build assertion, and extend type-level contract tests for `CheckOptions`/`check`** (046dc02)
- **Config fix** (ea3ee54)
- **Mock fix** (b6cd3f5)
- **Bump expired skipIf postpones to 2026-06-20 and fix oxlint no-useless-undefined** (6a4c01f)
- **Post-merge fix-ups for drizzle-kit local verification** (7d3357a)
- **Fix v1 contract drift — normalize postgres dialect, document push success message, clarify reason scope** (b41528a)
- **Add sqlite confirm_data_loss add_not_null json-mode tests with Q1 regression sentinel** (1f7d193)
- **Add mysql confirm_data_loss regression tests for table column primary_key add_not_null kinds** (ed62f7d)
- **Add postgres confirm_data_loss regression tests for 7 hint kinds** (602d221)
- **Add CLI JSON regression coverage** (8a7bf59)

### Backend
- **Merge pull request #5788 from drizzle-team/rc4** (748058e)
- **Stop gating release CI on the legacy `node10` attw resolution** (f2972ac)
- **Slightly optimized types** (3fc748a)
- **Merge branch 'rc4' of https://github.com/drizzle-team/drizzle-orm into rc4** (37e71bb)
- **Fixed MSSQL core (currently unused) transaction isolation builder, added related test case** (6158642)
- **Replace the config-validation Node `util` import with `ZodError.message` and drop `util` from the CLI imports allowlist** (8919405)
- **Merge branch 'ai' into rc4** (febf886)
- **Document drizzle-kit test-design guidelines: real in-memory DBs over mocks, dependency injection over module mocking, and CI-shard coverage** (227236c)
- **Merge pull request #5942 from drizzle-team/ai** (f785529)
- **Replace mocked drizzle-kit tests with real in-memory DBs and fold surviving mcp/sdk tests into `tests/other`** (c2dd2d8)
- **Fixed type tests, fixed error text** (c110a0e)
- **Postponed uncertain case** (02513b4)
- **Merge branch 'rc4' of https://github.com/drizzle-team/drizzle-orm into rc4** (7c34a1c)
- **Merge pull request #5920 from drizzle-team/ai** (edb3e41)
- **Update skills to reference MCP** (36b0521)
- **Clarify MCP config path and conflict-check descriptions** (518a4e8)
- **Reshape the drizzle-kit resolver, confirm model, and `check` conflict contract, and refresh the hint skills** (fdb04da)
- **Harden drizzle-kit `mcp` adapter and tidy the SDK contract and docs** (25dc240)
- **Widen `toToolResult` parameter type to accept full SDK envelope unions** (4425bcc)
- **Register `mcp` brocli verb and exempt it from the after-hook process.exit(0)** (0a3950a)
- **Document `drizzle-kit mcp` server in README — three tools, consent round-trip, config param** (8ba22d5)
- **Assert captured stdout/exit calls instead of restored spies in the SDK no-stdout regressions** (9cd4201)
- **Mention `check(...)` alongside `generate`/`push` in the `drizzle-responses-and-errors` skill description and intro** (e5d5344)
- **Document `check()` as a root SDK export in `JSON_CONTRACT.md` and `SDK.md`** (efd8e14)
- **Drop unused imports left by `check` fixture extraction in `cli-json.test.ts`** (3382470)
- **Extract check snapshot-staging helpers into shared `check-fixtures.ts` and re-import in `cli-json.test.ts`** (8e03759)
- **Better `bun-mysql` `timestamp:string` codec** (110bff8)
- **Extended test postpone date, fixed test schemas** (64e8d5e)
- **Better typed `sql`** (c28d0ff)
- **Fixed `sqlite` `blob` column runtime-type default mode mismatch (fixes #1064)** (5b3d8d3)
- **Merge pull request #5931 from drizzle-team/rc4-tests-issues** (bc3c2fd)
- **updates in test** (916e83f)
- **Merge branch 'rc4' of github.com:drizzle-team/drizzle-orm into rc4-tests-issues** (a65dd7e)
- **added tests from issues** (07b5586)
- **Fixed typos, removed `jit` config option from `@effect/sql-sqlite-do` driver, supported `@effect/sql-d1` driver** (fa7bdbc)
- **Fixed effect postgres drivers returning object mode instead of row mode responses on `db.execute`** (116462b)
- **Effect mysql (#5895)** (e8d8c25)
- **Fixed unguarded `Buffer` reference in `drizzle-orm/effect-schema` that caused error in environments without `Buffer`** (3327c01)
- **Commutative fixes (#5892)** (d1c22c6)
- **Merge pull request #5875 from drizzle-team/commutativity-check-action** (dbb6ee4)
- **Merge pull request #5691 from drizzle-team/ai** (26b603d)
- **Drop redundant json guard on verbose push SQL logging** (7595f48)
- **Require PR base SHA in skills revision gate and drop fork-point detection; omit the gate from the manual publish workflow** (ed3ed5b)
- **Guard non-TTY push prompts behind typed errors** (ce1aab0)
- **Gate rc4 turso driver logs behind --output json** (f9b01cd)
- **Reconcile rebase flattening artifacts: restore stack files dropped by the flattened merges to their pre-rebase content and apply rc4's `connectToTursoRemote` alias to the sqlite/turso dispatch in `cli/schema.ts`** (c7d49c5)
- **Update README** (1d0fa0a)
- **Rework drizzle-kit output into orthogonal --output text|json and interactivity axes, and ship the public SDK and agent skills** (9c80b2a)
- **Replace `@tanstack/intent` shell-out in `drizzle-kit skills` with a local-path `npx skills` invocation and package-manager detection** (aba8913)
- **Bundle drizzle-kit installable-skills catalog with `skills` subcommand and align `primary_key` hint kind on the wire** (100d563)
- **Scope loadModule default-export unwrap to drizzle config imports** (763aef8)
- **Restore beta error wording in cli-*.test.ts; restructure mssql validator** (23de948)
- **drizzle-kit SDK + CLI envelope refactor** (9833370)
- **Rename run-tests skill and shorten its description** (dd77ee1)
- **Set TEST_CONFIG_PATH_PREFIX inline in cli-export/cli-migrate tests and document expired skipIf workflow** (eb71c6c)
- **Capture phase 16 verify run summary** (5df2bc7)
- **Restore beta hint emission at mssql rename_schema_unsupported throw site** (16d60cc)
- **Restore beta hint emission at mssql rename_blocked_by_check_constraint throw site** (95e7017)
- **Restore beta hint emission at mysql drop_pk_dependency throw site behind json gate** (a681001)
- **Rewrite compose/dockers.sh as a docker-compose dispatcher** (93dc69c)
- **Rename confirm_data_loss kinds back to add_not_null and add_unique, restructure JSON contract doc** (39150dd)
- **Apply six v1.1 code-hygiene cleanups across push handlers, errors, hints, and prompts** (b88887f)
- **Restructure JSON contract doc with table-driven kinds, reasons, and error codes** (d201be4)
- **Consolidate UnsupportedSchemaChangeError to one code with meta.kind discriminator** (435078d)
- **Rename confirm_data_loss kinds to not_null_constraint and unique_constraint, drop unused resolver command param, restructure JSON contract doc** (6cb6d8e)
- **Address deferred phase-10 review findings — doc cleanup and dead-code removal** (6e4ec70)
- **Align JSON dialect with config literal, drop push success message** (fb56265)
- **Rewrite JSON_CONTRACT.md to v1-stable structure** (2132e92)
- **Remove allow_recreate hint type from contract** (66e0267)
- **Remove aborted JSON status** (46a6930)
- **Restructure push-singlestore aborted block to interactive-only** (1c31929)
- **Restructure push-cockroach aborted block to interactive-only** (a0cb41a)
- **Replace push-mssql aborted JSON-mode test with rename_blocked_by_check_constraint structured-error test** (b170faf)
- **Throw UnsupportedSchemaChangeError for rename_column-in-check and rename_schema in push-mssql** (cae2b62)
- **Remove JSON-mode aborted branch from push-mssql suggestion-hints block** (bf94143)
- **Attach DELETE truncate to push-sqlite add_not_null matched-hint flow** (90825c1)
- **Restructure push-sqlite aborted block to interactive-only** (ab0c09d)
- **Format mysql confirm_data_loss test fixtures** (43e07e5)
- **Use destructured locals in fk_target_not_unique throw** (9bf28a9)
- **Emit type_change confirm_data_loss hint from push-mysql alter_column** (efd4f76)
- **Throw fk_target_not_unique error from push-mysql suggestions** (6e0dd8e)
- **Throw drop_pk_dependency error from push-mysql suggestions** (aafb7b2)
- **Restructure push-mysql aborted block to interactive-only** (f16207f)
- **Restructure push-postgres aborted block to interactive-only** (96da599)
- **Update JSON contract docs** (6cab976)
- **+** (232c85b)
- **Rollback unnecessary changes** (8af3d05)
- **Update test conditions and connection string handling** (925d2d0)
- **Refactor hints handling: rename hasUnresolved to hasMissingHints and update related logic** (5032c5f)
- **Derive hint types and schemas from source-of-truth arrays** (1258cd3)
- **Snapshot current drizzle-kit hint and JSON work** (23905f9)
- **Fail JSON push interactivity explicitly** (2e3e036)
- **Normalize push explain dry-run behavior** (cba5c6d)
- **Simplify generate explain output flow** (8b0b1f0)
- **Bump brocli to 0.12.0** (0f10282)
- **Refactor logging in CLI validations and serializers to use humanLog for better output formatting** (9ce0f15)
- **Convert push command failure handling** (610a9af)
- **Convert pull command failure handling** (823e2ce)
- **Convert remaining generate dialect handlers** (5af8baf)

_Recap by [Repo Wrapped](https://repowrapped.com/gh/drizzle-team/drizzle-orm?utm_source=github-action)._