What problem does it solve? Generated application code that talks to MariaDB through ODBC often contains subtle errors: wrong driver names, named parameter placeholders, incorrect assumptions about prepared statements, autocommit behavior, and TLS activation. This Skill encodes the MariaDB Connector/ODBC-specific behavior so code written or reviewed against it is correct the first time. ## Core Features & Use Cases - Connection string correctness: Covers the DSN-less keyword DRIVER={MariaDB ODBC 3.2 Driver} on Windows and registered driver names or .so paths on Linux/macOS, plus TLS keywords (SSLCA, SSLVERIFY, FORCETLS) that implicitly enable encryption. - API behavior traps: Documents positional ? parameter markers via SQLBindParameter, server-side prepared statements for SQLPrepare+SQLExecute versus client-side SQLExecDirect (unless EDSERVER is set), autocommit ON by default, and the legacy OPTION bitmask. - Use Case: When writing a pyodbc script that bulk-inserts rows into MariaDB, use this Skill to bind parameter arrays with SQL_ATTR_PARAMSET_SIZE, commit explicitly (pyodbc's autocommit defaults to False), and loop SQLMoreResults after stored procedure calls. ## Quick Start Ask the AI to write or review C/C++ or pyodbc code that connects to MariaDB via ODBC, for example: write a pyodbc script that inserts rows into a MariaDB table using bound parameters and explicit commits.
