mysql2

fast mysql driver. Implements core protocol, prepared statements, ssl and compression in native JS

MIT 287 个版本

mysql client server

主页

仓库

提交 Issue

安装

npm install mysql2

yarn add mysql2

pnpm add mysql2

bun add mysql2

README

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
Installation
Documentation
Acknowledgements
Contributing

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.

npm install --save mysql2

If you are using TypeScript, you will need to install @types/node.

npm install --save-dev @types/node

For TypeScript documentation and examples, see here.

Documentation

Quickstart
- First Query, Using Prepared Statements, Using Connection Pools and more.
Documentation
Examples
FAQ

Acknowledgements

Internal protocol is written by @sidorares MySQL-Native.
Constants, SQL parameters interpolation, Pooling, ConnectionConfig class 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.

版本列表

3.22.5 2026-06-06

3.22.5-canary.2af33a1 2026-06-06

3.22.4 2026-05-26

3.22.3 2026-04-27

3.22.3-canary.e72f923d 2026-04-23

3.22.2 2026-04-21

3.22.2-canary.c79a3f32 2026-04-20

3.22.1 2026-04-17

3.22.1-canary.cb5adccb 2026-04-10

3.22.1-canary.5b6206c8 2026-04-17

3.22.0 2026-04-10

3.21.2-canary.ab131de5 2026-04-10

3.21.2-canary.884bec56 2026-04-10

3.21.2-canary.49a64cca 2026-04-10

3.21.1 2026-04-10

3.21.1-canary.e1930b80 2026-04-09

3.21.1-canary.295264b2 2026-04-09

3.21.0 2026-04-09

3.20.1-canary.d732f780 2026-04-09

3.20.1-canary.9fafd6f7 2026-04-09

3.20.1-canary.2bdc12a4 2026-04-09

3.20.0 2026-03-15

3.19.2-canary.f4ce16ab 2026-03-15

3.19.2-canary.c06afc25 2026-03-14

3.19.2-canary.97855a60 2026-03-15

3.19.2-canary.90a06776 2026-03-14

3.19.2-canary.7e57db62 2026-03-15

3.19.2-canary.5ac5563c 2026-03-15

3.19.1 2026-03-09

3.19.1-canary.18692157 2026-03-09

3.19.1-canary.91c5229d 2026-03-08

3.19.1-canary.7c2ae002 2026-03-08

3.19.1-canary.3123b4e6 2026-03-08

3.19.0 2026-03-05

3.18.3-canary.b57c671c 2026-03-03

3.18.3-canary.099beeae 2026-03-02

3.18.2 2026-02-26

3.18.2-canary.bde9aec8 2026-02-26

3.18.2-canary.b274e725 2026-02-26

3.18.2-canary.3f94950d 2026-02-26

3.18.2-canary.2ad5f0b2 2026-02-26

3.18.1 2026-02-25

3.18.1-canary.3f4bbca3 2026-02-25

3.18.0 2026-02-23

3.17.6-canary.1e612dc6 2026-02-23

3.17.5 2026-02-23

3.17.5-canary.c4efc90a 2026-02-20

3.17.5-canary.8aa20522 2026-02-21

3.17.5-canary.5f8ac971 2026-02-20

3.17.5-canary.0e06e02e 2026-02-21

3.17.4 2026-02-20

3.17.3 2026-02-19

3.17.2 2026-02-16

3.17.1 2026-02-13

3.17.0 2026-02-11

3.16.3 2026-02-03

3.16.3-canary.46c3f603 2026-01-30

3.16.2 2026-01-26

3.16.2-canary.2927949d 2026-01-26

3.16.2-canary.089a628c 2026-01-17

3.16.1 2026-01-16

3.16.1-canary.3e00cd75 2026-01-15

3.16.0 2025-12-16

3.15.4-canary.a3944878 2025-12-16

3.15.3 2025-10-21

3.15.3-canary.6000eb2f 2025-10-14

3.15.2 2025-10-08

