mariadb

MariaDB MySQL-compatible database with Galera clustering. Use for MySQL-compatible database needs.

7 stars

byG1Joshi

View on GitHub Installation ↓

Best use case

mariadb is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

MariaDB MySQL-compatible database with Galera clustering. Use for MySQL-compatible database needs.

Teams using mariadb should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

You only need a quick one-off answer and do not need a reusable workflow.
You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/mariadb/SKILL.md --create-dirs "https://raw.githubusercontent.com/G1Joshi/Agent-Skills/main/skills/databases/mariadb/SKILL.md"

Manual Installation

Download SKILL.md from GitHub
Place it in .claude/skills/mariadb/SKILL.md inside your project
Restart your AI agent — it will auto-discover the skill

How mariadb Compares

Feature / Agent	mariadb	Standard Approach
Platform Support	Not specified	Limited / Varies
Context Awareness	High	Baseline
Installation Complexity	Unknown	N/A

Frequently Asked Questions

What does this skill do?

MariaDB MySQL-compatible database with Galera clustering. Use for MySQL-compatible database needs.

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

SKILL.md Source

# 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.

```sql
-- 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).

## References

- [MariaDB Knowledge Base](https://mariadb.com/kb/en/)