mcp-server-mariadb

By abel9851 GitHub

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

mcp mariadb

Overview

what is MCP MariaDB Server?

MCP MariaDB Server is a server application designed to work with MariaDB, providing a robust environment for database management.

how to use MCP MariaDB Server?

To use MCP MariaDB Server, you need to install MariaDB and configure the server settings as per the provided instructions. Follow the installation steps and set up the server using the configuration file.

key features of MCP MariaDB Server?

Easy installation and setup for MariaDB.
Configuration options for server management.
Compatibility with various operating systems.

use cases of MCP MariaDB Server?

Managing databases for web applications.
Running data analytics and reporting.
Supporting backend services for software applications.

FAQ from MCP MariaDB Server?

What is required to install MCP MariaDB Server?

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

Can I run MCP MariaDB Server on Windows?

Yes, MCP MariaDB Server can be configured to run on Windows, but ensure all dependencies are met.

Where can I find the installation instructions?

Installation instructions are provided in the project documentation on GitHub.

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