MariaDB MCP Server

Name: MariaDB MCP Server
Author: rjsalgado

rjsalgado

开始使用源码仓库

Gives agents access to MariaDB and MySQL databases: list databases, inspect table schemas and run SQL queries.

接入配置

选择客户端，复制配置，再按项目文档补齐环境变量。

一键添加到 Cursor 一键添加到 VS Code

claude mcp add mariadb-server-rjsalgado --env MARIADB_HOST='<MARIADB_HOST>' --env MARIADB_PORT='<MARIADB_PORT>' --env MARIADB_USER='<MARIADB_USER>' --env MARIADB_PASSWORD='<MARIADB_PASSWORD>' --env MARIADB_DATABASE='<MARIADB_DATABASE>' --env MARIADB_ALLOW_INSERT='<MARIADB_ALLOW_INSERT>' --env MARIADB_ALLOW_UPDATE='<MARIADB_ALLOW_UPDATE>' --env MARIADB_ALLOW_DELETE='<MARIADB_ALLOW_DELETE>' --env MARIADB_TIMEOUT_MS='<MARIADB_TIMEOUT_MS>' --env MARIADB_ROW_LIMIT='<MARIADB_ROW_LIMIT>' -- npx mariadb-mcp-server

~/.codex/config.toml

[mcp_servers.mariadb-server-rjsalgado]
command = "npx"
args = ["mariadb-mcp-server"]
env = { MARIADB_HOST = "<MARIADB_HOST>", MARIADB_PORT = "<MARIADB_PORT>", MARIADB_USER = "<MARIADB_USER>", MARIADB_PASSWORD = "<MARIADB_PASSWORD>", MARIADB_DATABASE = "<MARIADB_DATABASE>", MARIADB_ALLOW_INSERT = "<MARIADB_ALLOW_INSERT>", MARIADB_ALLOW_UPDATE = "<MARIADB_ALLOW_UPDATE>", MARIADB_ALLOW_DELETE = "<MARIADB_ALLOW_DELETE>", MARIADB_TIMEOUT_MS = "<MARIADB_TIMEOUT_MS>", MARIADB_ROW_LIMIT = "<MARIADB_ROW_LIMIT>" }

# codex mcp add mariadb-server-rjsalgado --env MARIADB_HOST='<MARIADB_HOST>' --env MARIADB_PORT='<MARIADB_PORT>' --env MARIADB_USER='<MARIADB_USER>' --env MARIADB_PASSWORD='<MARIADB_PASSWORD>' --env MARIADB_DATABASE='<MARIADB_DATABASE>' --env MARIADB_ALLOW_INSERT='<MARIADB_ALLOW_INSERT>' --env MARIADB_ALLOW_UPDATE='<MARIADB_ALLOW_UPDATE>' --env MARIADB_ALLOW_DELETE='<MARIADB_ALLOW_DELETE>' --env MARIADB_TIMEOUT_MS='<MARIADB_TIMEOUT_MS>' --env MARIADB_ROW_LIMIT='<MARIADB_ROW_LIMIT>' -- npx mariadb-mcp-server

~/.cursor/mcp.json

