MariaDB / MySQL Database Access MCP Server

@rjsalgado

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

rjsalgado

MariaDB / MySQL Database Access MCP Server について

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

MariaDB / MySQL Database Access MCP Server の設定

以下の設定を使って、このサーバーを 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": ""
      }
    }
  }
}

MariaDB / MySQL Database Access MCP Server のツール

List all accessible databases on the MariaDB server

List all tables in a specified database

Show the schema for a specific table

Execute a SQL query

概要

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

よくある質問

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.

「データベース」の他のコンテンツ

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Elasticsearch MCP Server

elastic

685

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.