Skip to content

Conversation

@Jay-Lokhande
Copy link
Contributor

@Jay-Lokhande Jay-Lokhande commented Dec 27, 2025

Update @prisma/adapter-mssql to use mssql v12.2.0 instead of v11.0.1

Closes #28944

Summary by CodeRabbit

  • Chores
    • Updated MSSQL database adapter to the latest version, bringing improvements and stability enhancements.

✏️ Tip: You can customize this high-level summary in your review settings.

Update @prisma/adapter-mssql to use mssql v12.2.0 instead of v11.0.1

Closes prisma#28944
@CLAassistant
Copy link

CLAassistant commented Dec 27, 2025

CLA assistant check
All committers have signed the CLA.

@coderabbitai
Copy link
Contributor

coderabbitai bot commented Dec 27, 2025

Important

Review skipped

Review was skipped due to path filters

⛔ Files ignored due to path filters (1)
  • pnpm-lock.yaml is excluded by !**/pnpm-lock.yaml

CodeRabbit blocks several paths by default. You can override this behavior by explicitly including those paths in the path filters. For example, including **/dist/** will override the default block on the dist directory, by removing the pattern from both the lists.

You can disable this status message by setting the reviews.review_status to false in the CodeRabbit configuration file.

Walkthrough

Updated the mssql package dependency in the MSSQL adapter from version ^11.0.1 to ^12.2.0 to use the latest version of the mssql library.

Changes

Cohort / File(s) Change Summary
Dependency Update
packages/adapter-mssql/package.json
Updated mssql dependency from ^11.0.1 to ^12.2.0

Pre-merge checks and finishing touches

✅ Passed checks (5 passed)
Check name Status Explanation
Description Check ✅ Passed Check skipped - CodeRabbit’s high-level summary is enabled.
Title check ✅ Passed The pull request title accurately and concisely summarizes the main change: updating the mssql dependency in adapter-mssql to v12.2.0.
Linked Issues check ✅ Passed The code changes directly implement the requirement from issue #28944 to update mssql dependency to ^12.2.0 in packages/adapter-mssql/package.json.
Out of Scope Changes check ✅ Passed All changes are scoped to the single dependency update requested in issue #28944 with no extraneous modifications.
Docstring Coverage ✅ Passed No functions found in the changed files to evaluate docstring coverage. Skipping docstring coverage check.

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

Comment @coderabbitai help to get the list of available commands and usage tips.

Copy link
Contributor

@coderabbitai coderabbitai bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Actionable comments posted: 0

Caution

Some comments are outside the diff and can’t be posted inline due to platform limitations.

⚠️ Outside diff range comments (1)
packages/adapter-mssql/package.json (1)

44-44: Update @types/mssql to match the runtime version.

The @types/mssql package is at version 9.1.8 while the runtime mssql dependency is being updated to 12.2.0. This significant version gap creates type safety risks:

  • Type definitions may not match the actual v12 API
  • New features and changes in v12 won't be properly typed
  • TypeScript won't catch potential runtime errors from API changes

Please verify the latest available version of @types/mssql and update accordingly:

#!/bin/bash
# Description: Check latest version of @types/mssql on npm

curl -s https://registry.npmjs.org/@types/mssql | jq '.["dist-tags"].latest, .versions | keys | .[-5:]'
📜 Review details

Configuration used: Organization UI

Review profile: ASSERTIVE

Plan: Pro

📥 Commits

Reviewing files that changed from the base of the PR and between d7a32bd and f987e83.

⛔ Files ignored due to path filters (1)
  • pnpm-lock.yaml is excluded by !**/pnpm-lock.yaml
📒 Files selected for processing (1)
  • packages/adapter-mssql/package.json
🔇 Additional comments (1)
packages/adapter-mssql/package.json (1)

40-40: Verify mssql v12 compatibility with integration tests.

mssql v12 includes a breaking change: config objects are no longer cloned by the library and must not be mutated after being passed to the connection pool. The adapter implementation does not mutate the config after passing it to mssql, which is compatible with this change. However, run integration tests to confirm the upgrade works correctly with your SQL Server instances, especially around connection pooling and authentication flows.

@Jay-Lokhande
Copy link
Contributor Author

Jay-Lokhande commented Jan 14, 2026

@jacek-prisma would you like to give review

@aqrln aqrln added this to the 7.3.0 milestone Jan 20, 2026
@dosubot dosubot bot added the lgtm This PR has been approved by a maintainer label Jan 20, 2026
@aqrln aqrln merged commit da6f8f7 into prisma:main Jan 20, 2026
255 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

lgtm This PR has been approved by a maintainer

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Update @prisma/adapter-mssql to use newest mssql (v12)

4 participants