MySQL Query

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

314 views

0 installs

Updated Nov 22, 2025

Not audited

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.

How to Install MySQL Query

Install MySQL Query MCP server with one click through FastMCP. Choose your preferred AI development tool below:

Claude Desktop

Click "Claude Desktop" in Quick Start

Cursor IDE

Click "Cursor IDE" in Quick Start

VS Code

Click "VS Code" in Quick Start

Alternatives to MySQL Query

Looking for similar MCP servers? Browse other servers in the same categories on FastMCP, or check out the similar servers listed above.

Database MCP servers →

Compare side by side

MySQL Query vs MySQL Database Explorer MySQL Query vs MySQL MySQL Query vs DB Bridge MySQL Query vs Read MySQL MySQL Query vs MySQL Database

Quick Start

View on GitHub

More for Database

View All →

Supabase MCP Server

Official

Remote

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

1.9k

1-Click Ready

DBHub (Universal Database Gateway)

Official

Provides a universal database gateway for connecting to PostgreSQL, MySQL, SQLite, and DuckDB, enabling table browsing, schema inspection, and read-only SQL queries with built-in safety checks

Database Developer Tools

912

1-Click Ready

MySQL Database

Enables direct SQL query execution and database connections to MySQL databases through a simple interface that returns results in JSON format.

Database

834

Svelte

Official

Remote

Official Svelte documentation access and code analysis server that provides up-to-date reference material, playground link generation, and intelligent autofixer capabilities for detecting common patterns, anti-patterns, and migration opportunities in Svelte 5 and SvelteKit projects.

Database Developer Tools

823

1-Click Ready

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

495

Odoo ERP

Connects to Odoo ERP systems via XML-RPC to enable searching, reading, creating, updating, and deleting business records with smart field optimization and comprehensive access controls for business process automation and data analysis workflows.

Productivity Database

789

AWS Athena

Integrates with AWS SDK to execute SQL queries against Athena databases, enabling large-scale data analysis and business intelligence for AWS data lakes.

Database Cloud Platforms

707

PostgreSQL

Provides a bridge to PostgreSQL databases for executing SQL queries, managing tables, and inspecting schemas with support for prepared statements and multiple parameter styles

Database

525

Neo4j

Integrates with Neo4j graph databases to enable natural language querying, node creation, and complex graph operations for knowledge exploration and data relationship modeling.

Database Analytics and Data

720

InfluxDB

Connects to InfluxDB time-series databases for querying measurements, writing data, and managing buckets through a bridge that exposes database functionality via tools and resources.

Database Analytics and Data

594

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

318

MySQL

Provides direct interface to MySQL databases for executing SQL queries and retrieving relational data with configurable connection parameters.

Database

313

DB Bridge

Provides secure SQL query execution across MySQL, PostgreSQL, and SQLite databases with granular permission controls, transaction-based operations, and configurable write access for production environments.

Database Cloud Platforms

205

Read MySQL

Secure read-only MySQL database access to execute queries and analyze data patterns.

Database Monitoring

533

MySQL Database

Interact with MySQL databases to execute queries and manage connections.

Database

322

MySQL Database

Enables direct SQL query execution and database connections to MySQL databases through a simple interface that returns results in JSON format.

Database

834

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

310

yooztech_mcp_mysql

Official

Enables secure read-only access to MySQL databases with automatic database inference from project context. Provides safe querying capabilities with built-in security features like parameterized queries, whitelisting, and rate limiting.

Database

SQL Database Bridge

Provides a bridge to SQL databases (MSSQL, MySQL, PostgreSQL) for executing queries, exploring schemas, monitoring performance, and generating reports with features like connection pooling and transaction management.

Database Monitoring

340

MySQL

Connects to MySQL databases including AWS RDS instances with tools for query execution, schema exploration, table statistics, and database introspection using connection pooling and SSL support.

Database Analytics and Data

227

Report Issue

Operating System

Client

Client Name

Issue

Please describe the issue

Thank you! Your issue report has been submitted successfully.

MySQL Query

How to Install MySQL Query

Alternatives to MySQL Query

Compare side by side

Quick Start

Claude Desktop

Cursor IDE

VS Code

Claude Code

Gemini

Codex

Manual

Choose Connection Type for

Remote Connection by FastMCP

Local Connection

Authentication Required

Run MCP servers withoutlocal setup or downtime

Configuration for

Environment Variables

HTTP Headers

started!

Configuration

Installation Failed

More for Database

Supabase MCP Server

DBHub (Universal Database Gateway)

MySQL Database

Svelte

PostgreSQL Multi-Schema

Odoo ERP

AWS Athena

PostgreSQL

Neo4j

InfluxDB

Similar MCP Servers

MySQL Database Explorer

MySQL

DB Bridge

Read MySQL

MySQL Database

MySQL Database

MySQL

yooztech_mcp_mysql

SQL Database Bridge

MySQL

Report Issue

Stay ahead of the MCP ecosystem

Run MCP servers without
local setup or downtime