Tutorials

Every tutorial is something you can run today, on a throwaway server, in under an hour. They build on each other in order, but each one states what it assumes so you can start anywhere.

Runnable on a sandbox No cloud account Nothing left behind

All tutorials

Filter by difficulty or by which part of the plugin it exercises. The tool.name chips on each card name the MCP tools it uses.

Difficulty
Area
Tutorial 1

Build a Notes App schema and deploy it on a sandbox

The complete round trip. The agent designs a MariaDB schema for a note-taking app using the bundled skills, deploys a throwaway MariaDB server, runs the schema on it, and reads the objects back to prove it worked.

Beginner 20 minsandbox.deploydb.connectdb.execute_sql_scriptdb.list_objects
First Steps, Step 1 · Schema Lifecycle, Step 1
Tutorial 2

Run SQL and SQL scripts

Ask the agent to run a statement, run a whole file, and read results back. Covers the one behaviour that causes most surprises — a script is not a transaction, so a failure halfway leaves the first half in place.

Beginner 15 mindb.list_connectionsdb.connectdb.execute_sqldb.execute_sql_scriptdb.close
First Steps, Step 2
Tutorial 3

Explore a database you did not design

Point the agent at an existing MariaDB server and have it map the place out — schemas, tables, views, routines, columns, indexes and foreign keys — and answer the questions about a schema that a pile of SHOW statements cannot.

Beginner 15 mindb.list_schemasdb.list_objectsdb.get_object_detailsdb.execute_sql
First Steps, Step 3 · Operate and Optimize, Step 2
Tutorial 4

Throwaway MariaDB servers on demand

Ask for a real MariaDB instance, use it, and throw it away — no Docker, no container runtime, no administrator rights. The safety net that lets an agent try a destructive change before it touches anything real.

Beginner 20 minsandbox.list_available_versionssandbox.deploysandbox.startsandbox.stopsandbox.killsandbox.deletesandbox.version
Operate and Optimize, Step 1
Tutorial 5

Diagnose a slow query with EXPLAIN

Give the agent a query and a real server, and have it read the plan instead of guessing at indexes. Covers EXPLAIN, ANALYZE, the optimizer trace, and testing a candidate index on a sandbox before it reaches production.

Intermediate 30 mindb.connectdb.execute_sqldb.get_object_detailssandbox.deploy
Operate and Optimize, Step 3
Tutorial 6

Version a schema with MSM: create, release, deploy

Turn the Notes App from a one-off create script into a versioned MariaDB Schema Management project — a schema you can ship version 2 of, to servers that are still running version 1.

Intermediate 60 minmsm.create_projectmsm.get_sql_content_from_sectionmsm.set_section_sql_contentmsm.prepare_releasemsm.generate_deployment_scriptmsm.deploy_schema
Schema Lifecycle, Step 2
Tutorial 7

Ship a schema upgrade: version 1.1.0 in place

Add notebooks and tags to the Notes App, fill the 1.0.0 → 1.1.0 update script, and upgrade a live install without dropping it. Includes the ordering mistake that silently produces a deployment script which cannot upgrade anything.

Advanced 45 minmsm.set_development_versionmsm.prepare_releasemsm.set_section_sql_contentmsm.generate_deployment_scriptmsm.deploy_schema
Schema Lifecycle, Step 3
Tutorial 8

Expose the Notes App over REST

Put a JSON API in front of the Notes App schema with the MariaDB REST Service DDL — configure the metadata, create a service and a REST schema, then add a data mapping view per table. All of it driven from the agent over MCP.

Intermediate 40 mindb.connectdb.execute_sqldb.execute_sql_scriptsandbox.deploy
Build an API, Step 1
Tutorial 9

Migrate a MySQL database to MariaDB

Drive the MySQL-to-MariaDB Migrator from the agent — choose a mode, ask for it in a prompt that carries everything the agent needs, plan it, run it, and verify the result. Rehearsed on two throwaway servers before it touches anything real.

Advanced 60 minmigrator.set_configmigrator.planmigrator.runmigrator.resumesandbox.deploy
Build an API, Step 2
Tutorial 10

Check a schema against two MariaDB versions at once

Deploy two sandboxes on different major releases, run the same create script on both, and diff what the servers actually did with it. The cheapest way to find out whether a schema is portable across the versions you have to support.

Intermediate 35 minsandbox.list_available_versionssandbox.deploydb.connectdb.execute_sql_scriptdb.get_object_detailssandbox.killsandbox.delete
Operate and Optimize, Step 4

Prefer a route through them?

The learning paths connect these tutorials into progressions, each aimed at one thing you might actually be trying to do.

View Learning Paths Browse the Skill Catalog