3.15.2-canary.fb9eae11 2025-10-03

3.15.1 2025-09-24

3.15.1-canary.53a9bc24 2025-09-24

3.15.1-canary.288d757b 2025-09-18

3.15.0 2025-09-16

3.14.6-canary.e72247f7 2025-09-09

3.14.5 2025-09-08

3.14.5-canary.c091f1ba 2025-09-08

3.14.4 2025-09-01

3.14.4-canary.cc34a833 2025-08-27

3.14.4-canary.9642a1e5 2025-08-27

3.14.4-canary.64ea4cdd 2025-09-01

3.14.3 2025-07-29

3.14.3-canary.ce2ad75a 2025-07-26

3.14.2 2025-07-10

3.14.2-canary.1ee48cce 2025-07-10

3.14.1 2025-04-27

3.14.1-canary.9d097f8d 2025-04-27

3.14.1-canary.0617813d 2025-04-26

3.14.0 2025-03-20

3.13.1-canary.2d5050d5 2025-03-11

3.13.0 2025-03-06

3.12.1-canary.fe3a11c4 2025-03-05

3.12.1-canary.e70160b7 2025-03-05

3.12.1-canary.be22202e 2025-03-05

3.12.1-canary.a79253d1 2025-03-06

3.12.1-canary.603c2463 2025-02-05

3.12.1-canary.51da6534 2025-02-05

3.12.0 2024-12-23

3.11.6-canary.9a386018 2024-12-04

3.11.5 2024-11-28

3.11.5-canary.d5a76e6c 2024-11-13

3.11.5-canary.cdc9415c 2024-11-15

3.11.5-canary.bded4980 2024-11-14

3.11.4 2024-11-05

3.11.4-canary.401db79b 2024-10-31

3.11.3 2024-09-15

3.11.3-canary.81be01b1 2024-09-14

3.11.2 2024-09-11

3.11.1 2024-09-10

3.11.0 2024-07-27

3.10.3 2024-07-15

3.10.2 2024-07-01

3.10.1 2024-06-13

3.10.0 2024-05-30

3.9.9 2024-05-29

3.9.8 2024-05-26

3.9.7 2024-04-21

3.9.6 2024-04-18

3.9.5 2024-04-17

3.9.4 2024-04-09

3.9.3 2024-03-26

3.9.2 2024-02-26

3.9.1 2024-01-29

3.9.0 2024-01-26

3.8.0 2024-01-23

3.7.1 2024-01-17

3.7.0 2024-01-07

3.6.5 2023-11-22

3.6.4 2023-11-21

3.6.3 2023-11-03

3.6.2 2023-10-15

3.6.1 2023-09-09

3.6.0 2023-08-04

3.5.2 2023-07-17

3.5.1 2023-07-10

3.5.0 2023-07-06

3.4.5 2023-07-05

3.4.4 2023-07-04

3.4.3 2023-06-30

3.4.2 2023-06-26

3.4.1 2023-06-24

3.4.0 2023-06-19

3.3.5 2023-06-13

3.3.4 2023-06-11

3.3.3 2023-05-27

3.3.2 2023-05-23

3.3.1 2023-05-11

3.3.0 2023-05-06

3.2.4 2023-04-25

3.2.3 2023-04-16

3.2.2 2023-04-16

3.2.1 2023-04-13

3.2.0 2023-03-03

3.1.2 2023-02-08

3.1.1 2023-02-07

3.1.0 2023-01-30

3.0.1 2023-01-13

3.0.0-rc.1 2022-11-06

3.0.0 2023-01-12

2.3.3-rc.0 2021-11-05

2.3.3 2021-11-14

2.3.2 2021-10-16

2.3.1 2021-10-15

2.3.0 2021-08-05

2.2.5 2020-09-21

2.2.4 2020-09-21

2.2.3 2020-09-21

2.2.2 2020-09-19

2.2.1 2020-09-18

2.2.0 2020-09-18

2.1.0 2019-12-24

2.0.2 2019-12-05

2.0.1 2019-11-20

