M

MySQL Database Explorer

Provides secure, read-only access to MySQL databases for exploring schemas and executing SELECT quer...

122 views
2 installs
Updated Sep 9, 2025
Not audited
Provides secure, read-only access to MySQL databases for exploring schemas and executing SELECT queries with built-in safeguards against SQL injection, query timeouts, and row limits.
  1. Obtain your MySQL database connection details

    • You will need the following information for your MySQL database:
      • Host (the server address where MySQL is running, e.g., localhost or an IP/domain)
      • Port (the MySQL server port, usually 3306 unless changed)
      • Username (a valid MySQL user with read access)
      • Password (the password for the MySQL user)
      • Default Database (the name of the default database to connect to — optional, but helpful)
  2. (Optional) Prepare advanced connection settings

    • If needed, also have values for:
      • MYSQL_CONNECTION_LIMIT (number of allowed connections, default: 10)
      • MYSQL_QUEUE_LIMIT (request queue length, default: 0/unlimited)
      • MYSQL_CONNECT_TIMEOUT (timeout in ms, default: 10000)
      • MYSQL_IDLE_TIMEOUT (idle time in ms, default: 60000)
      • MYSQL_MAX_IDLE (max idle connections, default: 10)
    • These are rarely needed unless instructed by your database administrator.
  3. Go to the FastMCP connection interface

    • Click the "Install Now" button for the MySQL connector/server.
  4. Fill in the required ENV values in the FastMCP interface

    • Enter the details you collected for each of the following fields:
      • MYSQL_HOST
      • MYSQL_PORT
      • MYSQL_USER
      • MYSQL_PASSWORD (recommended, but can be left empty for unsecured/public setups or if using other authentication)
      • MYSQL_DATABASE (can be left blank if not using a default database)
    • If using any additional/advanced parameters (from Step 2), add them as well.
  5. Save and connect

    • Confirm and save your configuration in FastMCP.
  6. Test the connection

    • Use the MCP tools (such as list_databases or list_tables) through FastMCP to verify access and correct setup.

Note: If you do not know your database credentials, contact your MySQL database administrator. The MCP server is read-only and will not modify your data.

Quick Start

View on GitHub

More for Database

View All →

Similar MCP Servers

Report Issue

Thank you! Your issue report has been submitted successfully.