mariadb-connector-nodejs-usage

What problem does it solve? Generated Node.js database code often carries habits from mysql/mysql2 or other DB-API drivers that break or misbehave with MariaDB Connector/Node.js, such as wrong placeholder styles, mishandled BigInt values, unbuffered memory blowups, and leaked pool connections. ## Core Features & Use Cases - API and placeholder rules: Covers the Promise API as default, the Callback API at require('mariadb/callback'), positional ? placeholders, and the namedPlaceholders option for :name syntax. - Type and result handling: Explains BigInt defaults for BIGINT and insertId, result-set shapes for SELECT versus INSERT/UPDATE/DELETE, and multi-result arrays from CALL. - Performance and resource patterns: Details batch() bulk inserts, queryStream() for large results, pool.getConnection() with release() in finally, explicit transactions, and prepared statement caching with execute() and prepare(). - Use Case: When reviewing a Node.js service that loops query() calls for bulk inserts and never releases pooled connections, apply this Skill to rewrite it with batch() and a try/finally release pattern. ## Quick Start Ask the AI to write or review Node.js code that connects to MariaDB with the mariadb npm package, such as a pooled transaction or a bulk insert.