mariadb-mcp-server

@abel9851

Repository

About mariadb-mcp-server

An mcp server that provides read-only access to MariaDB.

#mcp #mariadb #model-context-protocol #mcp-server

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

Execute read-only operations against MariDB

Overview

What is mariadb-mcp-server?

mariadb-mcp-server is an MCP (Model Context Protocol) server that enables AI assistants like Claude to execute read-only SQL queries against a MariaDB database and retrieve its schema. It is intended for developers who want to query MariaDB through MCP-compatible clients.

How to use mariadb-mcp-server?

Install MariaDB Connector/C (on macOS using Homebrew), set the required environment variables (MARIADB_HOST, MARIADB_USER, MARIADB_PASSWORD, MARIADB_DATABASE, MARIADB_PORT), and configure your MCP client (e.g., Claude Desktop) with the uv command pointing to the server source. Once configured, use the query_database tool to run read-only queries.

Key features of mariadb-mcp-server

Exposes database schema list as resources
Provides a read-only query_database tool
Uses MariaDB Connector/C for database connectivity
Licensed under the MIT License

Use cases of mariadb-mcp-server

Query MariaDB from an AI assistant without write access
Explore and document database schemas through natural language
Integrate MariaDB data into MCP-powered workflows
Run ad-hoc read-only reports via Claude Desktop

FAQ from mariadb-mcp-server

How do I resolve the "mariadb_config not found" error?

Install MariaDB Connector/C (e.g., brew install mariadb-connector-c), add its bin directory to PATH, set the MARIADB_CONFIG environment variable, and retry the dependency installation.

What environment variables are required?

MARIADB_HOST, MARIADB_USER, MARIADB_PASSWORD, MARIADB_DATABASE, and MARIADB_PORT (default 3306). These are set in the client configuration’s env block.

What operations can the server perform?

It only supports read-only operations via the query_database tool. No write or DDL commands are allowed.

Where is the Claude Desktop configuration file located?

On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json. On Windows: %APPDATA%\Claude\claude_desktop_config.json.

What license does mariadb-mcp-server use?

It is licensed under the MIT License.

Frequently asked questions

How do I resolve the "mariadb_config not found" error?

Install MariaDB Connector/C (e.g., `brew install mariadb-connector-c`), add its `bin` directory to `PATH`, set the `MARIADB_CONFIG` environment variable, and retry the dependency installation.

What environment variables are required?

`MARIADB_HOST`, `MARIADB_USER`, `MARIADB_PASSWORD`, `MARIADB_DATABASE`, and `MARIADB_PORT` (default 3306). These are set in the client configuration’s `env` block.