MCP.so
Sign In

mariadb-mcp-server

@abel9851

About mariadb-mcp-server

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

Basic information

Category

Databases

License

MIT license

Runtime

python

Transports

stdio

Publisher

abel9851

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

1

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.

Comments

More Databases MCP servers