SkillsAdd

smithery/jcastillotx

mariadb-best-practices

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

Installation

$ npx skills add smithery/jcastillotx --skill mariadb-best-practices
View on skills.sh ↗ Website ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

azure-storage Same topic
microsoft/azure-skills

Azure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and D…

567.1K installs
azure-kusto Same topic
microsoft/azure-skills

Query and analyze data in Azure Data Explorer (Kusto/ADX) using KQL for log analytics, telemetr…

566.2K installs
supabase-postgres-best-practices Same topic
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-database-setup Same topic
prisma/skills

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, Mon…

269.8K installs
prisma-client-api Same topic
prisma/skills

Prisma Client API reference covering model queries, filters, operators, and client methods. Use…

269.3K installs
prisma-cli Same topic
prisma/skills

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, …

267K installs
More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 1,428 B
  • docs SUMMARY.md 161 B

History

  1. First recorded snapshot · 0 installs

SKILL.md

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