Integrates high-performance MySQL database operations using the mysql2 driver with support for connection pooling, transactions, and typed queries.
This skill enables Claude to implement secure, production-grade MySQL and MariaDB interactions using the mysql2/promise driver. It provides standardized patterns for connection pool management, binary prepared statements via execute() to prevent SQL injection, and complex transaction handling with dedicated connections. It is specifically designed for Node.js developers who need to implement robust data persistence, memory-efficient streaming for large datasets, and strict TypeScript integration for database schemas.
Key Features
01Atomic transaction patterns with manual commit and rollback controls
02Connection pool management with automated lifecycle and error handling
03TypeScript support using RowDataPacket and ResultSetHeader generics
045 GitHub stars
05Secure prepared statements using the binary protocol to prevent SQL injection
06Memory-efficient streaming for processing large result sets
Use Cases
01Implementing financial or inventory systems requiring strict ACID transactions