MySQL Query

Provides a secure, read-only bridge to MySQL databases, enabling natural language querying across mu...

10 views

0 installs

Updated Aug 5, 2025

Provides a secure, read-only bridge to MySQL databases, enabling natural language querying across multiple environments with strict validation and comprehensive error handling.

Gather Your MySQL Database Credentials
- For each environment (local, development, staging, production) you want to connect, you will need the following:
  - Host (e.g., localhost, dev.example.com)
  - User (database username for the environment)
  - Password (database user password)
  - Database Name (the database you want to query)
  - (Optional) Port (default is 3306)
  - (Optional) SSL and certificate-related settings, if your DB requires secure connections
Access Your Database Provider or Server for Credentials
- If you're self-hosting MySQL: Log in to your server or hosting control panel to retrieve or set up usernames and passwords.
- If using a managed service (e.g. AWS RDS, Azure Database, PlanetScale, Vercel, DigitalOcean):
  - Log in to the respective service dashboard.
  - Go to the database instance and find the "Connection Details" or similar section to get host, user, password, and database name.
  - For most providers, you can create new users and passwords if needed.
Ensure User Has Read-Only Permissions (Recommended)
- For security, use a user account limited to SELECT, SHOW, and DESCRIBE privileges.
- In MySQL, you can create a read-only user with a command similar to:
```
CREATE USER 'readonly_user'@'%' IDENTIFIED BY 'your_password';
GRANT SELECT, SHOW VIEW ON your_database.* TO 'readonly_user'@'%';
FLUSH PRIVILEGES;
```
- Replace 'readonly_user', 'your_password', and your_database appropriately.
Copy Values Into FastMCP Connection Interface
- Open your FastMCP environment.
- Click the “Install Now” (or equivalent) button for MySQL Query MCP.
- In the FastMCP connection interface, fill in the required values for each environment you wish to enable:
  - LOCAL_DB_HOST, LOCAL_DB_USER, LOCAL_DB_PASS, LOCAL_DB_NAME, LOCAL_DB_PORT (default 3306)
  - DEVELOPMENT_DB_HOST, DEVELOPMENT_DB_USER, etc. (if using dev)
  - STAGING_DB_HOST, STAGING_DB_USER, etc. (if using staging)
  - PRODUCTION_DB_HOST, PRODUCTION_DB_USER, etc. (if using production)
- Optional: Set DEBUG to true if you need extra logging.
- Optional: Set MCP_MYSQL_SSL to true if you’re connecting to a database that requires SSL.
- Optional: Set MCP_MYSQL_REJECT_UNAUTHORIZED to false if you encounter certificate errors (not recommended for production).
Save and Test the Connection
- Save the configuration.
- Use the query tool or environment info features from your AI assistant to confirm connectivity and access.

Notes:

Do not abbreviate environment values (must use LOCAL_, DEVELOPMENT_, etc.).
For sensitive/production environments, manage credentials securely and rotate if compromised.
Only read-only operations are supported.

Quick Start

View on GitHub

More for Database

View All →

Supabase MCP Server

Official

Connect Supabase projects directly with AI assistants using the Model Context Protocol (MCP). This server standardizes communication between Large Language Models and Supabase, enabling AI to manage tables, query data, and interact with project features like edge functions, storage, and branching. Customize access with read-only or project-scoped modes and select specific tool groups to fit your needs. Integrated tools cover account management, documentation search, database operations, debugging, and more, empowering AI to assist with development, monitoring, and deployment tasks in your Supabase environment efficiently and securely.

Database

Postgres MCP Pro

Boost your Postgres database performance with Postgres MCP Pro, an AI-driven MCP server offering advanced index tuning, detailed explain plans, and comprehensive health checks. It combines proven optimization algorithms with schema intelligence for safe, context-aware SQL execution. Whether analyzing slow queries or recommending optimal indexes, Postgres MCP Pro empowers developers to improve efficiency and maintain database integrity. Designed for both development and production, it supports flexible transport options and robust access controls, making database management smarter, safer, and easier. Experience deterministic performance insights alongside AI assistance to keep your Postgres running at its best.

Database

PostgreSQL Multi-Schema

Provides read-only access to PostgreSQL databases with enhanced multi-schema support, enabling schema inspection, query execution, and isolation across multiple namespaces.

Database Analytics and Data

MySQL

Provides secure MySQL database access for LLMs, enabling read/write operations with transaction support and security features for AI-assisted data management tasks.

Database

Gralio

Official

Remote

Access 3+ million SaaS reviews, detailed pricing data, alternatives, ratings, funding information, growth metrics, user sentiment analysis, and functional feature data for over 30,000 software products.

Database Analytics and Data

1-Click Ready

MongoDB

Official

Provides a bridge between MongoDB databases and conversational interfaces, enabling comprehensive database operations, collection management, schema inspection, and Atlas cloud service interactions with authentication and telemetry support.

Database

Neon

Official

Remote

Manage Neon's serverless Postgres databases.

Database

1-Click Ready

MySQL Database Explorer

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.

Database

ClickHouse

Official

Unlock powerful analytics with the ClickHouse MCP Server—seamlessly run, explore, and manage SQL queries across ClickHouse clusters or with chDB’s embedded OLAP engine. This server offers easy database and table listing, safe query execution, and flexible access to data from files, URLs, or databases. Built-in health checks ensure reliability, while support for both ClickHouse and chDB enables robust data workflows for any project.

Database

1-Click Ready

Airtable

Provides read and write access to Airtable databases.

Productivity Database

Similar MCP Servers

MySQL Database Explorer

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.

Database

MySQL Database

Interact with MySQL databases to execute queries and manage connections.

Database

Install MySQL Query

Choose your preferred installation method:

Configuration

Connect MySQL Query via Remote URL

Choose your preferred IDE for remote connection:

MySQL Query

Quick Start

More for Database

Supabase MCP Server

Postgres MCP Pro

PostgreSQL Multi-Schema

MySQL

Gralio

MongoDB

Neon

MySQL Database Explorer

ClickHouse

Airtable

Similar MCP Servers

MySQL Database Explorer

MySQL Database

Install MySQL Query

Claude Desktop

Cursor IDE

VS Code

Claude Code

Manual Configuration

Required Environment Variables

Configuration

Connect MySQL Query via Remote URL

Claude and Claude Desktop

Cursor IDE

VS Code

Claude Code

ChatGPT Connector

Manual Remote Configuration

Remote Configuration