2.0.0 2019-10-27

2.0.0-alpha1 2019-10-13

1.7.0 2019-08-28

1.6.6 2020-03-02

1.6.5 2019-02-08

1.6.4 2018-11-08

1.6.3 2018-11-06

1.6.2 2018-11-04

1.6.1 2018-08-01

1.6.0 2018-08-01

1.5.3 2018-03-19

1.5.2 2018-02-05

1.5.1 2017-11-19

1.5.0 2017-11-13

1.4.2 2017-08-27

1.4.1 2017-08-15

1.4.0 2017-08-04

1.3.6 2017-07-12

1.3.5 2017-06-14

1.3.4 2017-06-12

1.3.3 2017-06-08

1.3.2 2017-05-31

1.3.1 2017-05-31

1.3.0 2017-05-29

1.2.0 2017-02-16

1.1.2 2016-11-15

1.1.1 2016-10-05

1.1.0 2016-09-20

1.0.0-rc.13 2016-09-14

1.0.0-rc.12 2016-09-06

1.0.0-rc.11 2016-08-14

1.0.0-rc.10 2016-08-09

1.0.0-rc.9 2016-08-01

1.0.0-rc.8 2016-07-22

1.0.0-rc.7 2016-07-03

1.0.0-rc.6 2016-06-29

1.0.0-rc.5 2016-06-16

1.0.0-rc.4 2016-06-13

1.0.0-rc.3 2016-06-08

1.0.0-rc.2 2016-06-02

1.0.0-rc.1 2016-02-17

1.0.0 2016-09-16

0.15.8 2015-06-22

0.15.7 2015-05-13

0.15.6 2015-05-04

0.15.5 2015-04-08

0.15.4 2015-03-11

0.15.3 2015-02-27

0.15.2 2015-02-24

0.15.1 2015-02-18

0.15.0 2015-01-09

0.14.1 2014-12-09

0.14.0 2014-11-26

0.13.0 2014-11-12

0.12.5 2014-07-30

0.12.4 2014-07-17

0.12.3 2014-06-12

0.12.2 2014-06-11

0.12.1 2014-04-30

0.12.0 2014-04-29

0.11.8 2014-04-24

0.11.7 2014-03-20

0.11.6 2014-02-20

0.11.5 2014-02-20

0.11.4 2014-02-08

0.11.3 2014-01-29

0.11.2 2014-01-13

0.11.1 2014-01-10

0.11.0 2014-01-07

0.10.7 2014-01-07

0.10.6 2013-11-06

0.10.5 2013-09-17

0.10.4 2013-09-15

0.10.3 2013-08-30

0.10.2 2013-08-29

0.10.1 2013-08-28

0.9.2 2013-08-23

0.9.1 2013-08-23

0.8.21 2013-08-14

0.8.20 2013-08-05

0.8.19 2013-07-29

0.8.18 2013-07-16

0.8.17 2013-07-15

0.8.16 2013-07-15

0.8.15 2013-07-14

0.8.14 2013-07-13

0.8.13 2013-07-13

0.8.12 2013-06-03

0.8.11 2013-06-02

0.8.10 2013-06-01

0.8.9 2013-05-28

0.8.8 2013-05-28

0.8.7 2013-05-23

0.8.6 2013-05-22

0.8.5 2013-05-21

0.8.4 2013-05-19

0.8.3 2013-05-17

0.8.2 2013-05-15

0.8.1 2013-05-13

0.8.0 2013-05-13

0.7.0 2013-05-08

0.6.0 2013-05-01

0.5.0 2013-04-30

0.4.0 2013-04-28

0.3.0 2013-04-27

0.2.4 2013-04-26

0.2.3 2013-04-26

0.2.2 2013-04-23

0.2.1 2013-04-23

0.2.0 2013-04-22

0.1.2 2013-04-21

0.1.1 2013-04-21

0.1.0 2013-04-20

0.0.3 2013-04-18

0.0.2 2013-04-18

0.0.1 2013-04-17