M

MySQL Database

Enables direct SQL query execution and database connections to MySQL databases through a simple inte...

84 views
3 installs
Updated Sep 14, 2025
Not audited
Enables direct SQL query execution and database connections to MySQL databases through a simple interface that returns results in JSON format.
  1. Prepare Your MySQL Database Credentials

    • Ensure you have access to your MySQL server and note the following values:
      • MYSQL_HOST: The server address (for most setups, this will be localhost).
      • MYSQL_USER: The username for accessing the database (commonly root or another user you've created).
      • MYSQL_PASSWORD: The password for the MySQL user.
      • MYSQL_DATABASE (optional): The name of the MySQL database you want to connect to (leave empty if not needed).
      • MYSQL_READONLY (optional): Set to true or 1 for read-only mode; otherwise leave at default.
  2. Open the FastMCP Connection Interface

    • Go to the interface where you configure connections with ENVs, accessible via your “Install Now” button.
  3. Add Environment Variable Values

    • In the FastMCP connection interface prompted by “Install Now”:
      1. Enter your MySQL server address as MYSQL_HOST.
      2. Enter your MySQL username as MYSQL_USER.
      3. Enter your MySQL user’s password as MYSQL_PASSWORD.
      4. (Optional) Enter your database name as MYSQL_DATABASE.
      5. (Optional) Set MYSQL_READONLY to true or 1 if you want read-only access.
  4. Save and Complete

    • Save your configuration in the FastMCP interface.
    • The integration is now configured to connect to your MySQL database using the provided credentials.

⚠️ Always keep your database credentials secure, and limit user permissions as appropriate for your use case.

You have now set the required ENV values.

Quick Start

View on GitHub

More for Database

View All →

Similar MCP Servers

Report Issue

Thank you! Your issue report has been submitted successfully.