mariadb-syntax-sql-ddl

What problem does it solve?

This Skill provides guidance on best practices for MariaDB SQL DDL, helping users avoid common pitfalls and optimize their database schema changes.

Core Features & Use Cases

• DDL Best Practices: Offers best practices for creating, altering, and dropping tables, indexes, and sequences.
• Performance Optimization: Guides on optimizing schema changes for performance, such as using INPLACE or INSTANT algorithms.
• Safety and Reliability: Ensures safe and reliable schema changes, including atomic operations and blue-green deployments.
• Use Case: For a developer working on a large-scale MariaDB database, this Skill can help in efficiently managing schema changes, especially during migrations or performance tuning.

Quick Start

Use the mariadb-syntax-sql-ddl skill to add a new column to your table without locking the table for writes.