MariaDB / MySQL Database Access MCP Server

@hjsad1994

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

hjsad1994

关于 MariaDB / MySQL Database Access MCP Server

暂无概览

#mariadb #mysql #database-access

MariaDB / MySQL Database Access MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MariaDB / MySQL Database Access MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

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

概览

What is MariaDB / MySQL Database Access MCP Server?

This MCP server provides read-only access to MariaDB and MySQL databases, allowing users to list databases, list tables, describe table schemas, and execute SQL queries. It is designed for developers and administrators who need to query databases securely through the Model Context Protocol.

How to use MariaDB / MySQL Database Access MCP Server?

Install via npm (npm install -g mariadb-mcp-server) or build from source. Configure required environment variables (host, port, user, password, etc.) and add the server configuration to your MCP settings file. Use tools such as list_databases, list_tables, describe_table, and execute_query to interact with the database.

Key features of MariaDB / MySQL Database Access MCP Server

Read-only access by default (SELECT, SHOW, DESCRIBE, EXPLAIN)
Query validation to prevent SQL injection and data modification
Configurable query timeout and row limit
Supports both MariaDB and MySQL databases
Can connect via TCP or Unix socket

Use cases of MariaDB / MySQL Database Access MCP Server

Explore available databases and tables in a MariaDB/MySQL instance
Retrieve table schemas to understand database structure
Execute read-only SQL queries for reporting or data inspection
Integrate database querying into MCP-enabled applications

常见问题

What operations are allowed by default?

Only read-only operations: SELECT, SHOW, DESCRIBE, and EXPLAIN. INSERT, UPDATE, and DELETE are blocked unless explicitly enabled via environment variables.

How do I configure the database connection?

Set environment variables such as MARIADB_HOST, MARIADB_PORT, MARIADB_USER, MARIADB_PASSWORD, and optionally MARIADB_DATABASE. Refer to the installation section for full details.

Can I modify data with this server?

By default, no. Data modification is prevented. You can enable it by setting MARIADB_ALLOW_INSERT, MARIADB_ALLOW_UPDATE, or MARIADB_ALLOW_DELETE to `true`, but this is strongly discouraged.

What are the default timeout and row limit?

The default query timeout is 10000 ms (10 seconds) and the default row limit is 1000 rows. These can be changed via MARIADB_TIMEOUT_MS and MARIADB_ROW_LIMIT.

How do I install this server?

Install globally via npm: `npm install -g mariadb-mcp-server`. Alternatively, clone the repository, run `npm install` and `npm run build`, then point your MCP settings to the built `dist/index.js`.

数据库分类下的更多 MCP 服务器

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.