{
  "mcpServers": {
    "mariadb-server-rjsalgado": {
      "command": "npx",
      "args": [
        "mariadb-mcp-server"
      ],
      "env": {
        "MARIADB_HOST": "<MARIADB_HOST>",
        "MARIADB_PORT": "<MARIADB_PORT>",
        "MARIADB_USER": "<MARIADB_USER>",
        "MARIADB_PASSWORD": "<MARIADB_PASSWORD>",
        "MARIADB_DATABASE": "<MARIADB_DATABASE>",
        "MARIADB_ALLOW_INSERT": "<MARIADB_ALLOW_INSERT>",
        "MARIADB_ALLOW_UPDATE": "<MARIADB_ALLOW_UPDATE>",
        "MARIADB_ALLOW_DELETE": "<MARIADB_ALLOW_DELETE>",
        "MARIADB_TIMEOUT_MS": "<MARIADB_TIMEOUT_MS>",
        "MARIADB_ROW_LIMIT": "<MARIADB_ROW_LIMIT>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "mariadb-server-rjsalgado": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "mariadb-mcp-server"
      ],
      "env": {
        "MARIADB_HOST": "<MARIADB_HOST>",
        "MARIADB_PORT": "<MARIADB_PORT>",
        "MARIADB_USER": "<MARIADB_USER>",
        "MARIADB_PASSWORD": "<MARIADB_PASSWORD>",
        "MARIADB_DATABASE": "<MARIADB_DATABASE>",
        "MARIADB_ALLOW_INSERT": "<MARIADB_ALLOW_INSERT>",
        "MARIADB_ALLOW_UPDATE": "<MARIADB_ALLOW_UPDATE>",
        "MARIADB_ALLOW_DELETE": "<MARIADB_ALLOW_DELETE>",
        "MARIADB_TIMEOUT_MS": "<MARIADB_TIMEOUT_MS>",
        "MARIADB_ROW_LIMIT": "<MARIADB_ROW_LIMIT>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "mariadb-server-rjsalgado": {
      "command": "npx",
      "args": [
        "mariadb-mcp-server"
      ],
      "env": {
        "MARIADB_HOST": "<MARIADB_HOST>",
        "MARIADB_PORT": "<MARIADB_PORT>",
        "MARIADB_USER": "<MARIADB_USER>",
        "MARIADB_PASSWORD": "<MARIADB_PASSWORD>",
        "MARIADB_DATABASE": "<MARIADB_DATABASE>",
        "MARIADB_ALLOW_INSERT": "<MARIADB_ALLOW_INSERT>",
        "MARIADB_ALLOW_UPDATE": "<MARIADB_ALLOW_UPDATE>",
        "MARIADB_ALLOW_DELETE": "<MARIADB_ALLOW_DELETE>",
        "MARIADB_TIMEOUT_MS": "<MARIADB_TIMEOUT_MS>",
        "MARIADB_ROW_LIMIT": "<MARIADB_ROW_LIMIT>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "mariadb-server-rjsalgado": {
      "command": "npx",
      "args": [
        "mariadb-mcp-server"
      ],
      "env": {
        "MARIADB_HOST": "<MARIADB_HOST>",
        "MARIADB_PORT": "<MARIADB_PORT>",
        "MARIADB_USER": "<MARIADB_USER>",
        "MARIADB_PASSWORD": "<MARIADB_PASSWORD>",
        "MARIADB_DATABASE": "<MARIADB_DATABASE>",
        "MARIADB_ALLOW_INSERT": "<MARIADB_ALLOW_INSERT>",
        "MARIADB_ALLOW_UPDATE": "<MARIADB_ALLOW_UPDATE>",
        "MARIADB_ALLOW_DELETE": "<MARIADB_ALLOW_DELETE>",
        "MARIADB_TIMEOUT_MS": "<MARIADB_TIMEOUT_MS>",
        "MARIADB_ROW_LIMIT": "<MARIADB_ROW_LIMIT>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "mariadb-server-rjsalgado": {
      "command": "npx",
      "args": [
        "mariadb-mcp-server"
      ],
      "env": {
        "MARIADB_HOST": "<MARIADB_HOST>",
        "MARIADB_PORT": "<MARIADB_PORT>",
        "MARIADB_USER": "<MARIADB_USER>",
        "MARIADB_PASSWORD": "<MARIADB_PASSWORD>",
        "MARIADB_DATABASE": "<MARIADB_DATABASE>",
        "MARIADB_ALLOW_INSERT": "<MARIADB_ALLOW_INSERT>",
        "MARIADB_ALLOW_UPDATE": "<MARIADB_ALLOW_UPDATE>",
        "MARIADB_ALLOW_DELETE": "<MARIADB_ALLOW_DELETE>",
        "MARIADB_TIMEOUT_MS": "<MARIADB_TIMEOUT_MS>",
        "MARIADB_ROW_LIMIT": "<MARIADB_ROW_LIMIT>"
      }
    }
  }
}

需要的环境变量

MARIADB_HOST
MARIADB_PORT
MARIADB_USER
MARIADB_PASSWORD
MARIADB_DATABASE
MARIADB_ALLOW_INSERT
MARIADB_ALLOW_UPDATE
MARIADB_ALLOW_DELETE
MARIADB_TIMEOUT_MS
MARIADB_ROW_LIMIT

把占位值换成你自己的密钥；不要把密钥提交到代码仓库。

接入配置

需要的环境变量

相关推荐