Read MySQL
Secure read-only MySQL database access to execute queries and analyze data patterns.
Prepare Your MySQL Connection Information
Gather the following details of your MySQL server:- Host (e.g., 127.0.0.1 or the remote server IP)
- Port (default: 3306)
- Username (e.g., root)
- Password
- Database name
Tip: If you're running MySQL locally with a Unix socket, also get the socket path (e.g., /tmp/mysql.sock)
Click the "Install Now" Button
In your FastMCP interface, use the "Install Now" button to begin adding the MCP server for MySQL.Fill in Environment Values in the FastMCP Connection Interface
Enter the following required environment values:MYSQL_HOST(e.g., 127.0.0.1)MYSQL_PORT(e.g., 3306)MYSQL_USER(e.g., root)MYSQL_PASS(your MySQL password)MYSQL_DB(your database name, or leave empty for multi-DB mode)
For Unix Socket: Use
MYSQL_SOCKET_PATHinstead ofMYSQL_HOSTandMYSQL_PORT.Review and (Optionally) Customize Additional Environment Values
You can set additional values for connection pooling, security, logging, and permissions. For example:MYSQL_POOL_SIZE(default: 10)MYSQL_QUERY_TIMEOUT(default: 30000)ALLOW_INSERT_OPERATION,ALLOW_UPDATE_OPERATION,ALLOW_DELETE_OPERATION(default: false; set to true only if needed for write access)MYSQL_SSL(set to true if your MySQL uses SSL connections)
(Optional) Enabling Write Operations
If you want Claude or other agents to be able to insert, update, or delete data, set the relevant operation flags to "true":ALLOW_INSERT_OPERATION=trueALLOW_UPDATE_OPERATION=trueALLOW_DELETE_OPERATION=true
Warning: Only enable these if you trust the agent with write access.
(Optional) Advanced: Multi-DB or Schema Permissions
- To enable your agent to access multiple databases, leave
MYSQL_DBempty. - For schema or database-specific permissions, set variables like
SCHEMA_INSERT_PERMISSIONS=dev:true,prod:false.
- To enable your agent to access multiple databases, leave
Verify Connection
After saving the configuration, use the testing tools in FastMCP to ensure the MySQL connection is successful.Save and Complete the Setup
Once the test passes, save your MCP server configuration.
Notes:
- For remote/production servers, ensure your MySQL user has the correct privileges and, if needed, that the MySQL server is accessible from the network where FastMCP runs.
- Consult your organization’s security policies before enabling write/delete operations.
You are now ready to use the MySQL MCP server with FastMCP!
Quick Start
Choose Connection Type for
Authentication Required
Please sign in to use FastMCP hosted connections
Configure Environment Variables for
Please provide values for the following environment variables:
started!
The MCP server should open in . If it doesn't open automatically, please check that you have the application installed.
Copy and run this command in your terminal:
Make sure Gemini CLI is installed:
Visit Gemini CLI documentation for installation instructions.
Make sure Claude Code is installed:
Visit Claude Code documentation for installation instructions.
Installation Steps:
Configuration
Installation Failed
More for Database
View All →Supabase MCP Server
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.
ClickHouse
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.
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.
More for Monitoring
View All →Dual-Cycle Reasoner
Provides dual-cycle metacognitive reasoning framework that detects when autonomous agents get stuck in repetitive behaviors through statistical anomaly detection and semantic analysis, then automatically diagnoses failure causes and generates recovery strategies using case-based learning.