MariaDB / MySQL Database Access MCP Server

Name: MariaDB / MySQL Database Access MCP Server
Author: rjsalgado

@rjsalgado

代码仓库

关于 MariaDB / MySQL Database Access MCP Server

An MCP server that provides access to MariaDB ou MySQL databases.

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

rjsalgado

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mariadb": {
      "command": "npx",
      "args": [
        "mariadb-mcp-server"
      ],
      "env": {
        "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": ""
      }
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MariaDB / MySQL Database Access MCP Server?

This MCP server provides read-only access to MariaDB or MySQL databases, enabling listing of databases, tables, table schemas, and execution of SQL queries through the Model Context Protocol. It is intended for developers and data analysts who need safe, structured database exploration via AI tools.

How to use MariaDB / MySQL Database Access MCP Server?

Install the server globally or locally via npm (npm install -g mariadb-mcp-server) or build from source. Configure environment variables such as MARIADB_HOST, MARIADB_USER, MARIADB_PASSWORD, etc. Add a server entry to your MCP settings JSON with the command npx mariadb-mcp-server and the required environment variables. The server exposes four tools: list_databases, list_tables, describe_table, and execute_query.

Key features of MariaDB / MySQL Database Access MCP Server

Read-only access by default (SELECT, SHOW, DESCRIBE, EXPLAIN)
SQL injection prevention through query validation
Query timeout to prevent resource exhaustion
Configurable row limit to cap returned data

Use cases of MariaDB / MySQL Database Access MCP Server

Enumerate databases and tables for data discovery
Inspect table schemas without direct SQL client access
Execute safe, read-only queries through AI assistants
Validate data structure during development or analysis

FAQ from MariaDB / MySQL Database Access MCP Server

What security features does the server have?

The server enforces read-only access by default, validates queries to prevent SQL injection, applies a configurable query timeout (default 10,000 ms), and limits rows returned (default 1000).

Which environment variables are required?

You must set MARIADB_HOST, MARIADB_USER, and MARIADB_PASSWORD. MARIADB_PORT defaults to 3306, and MARIADB_DATABASE is optional. Security variables like MARIADB_ALLOW_INSERT should be set to false for read-only mode.

How do I install the server?

Install via npm globally or locally: npm install -g mariadb-mcp-server. Alternatively, clone the repository and run npm install && npm run build to build from source.

Can I modify data (INSERT, UPDATE, DELETE) through this server?

No. The server is designed for read-only access. Even if you set the environment variables MARIADB_ALLOW_INSERT, MARIADB_ALLOW_UPDATE, or MARIADB_ALLOW_DELETE to true, the README instructs setting them to false and includes query validation that blocks data modification.

What tools does the server provide?

It provides list_databases, list_tables (optional database), describe_table (requires table name), and execute_query (requires query, optional database). All tools are read-only.