mariadb-core-defaults-and-sql-modes

What problem does it solve?

This Skill provides comprehensive guidance on MariaDB defaults and SQL modes, helping users understand and manage their database configurations for optimal performance and compatibility.

Core Features & Use Cases

• Default Configuration Insights: Understand how implicit server defaults shift between MariaDB versions and their impact on query behavior.
• SQL Mode Management: Learn how to set and manage SQL modes for specific scenarios like migrations and upgrades.
• charset and collation Settings: Get information on default charset and collation changes, and how to handle them for compatibility.
• Performance Optimization: Identify default variables that affect performance and learn how to adjust them for better database efficiency.
• Use Case: Use this Skill to avoid common pitfalls during MariaDB upgrades, such as incorrect character set settings causing data corruption, or misconfigured sql_mode leading to silent data truncation.

Quick Start

Use the mariadb-core-defaults-and-sql-modes skill to get a summary of your current MariaDB configuration, including sql_mode, character set, and collation settings.