> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference.md).

# MCP Tool Reference

Reference for the db, msm, sandbox, util, and migrator tools of the mariadb-shell MCP server.

The `mariadb-shell` MCP server provides 43 tools in five groups. A sixth, optional group is available when the migration tooling is installed.

| Group                                                                                                            | Tools | What they do                                                                                                                                 |
| ---------------------------------------------------------------------------------------------------------------- | ----- | -------------------------------------------------------------------------------------------------------------------------------------------- |
| [`db.*`](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/db-tools.md)             | 8     | List connections and schemas, describe objects, and run SQL.                                                                                 |
| [`msm.*`](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/msm-tools.md)           | 12    | Versioned schema projects, releases, and deployments with MariaDB Schema Management.                                                         |
| [`sandbox.*`](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/sandbox-tools.md)   | 8     | List deployable server versions; deploy, start, stop, and delete local instances.                                                            |
| [`util.*`](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/util-tools.md)         | 12    | Dump, load, export, import, and copy data between servers, as background tasks. Requires MariaDB Shell 26.10.2 or later.                     |
| [`sql.*`](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/sql-tools.md)           | 3     | Check, outline, and format SQL text with the MariaDB grammar, without a database. Requires MariaDB Shell 26.10.3 or later and `mariadb-lsp`. |
| [`migrator.*`](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/migrator-tools.md) | 4     | MySQL-to-MariaDB migration. Optional, and not counted in the 43.                                                                             |

A server in multi-tenant mode (the `--multiTenant` option of `mcp setup`, available in MariaDB Shell 26.10.0 and later) serves only the `db.*` group. In MariaDB Shell 26.10.0 and 26.10.1, it also serves the `msm.*` group. The other groups run local server instances and long-running jobs, or read and write files, on the machine that hosts the MCP server, and aren't offered to tenants. The server that the plugins' launcher scripts start is single-tenant and serves every group.

## Conventions

* Arguments are named as the tools take them.
* `connection_id` always comes from a prior `db.connect` call.
* Any argument that takes a file path is limited to the allowed-paths list. See [Security Model](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/security-model.md#paths).

{% content-ref url="/pages/a2D9eLrpqTeV236dF4Sy" %}
[db Tools](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/db-tools.md)
{% endcontent-ref %}

{% content-ref url="/pages/gzzD0LmjGxwXW9FSiWtM" %}
[msm Tools](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/msm-tools.md)
{% endcontent-ref %}

{% content-ref url="/pages/r58svVA5leGLTrRl9pH5" %}
[sandbox Tools](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/sandbox-tools.md)
{% endcontent-ref %}

{% content-ref url="/pages/Vbd5MguQfw3J7gU5316p" %}
[util Tools](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/util-tools.md)
{% endcontent-ref %}

{% content-ref url="/pages/axPCxmYmGfa3R8li9y2W" %}
[sql Tools](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/sql-tools.md)
{% endcontent-ref %}

{% content-ref url="/pages/shlACk4TuRSxfeGjeGjg" %}
[migrator Tools](https://mariadb.com/docs/tools/community/mariadb-ai-plugins/mcp-tool-reference/migrator-tools.md)
{% endcontent-ref %}

<sub>*This page is licensed: GPLv2*</sub>

{% @marketo/form formId="4316" %}
