Mariadb
A comprehensive skill catalog for AI agents
npx -y skills add G1Joshi/Agent-Skills --skill mariadbAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 10 stars10 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
MariaDB MySQL-compatible database with Galera clustering. Use for MySQL-compatible database needs.
SKILL.md
1.6 KB, 368 tokens by cl100k_base, as published. Nobody here has run it
MariaDB
MariaDB is a fork of MySQL, created by the original developers of MySQL. It is guaranteed to stay open source. It lists features that MySQL doesn't have, or adds them faster.
When to Use
- MySQL Compatible: Drop-in replacement for MySQL.
- Open Source: If you prefer GPL over Oracle's dual license.
- Advanced Features: Flashback, Sequences, Dynamic Columns (NoSQL), Spider Engine (Sharding).
Quick Start
Same as MySQL usually.
-- System-Versioned Tables (Time Travel)
CREATE TABLE t (
x INT,
PERIOD FOR SYSTEM_TIME (ts_start, ts_end)
) WITH SYSTEM VERSIONING;
-- Query history
SELECT * FROM t FOR SYSTEM_TIME AS OF TIMESTAMP '2024-01-01 00:00:00';
Core Concepts
Storage Engines
MariaDB supports many more engines out of the box than MySQL:
- Aria: Crash-safe replacement for MyISAM.
- ColumnStore: For analytics (Columnar storage).
- Spider: For database sharding.
Galera Cluster
Synchronous multi-master replication. Available in MariaDB by default.
Best Practices (2025)
Do:
- Use Vector Search (2025): MariaDB Enterprise 2025 adds native vector search for AI RAG apps.
- Use Thread Pooling: Enabled by default in MariaDB (unlike safe MySQL), handling high connection counts efficiently.
Don't:
- Don't assume 100% MySQL parity: While mostly compatible, new JSON functions and optimizers diverge. Check the specific version docs (11.x).