MariaDB

What is mcp-server-mariadb?

mcp-server-mariadb is an MCP (Model Context Protocol) server implementation designed to provide read-only access to MariaDB databases. It allows other applications and services, particularly those integrated with Claude Desktop, to securely query and retrieve data from a MariaDB instance.

How to use mcp-server-mariadb?

To use mcp-server-mariadb, you need to install MariaDB Connector/C and configure it within your Claude Desktop environment. The README provides detailed instructions for installation, including troubleshooting common OSError: mariadb_config not found by installing mariadb-connector-c via brew and setting environment variables. For Claude Desktop integration, you need to add specific JSON configurations to your claude_desktop_config.json file, either for published or development servers, specifying the command, arguments, and environment variables for connecting to your MariaDB instance.

Key Features of mcp-server-mariadb

• Read-Only Access: Securely execute read-only operations against MariaDB databases.
• Schema List Exposure: Expose the schema list within the database as a resource.
• query_database Tool: Provides a dedicated tool for executing database queries.
• MCP Integration: Seamlessly integrates with the Model Context Protocol for controlled data access.
• Configurable Access Controls: (Implied from MCP Info) Allows for configurable access controls, enhancing security.

Use Cases of mcp-server-mariadb

• Data Retrieval for AI Models: AI applications, especially those using Claude Desktop, can use this server to fetch necessary data from MariaDB for analysis or to inform their responses.
• Building Data-Driven Applications: Developers can leverage this server to build applications that require secure, read-only access to MariaDB data without exposing full database credentials.
• Internal Tooling: Create internal tools that need to query specific datasets from MariaDB for reporting or operational purposes.

FAQ from mcp-server-mariadb

Q: What should I do if I encounter OSError: mariadb_config not found during installation? A: This error indicates that MariaDB Connector/C is not found. You can resolve this by installing mariadb-connector-c (e.g., brew install mariadb-connector-c on macOS) and then setting the MARIADB_CONFIG environment variable to the location of the mariadb_config utility. The README provides specific commands for this.

Q: How do I configure mcp-server-mariadb with Claude Desktop? A: You need to modify your claude_desktop_config.json file. The README provides two examples: one for published servers and another for development/unpublished servers. You will need to specify the command to run the server, arguments for database connection details (host, port, user, password, database), and potentially environment variables.

Q: Is mcp-server-mariadb read-only? A: Yes, mcp-server-mariadb is specifically designed to provide read-only access to MariaDB, ensuring data integrity and security.

mcp-server-mariadb

An MCP server implementation for retrieving data from mariadb

Features

Resources

Expose schema list in database

Tools

• query_database
  • Execute read-only operations against MariDB

dependency

install mariadb

• mac
  • when install mariadb, maybe raise os error below. you can resolve by installing mariadb-connector-c.

OSError: mariadb_config not found.

      This error typically indicates that MariaDB Connector/C, a dependency which
      must be preinstalled, is not found.
      If MariaDB Connector/C is not installed, see installation instructions
      If MariaDB Connector/C is installed, either set the environment variable
      MARIADB_CONFIG or edit the configuration file 'site.cfg' to set the
       'mariadb_config' option to the file location of the mariadb_config utility.

1. execute brew install mariadb-connector-c
2. execute echo 'export PATH="/opt/homebrew/opt/mariadb-connector-c/bin:$PATH"' >> ~/.bashrc
3. set environment variable export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_config
4. execute uv add mariadb again.

Usage with Claude Desktop

Configuration File

Paths to Claude Desktop config file:

• MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json

{
    "mcpServers": {
        "mcp_server_mariadb": {
            "command": "/PATH/TO/uvx"
            "args": [
                "mcp-server-mariadb",
                "--host",
                "${DB_HOST}",
                "--port",
                "${DB_PORT}",
                "--user",
                "${DB_USER}",
                "--password",
                "${DB_PASSWORD}",
                "--database",
                "${DB_NAME}"
            ]
        }
    }
}

Note: Replace these placeholders with actual paths:

• /PATH/TO/uvx: Full path to uvx executable

{
    "mcpServers": {
        "mcp_server_mariadb": {
            "command": "/PATH/TO/uv",
            "args": [
                "--directory",
                "/YOUR/SOURCE/PATH/mcp-server-mariadb/src/mcp_server_mariadb",
                "run",
                "server.py"
            ],
            "env": {
                "MARIADB_HOST": "127.0.0.1",
                "MARIADB_USER": "USER",
                "MARIADB_PASSWORD": "PASSWORD",
                "MARIADB_DATABASE": "DATABASE",
                "MARIADB_PORT": "3306"
            }
        }
    }
}

Note: Replace these placeholders with actual paths:

• /PATH/TO/uv: Full path to UV executable
• /YOUR/SOURCE/PATH/mcp-server-mariadb/src/mcp_server_mariadb: Path to server source code

License

This mcp server is licensed under the MIT license. please see the LICENSE file in the repository.