What is this MySQL tool designed for?

This MySQL tool provides a secure Model Context Protocol (MCP) server specifically designed for executing read-only queries. It ensures safe and controlled access to your MySQL databases, preventing unauthorized modifications.

How does this MySQL server enhance database security?

It rigorously enforces read-only transactions, restricts allowed SQL statements to SELECT, SHOW, DESCRIBE, and EXPLAIN, rejects multi-statement queries (semicolons) to prevent attacks, and supports configurable blocking of specific write or lock clauses.

Can I customize the security rules for MySQL queries?

Yes, you can configure `deny_substrings` in the server's settings. This allows you to block specific SQL patterns or clauses, providing an extra layer of custom security to prevent edge-case vulnerabilities.

What types of MySQL queries are permitted by default?

By default, the server strictly allows only `SELECT`, `SHOW`, `DESCRIBE`, and `EXPLAIN` statements. This ensures that no data modification or administrative commands can be executed through the MCP server.

Does this tool help manage database resources?

Absolutely. It offers configurable row limits for query results and query timeouts, allowing you to effectively prevent resource exhaustion and maintain database performance by controlling query scope and duration.

MySQL

Name: MySQL
Author: webus

bywebus

•

数据库管理

API 开发

安全与测试

Provides a secure Model Context Protocol server for executing read-only MySQL queries.

MySQL

bywebus

•

数据库管理

API 开发

安全与测试

Provides a secure Model Context Protocol server for executing read-only MySQL queries.

MySQL MCP is a lightweight Model Context Protocol server designed to provide a safe and controlled interface for accessing MySQL data. It strictly enforces read-only operations, allowing only `SELECT`, `SHOW`, `DESCRIBE`, and `EXPLAIN` statements by default. With features like read-only transactions, semicolon rejection, and configurable query deny substrings, it ensures that your database remains protected from unintended write or lock operations, making it ideal for safely exposing MySQL query capabilities.

主要功能

01Enforces read-only transactions for all MySQL queries

02Restricts allowed SQL statements to SELECT, SHOW, DESCRIBE, and EXPLAIN

03Rejects queries containing semicolons to prevent multi-statement attacks

04Supports configurable deny substrings to block specific write or lock clauses

05Offers configurable row limits and query timeouts for resource management

060 GitHub stars

使用案例

01Exposing a secure, read-only API layer for MySQL data

02Integrating MySQL data access into applications that utilize the Model Context Protocol

03Safely providing limited MySQL query capabilities to external or untrusted services

MySQL

Neon

Snowflake Integration

Tinybird

Diagram Maker & Visualizer

GH Issues Auto-Fixer

Discord Integration

MySQL

主要功能

使用案例

Neon

Snowflake Integration

Tinybird

Diagram Maker & Visualizer

GH Issues Auto-Fixer

Discord Integration

主要功能

使用案例