MySQL Database Access MCP Server

by MCP-Mirror

Data/Databases MySQL Database Access Read-Only SQL

This MCP server provides read-only access to MySQL databases. It allows listing databases, tables, describing schemas, and executing read-only SQL queries.

View on GitHub

Last updated: N/A

What is MySQL Database Access MCP Server?

A Micro Control Panel (MCP) server that provides read-only access to MySQL databases, enabling listing databases, tables, describing schemas, and executing read-only SQL queries.

How to use MySQL Database Access MCP Server?

Install the server using npm or by building from source. Configure environment variables for MySQL connection details. Add the server configuration to your MCP settings file. Then, use the available tools (list_databases, list_tables, describe_table, execute_query) with appropriate parameters.

Key features of MySQL Database Access MCP Server

Read-only access (SELECT, SHOW, DESCRIBE, EXPLAIN)
Query validation (prevents SQL injection)
Query timeout (prevents long-running queries)
Row limit (prevents excessive data return)

Use cases of MySQL Database Access MCP Server

Retrieving database schema information
Listing available databases and tables
Executing read-only queries for data analysis
Integrating with other MCP tools for data retrieval

FAQ from MySQL Database Access MCP Server

What SQL statements are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed.

How is SQL injection prevented?

The server performs query validation to prevent SQL injection and blocks any data modification attempts.

What happens if a query takes too long?

The server has a query timeout to prevent long-running queries from consuming resources.

Is there a limit to the amount of data returned?

Yes, the server has a row limit to prevent excessive data return.

What environment variables are required?

MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and optionally MYSQL_DATABASE.