Name: Mariadb Best Practices
Author: jcastillotx

Comprehensive coding standards for MariaDB database development, optimized for AI agents and LLMs.

Overview

This skill provides 22 rules organized across 8 categories:

Query Optimization (query-) - MariaDB optimizer hints, statistics [CRITICAL]
Security (security-) - Authentication plugins, encryption at rest [CRITICAL]
Schema Design (schema-) - System versioning, sequences [HIGH]
Storage Engines (engine-) - InnoDB, Aria, ColumnStore selection [HIGH]
Galera Cluster (galera-) - Multi-master, SST methods [MEDIUM-HIGH]
Performance Tuning (perf-) - Thread pool, buffer pool [MEDIUM]
JSON Features (json-) - JSON functions, dynamic columns [MEDIUM]
Compatibility (compat-) - MySQL compatibility, migration [LOW-MEDIUM]

Usage

Reference this skill when:

Comprehensive coding standards for MariaDB database development, optimized for AI agents and LLMs.

This skill provides 22 rules organized across 8 categories:

Query Optimization (query-) - MariaDB optimizer hints, statistics [CRITICAL]
Security (security-) - Authentication plugins, encryption at rest [CRITICAL]
Schema Design (schema-) - System versioning, sequences [HIGH]
Storage Engines (engine-) - InnoDB, Aria, ColumnStore selection [HIGH]
Galera Cluster (galera-) - Multi-master, SST methods [MEDIUM-HIGH]
Performance Tuning (perf-) - Thread pool, buffer pool [MEDIUM]
JSON Features (json-) - JSON functions, dynamic columns [MEDIUM]
Compatibility (compat-) - MySQL compatibility, migration [LOW-MEDIUM]

Reference this skill when: