mariadb-mcp-server

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.