Learning Paths

Four routes through the tutorials. Pick the one that matches what you are trying to do rather than how experienced you are — the levels describe the material, not you.

First Steps with the MariaDB AI Plugins

From a fresh install to an agent that can create a schema, run it on a throwaway server and read the result back. Start here if you have never pointed an AI agent at a database before — every step is reversible and nothing touches a real server.

3 tutorials · ~1 hour · Beginner
  1. 1
  2. 2
    Beginner 15 min
  3. 3
Start the path →

The Schema Lifecycle with MSM

A schema is never finished. This path takes the Notes App from a one-off create script to a versioned MariaDB Schema Management project with releases, a filled migration script and an in-place upgrade of a live install — the workflow that keeps a schema deployable to servers running any earlier version.

3 tutorials · ~2.5 hours · Intermediate
  1. 1
  2. 2
  3. 3
Start the path →

Operate and Optimize

The day-to-day work after the schema exists: managing throwaway servers to test against, reading an existing database you did not design, getting the agent to diagnose a slow query with EXPLAIN instead of guessing at indexes, and checking a schema against two MariaDB releases at once.

4 tutorials · ~2.5 hours · Intermediate
  1. 1
  2. 2
  3. 3
  4. 4
Start the path →

Build an API, or Move off MySQL

The two largest things the plugins automate end to end. Put REST endpoints in front of the Notes App schema with the MariaDB REST Service DDL, then drive a full MySQL-to-MariaDB migration with the migrator tooling.

2 tutorials · ~2 hours · Advanced
  1. 1
    Intermediate 40 min
  2. 2
Start the path →

Not sure which one?

Three questions that usually settle it.

"I just installed this and want to see it work."

Take First Steps. Three short tutorials, one throwaway server, and by the end you will know which half of the plugin does what.

Go to First Steps

"My schema has to survive being deployed twice."

Take The Schema Lifecycle. It is the difference between a create script and something you can ship version 2 of to servers still running version 1.

Go to Schema Lifecycle

"Something is already broken and I need to know why."

Take Operate and Optimize. Reading an unfamiliar schema, rehearsing changes on a throwaway server, and getting a real answer out of EXPLAIN rather than a guess about indexes.

Go to Operate and Optimize

"I need an API, or I need to get off MySQL."

Take Build an API, or Move off MySQL. The two largest things the plugins automate end to end, and the two with the most MariaDB-specific detail to get wrong.

Go to Build and Move