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`.

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.