Gathering detailed insights and metrics for mysql2
Gathering detailed insights and metrics for mysql2
⚡ fast mysqljs/mysql compatible mysql driver for node.js
Installations
npm install mysql2Developer Guide
BETA
Typescript
No
Module System
CommonJS, ESM
Min. Node Version
>= 8.0
Node Version
22.14.0
NPM Version
10.9.2
Score
98.3
Supply Chain
99.3
Quality
91.5
Maintenance
100
Vulnerability
99.6
License
Releases
59
Languages
4
JavaScript
TypeScript
HTML
Shell
JavaScript (93.38%)
TypeScript (6.6%)
HTML (0.01%)
Shell (0.01%)
Developer
Download Statistics
Total Downloads
400,660,798
Last Day
537,332
Last Week
2,938,330
Last Month
12,466,922
Last Year
140,848,341
GitHub Statistics
MIT License
4,230 Stars
3,552 Commits
630 Forks
58 Watchers
22 Branches
218 Contributors
Updated on May 29, 2025
Bundle Size
772.15 kB
Minified
332.77 kB
Minified + Gzipped
Maintainers
3
Package Meta Information
Latest Version
3.14.1
Package Id
mysql2@3.14.1
Unpacked Size
513.99 kB
Size
123.17 kB
File Count
124
NPM Version
10.9.2
Node Version
22.14.0
Published on
Apr 27, 2025
Total Downloads
Cumulative downloads
Total Downloads
400,660,798
Last Day
-5.1%
537,332
Compared to previous day
Last Week
-1.3%
2,938,330
Compared to previous week
Last Month
7.6%
12,466,922
Compared to previous month
Last Year
42.3%
140,848,341
Compared to previous year
Weekly Downloads
Monthly Downloads
Yearly Downloads
Dependencies
9
MySQL2
English | 简体中文 | Português (BR)
MySQL client for Node.js with focus on performance. Supports prepared statements, non-utf8 encodings, binary log protocol, compression, ssl much more.
Table of Contents
History and Why MySQL2
MySQL2 project is a continuation of MySQL-Native. Protocol parser code was rewritten from scratch and api changed to match popular Node MySQL. MySQL2 team is working together with Node MySQL team to factor out shared code and move it under mysqljs organization.
MySQL2 is mostly API compatible with Node MySQL and supports majority of features. MySQL2 also offers these additional features:
- Faster / Better Performance
- Prepared Statements
- MySQL Binary Log Protocol
- MySQL Server
- Extended support for Encoding and Collation
- Promise Wrapper
- Compression
- SSL and Authentication Switch
- Custom Streams
- Pooling
Installation
MySQL2 is free from native bindings and can be installed on Linux, Mac OS or Windows without any issues.
1npm install --save mysql2
If you are using TypeScript, you will need to install @types/node.
1npm install --save-dev @types/node
For TypeScript documentation and examples, see here.
Documentation
Acknowledgements
- Internal protocol is written by @sidorares MySQL-Native.
- Constants, SQL parameters interpolation, Pooling,
ConnectionConfigclass taken from Node MySQL. - SSL upgrade code based on @TooTallNate code.
- Secure connection / compressed connection api flags compatible to MariaSQL client.
- Contributors.
Contributing
Want to improve something in MySQL2? Please check Contributing.md for detailed instruction on how to get started.
To contribute in MySQL2 Documentation, please visit the Website Contributing Guidelines for detailed instruction on how to get started.
Critical
9.8/10
Summary
MySQL2 for Node Arbitrary Code Injection
Affected Versions
< 3.9.7
Patched Versions
3.9.7
Critical
9.8/10
Summary
mysql2 Remote Code Execution (RCE) via the readCodeFor function
Affected Versions
< 3.9.4
Patched Versions
3.9.4
High
8.2/10
Summary
mysql2 vulnerable to Prototype Pollution
Affected Versions
< 3.9.8
Patched Versions
3.9.8
Moderate
6.5/10
Summary
mysql2 vulnerable to Prototype Poisoning
Affected Versions
< 3.9.4
Patched Versions
3.9.4
Moderate
6.5/10
Summary
mysql2 cache poisoning vulnerability
Affected Versions
< 3.9.3
Patched Versions
3.9.3
Reason
30 commit(s) and 8 issue activity found in the last 90 days -- score normalized to 10
Reason
security policy file detected
Details
- Info: security policy file detected: SECURITY.md:1
- Info: Found linked content: SECURITY.md:1
- Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
- Info: Found text in security policy: SECURITY.md:1
Reason
no dangerous workflow patterns detected
Reason
no binaries found in the repo
Reason
license file detected
Details
- Info: project has a license file: License:0
- Info: FSF or OSI recognized license: MIT License: License:0
Reason
packaging workflow detected
Details
- Info: Project packages its releases by way of GitHub Actions.: .github/workflows/canary.yml:15
Reason
SAST tool is run on all commits
Details
- Info: SAST configuration detected: CodeQL
- Info: all commits (30) are checked with a SAST tool
Reason
0 existing vulnerabilities detected
Reason
dependency not pinned by hash detected -- score normalized to 4
Details
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:29: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/benchmark.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:34: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/benchmark.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:39: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/benchmark.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:55: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/benchmark.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:61: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/benchmark.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/canary.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/canary.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/canary.yml:51: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/canary.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/canary.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/canary.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-coverage.yml:35: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-coverage.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-coverage.yml:42: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-coverage.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-coverage.yml:47: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-coverage.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci-coverage.yml:64: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-coverage.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:35: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:42: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:47: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:81: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:86: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:91: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:95: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:141: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:146: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:151: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:155: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:199: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:204: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:209: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-linux.yml:213: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-linux.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-mysql.yml:48: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-mysql.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-mysql.yml:55: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-mysql.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-mysql.yml:60: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-mysql.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-osx.yml:28: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-osx.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-osx.yml:39: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-osx.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-osx.yml:44: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-osx.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-tsc-build.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-tsc-build.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-tsc-build.yml:23: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-tsc-build.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-tsc-build.yml:28: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-tsc-build.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-website.yml:13: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-website.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-website.yml:16: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-website.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-website.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-website.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-windows.yml:29: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-windows.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci-windows.yml:31: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-windows.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci-windows.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/ci-windows.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:42: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:46: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:71: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/gh-pages.yml:15: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/gh-pages.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/gh-pages.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/gh-pages.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/gh-pages.yml:23: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/gh-pages.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/gh-pages.yml:42: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/gh-pages.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/lint.yml:16: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/lint.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/lint.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/lint.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/lint.yml:23: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/lint.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:15: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/release.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:22: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/release.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/release.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/sidorares/node-mysql2/release.yml/master?enable=pin
- Warn: npmCommand not pinned by hash: .github/workflows/lint.yml:31
- Info: 0 out of 49 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 8 third-party GitHubAction dependencies pinned
- Info: 13 out of 14 npmCommand dependencies pinned
Reason
no effort to earn an OpenSSF best practices badge detected
Reason
detected GitHub workflow tokens with excessive permissions
Details
- Info: jobLevel 'actions' permission set to 'read': .github/workflows/codeql-analysis.yml:28
- Info: jobLevel 'contents' permission set to 'read': .github/workflows/codeql-analysis.yml:29
- Warn: no topLevel permission defined: .github/workflows/benchmark.yml:1
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/canary.yml:10
- Warn: no topLevel permission defined: .github/workflows/ci-coverage.yml:1
- Warn: no topLevel permission defined: .github/workflows/ci-linux.yml:1
- Warn: no topLevel permission defined: .github/workflows/ci-mysql.yml:1
- Warn: no topLevel permission defined: .github/workflows/ci-osx.yml:1
- Warn: no topLevel permission defined: .github/workflows/ci-tsc-build.yml:1
- Warn: no topLevel permission defined: .github/workflows/ci-website.yml:1
- Warn: no topLevel permission defined: .github/workflows/ci-windows.yml:1
- Warn: no topLevel permission defined: .github/workflows/codeql-analysis.yml:1
- Warn: no topLevel permission defined: .github/workflows/gh-pages.yml:1
- Warn: no topLevel permission defined: .github/workflows/lint.yml:1
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:8
- Info: no jobLevel write permissions found
Reason
project is not fuzzed
Details
- Warn: no fuzzer integrations found
Reason
branch protection not enabled on development/release branches
Details
- Warn: branch protection not enabled for branch 'master'
Score
6.7
/10
Last Scanned on 2025-05-19
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.
Learn More