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

Related MCP server: mysqldb-mcp-server

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

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