Agent-Skills.md

Agent Skills: MariaDB Best Practices

MariaDB database development standards. Triggers when working with MariaDB databases, Galera cluster, or MariaDB-specific features.

UncategorizedID: jcastillotx/vibe-skeleton-app/mariadb-best-practices

Repository

jcastillotx/vibe-skeleton-app
jcastillotx

Install this agent skill to your local

pnpm dlx add-skill https://github.com/jcastillotx/vibe-skeleton-app/tree/HEAD/setup/skills/mariadb-best-practices

Skill Files

Browse the full folder contents for mariadb-best-practices.

Download Skill

Loading file tree…

setup/skills/mariadb-best-practices/SKILL.md

Skill Metadata

Name
mariadb-best-practices
Description
MariaDB database development standards. Triggers when working with MariaDB databases, Galera cluster, or MariaDB-specific features.

MariaDB Best Practices

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

Overview

This skill provides 22 rules organized across 8 categories:

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

Usage

Reference this skill when:

  • Working with MariaDB-specific features
  • Setting up Galera cluster
  • Using system versioned tables
  • Optimizing MariaDB performance
  • Migrating from MySQL to MariaDB

Build

pnpm build    # Compile rules to AGENTS.md
pnpm validate # Validate rule files