dpflucas_mysql-mcp-server
0
The MySQL Database Access MCP Server is a server designed to provide secure, read-only access to MySQL databases. It features read-only SQL query execution and database information listing while incorporating security measures like query validation and row limitations. It is especially useful in environments where data integrity must be maintained during database interactions.
MySQL Database Access MCP Server
This MCP server provides read-only access to MySQL databases with functionalities such as:
- Listing available databases
- Listing tables in a database
- Describing table schemas
- Executing read-only SQL queries
Security Features
- Read-only access: Only allows SELECT, SHOW, DESCRIBE, and EXPLAIN statements
- Query validation: Prevents SQL injection and blocks data modification attempts
- Query timeout: Prevents resource-consuming queries
- Row limit: Prevents excessive data return
Available Tools
- list_databases: Lists all accessible databases
- list_tables: Lists tables in a specified database
- describe_table: Shows schema for a specific table
- execute_query: Executes a read-only SQL query
Testing
The server includes test scripts for verifying functionality with your MySQL setup.