mcp-server-mariadb

By MCP-Mirror GitHub

Mirror of

mcp-server mariadb

Overview

what is mcp-server-mariadb?

The mcp-server-mariadb is an implementation of an MCP server designed to retrieve data from a MariaDB database.

how to use mcp-server-mariadb?

To use the mcp-server-mariadb, you need to configure it with the appropriate database connection settings in the Claude Desktop configuration file and ensure that MariaDB is installed with the necessary dependencies.

key features of mcp-server-mariadb?

Exposes schema list in the database.
Allows execution of read-only operations against MariaDB.

use cases of mcp-server-mariadb?

Retrieving data from a MariaDB database for applications.
Integrating with Claude Desktop for enhanced data management.
Facilitating database queries in a structured manner.

FAQ from mcp-server-mariadb?

What is required to run mcp-server-mariadb?

You need to have MariaDB installed along with the MariaDB Connector/C.

How do I resolve installation errors?

Follow the installation instructions provided in the documentation to resolve any dependency issues.

Is there a license for mcp-server-mariadb?

Yes, it is licensed under the MIT license.

Content

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.

execute brew install mariadb-connector-c
execute echo 'export PATH="/opt/homebrew/opt/mariadb-connector-c/bin:$PATH"' >> ~/.bashrc
set environment variable export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_config
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

Add this configuration to enable published servers


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

Add this configuration to enable development/unpublished servers

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