MariaDB MCP Server

Name: MariaDB MCP Server
Author: rjsalgado

rjsalgado

Get started Repository

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

Setup

Choose your client, copy the config, then fill in any required environment variables.

Add to Cursor Add to 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>"
      }
    }
  }
}

Environment variables

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

Replace the placeholders with your own credentials and keep them out of version control.

Setup

Environment variables

Related