Skip to main content
Glama
abel9851

MariaDB MCP Server

by abel9851

mcp-服务器-mariadb

用于从 mariadb 检索数据的 MCP 服务器实现

特征

资源

在数据库中公开架构列表

工具

  • 查询数据库

    • 对 MariDB 执行只读操作

Related MCP server: Database Tools for Claude AI

依赖

安装 mariadb

  • 苹果

    • 安装 mariadb 时,可能会引发以下操作系统错误。您可以通过安装 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. 执行brew install mariadb-connector-c

  2. 执行echo 'export PATH="/opt/homebrew/opt/mariadb-connector-c/bin:$PATH"' >> ~/.bashrc

  3. 设置环境变量export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_config

  4. 再次执行uv add mariadb 。

与 Claude Desktop 一起使用

配置文件

Claude Desktop 配置文件的路径:

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

注意:请用实际路径替换这些占位符:

  • /PATH/TO/uvx :uvx 可执行文件的完整路径

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

注意:请用实际路径替换这些占位符:

  • /PATH/TO/uv :UV 可执行文件的完整路径

  • /YOUR/SOURCE/PATH/mcp-server-mariadb/src/mcp_server_mariadb :服务器源代码路径

执照

此 mcp 服务器根据 MIT 许可证获得许可。请参阅存储库中的 LICENSE 文件。

Related MCP Connectors

Related MCP Servers

  • A
    license
    B
    quality
    D
    maintenance
    MCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.
    1
    4 npm
    4
    MIT
  • A
    license
    A
    quality
    C
    maintenance
    MCP server for Claude that connects to MySQL, MariaDB, and SQLite databases. Query your databases using natural language.
    3
    MIT
  • A
    license
    Not graded
    quality
    D
    maintenance
    MCP server for MySQL/MariaDB/Aurora MySQL that enables executing SQL queries, explaining query plans, inspecting schema, checking health, and running diagnostic playbooks through Claude.
    Apache 2.0