Mariadb MCP Server

🚀 mcp-server-mariadb

An MCP server implementation for retrieving data from MariaDB

🚀 Quick Start

This mcp-server-mariadb is designed to retrieve data from MariaDB. Below are the details about its features, dependencies, usage instructions, and license.

✨ Features

Resources

• Lists of forms in the database are publicly available.

Tools

• query_database
  • Performs read - only operations on MariaDB.

📦 Installation

Installing MariaDB

• Mac
  • When installing MariaDB, you may encounter the following error:

    OSError: mariadb_config not found.
    
        This error usually indicates that the pre - installed MariaDB Connector/C was not found.
        If MariaDB Connector/C is not installed, please refer to the installation instructions.
        If MariaDB Connector/C is installed, you can 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.
    

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

💻 Usage Examples

Usage Instructions (in conjunction with Claude Desktop)

Configuration File Path

• 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}"
            ]
        }
    }
}

{
    "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"
            }
        }
    }
}

📄 License

This MCP server is released under the MIT License. Please refer to the LICENSE file in the repository.