What is MariaDB Database Integration

mcp-server-mariadb is an implementation that allows retrieval of data from a MariaDB database. It provides a way for applications to interact with MariaDB servers in a structured manner.

Use cases

This server can be used in various scenarios where data retrieval from a MariaDB database is needed, such as web applications, data analysis tools, or backend services that require database interactions.

How to use

To use the mcp-server-mariadb, you need to configure the connection details in your Claude Desktop configuration file, specifying the appropriate command and arguments for your execution environment, either for published or development servers.

Key features

The server exposes a schema list from the database and includes a tool for executing read-only operations against MariaDB, making it easier for developers to retrieve and manipulate relational data.

Where to use

This server is suitable for environments using MariaDB, whether developing local applications or deploying services that require database connectivity. It can be utilized in both independent setups and as part of larger systems.

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/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 licensed under the MIT license. please see the LICENSE file in the repository.