Integrations
Allows AI models to interact with MySQL databases through a standardized interface, enabling operations like connecting to a database, executing queries, listing tables, and describing table structures.
@f4ww4z/mcp-mysql-server
A Model Context Protocol server that provides MySQL database operations. This server enables AI models to interact with MySQL databases through a standardized interface.
Installation
Installing via Smithery
To install MySQL Server for Claude Desktop automatically via Smithery:
Manual Installation
Configuration
The server requires the following environment variables to be set in your MCP settings configuration file:
recommended use
Available Tools
1. connect_db
Establish connection to MySQL database using provided credentials.
2. query
Execute SELECT queries with optional prepared statement parameters.
3. execute
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.
4. list_tables
List all tables in the connected database.
5. describe_table
Get the structure of a specific table.
Features
- Secure connection handling with automatic cleanup
- Prepared statement support for query parameters
- Comprehensive error handling and validation
- TypeScript support
- Automatic connection management
Security
- Uses prepared statements to prevent SQL injection
- Supports secure password handling through environment variables
- Validates queries before execution
- Automatically closes connections when done
Error Handling
The server provides detailed error messages for common issues:
- Connection failures
- Invalid queries
- Missing parameters
- Database errors
Contributing
Contributions are welcome! Please feel free to submit a Pull Request to https://github.com/f4ww4z/mcp-mysql-server
License
MIT
You must be authenticated.
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
This server enables AI models to interact with MySQL databases through a standardized interface.
Related MCP Servers
- AsecurityFlicenseAqualityEnables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management.Last updated -716JavaScript
- -securityAlicense-qualityA server that enables AI models to interact with MySQL databases through a Model Control Protocol, providing tools for table creation, schema inspection, query execution, and data retrieval.Last updated -20PythonMIT License
- -security-license-qualityA Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.Last updated -MIT License
- -security-license-qualityA Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.Last updated -JavaScript
Appeared in Searches
- Connecting to PostgreSQL database, retrieving table schema, and executing SQL queries
- Information about PostgreSQL database management system
- An overview or information about MySQL
- Running MySQL Queries Through a MySQL Socket
- Building a Real-Time Automated DNS and AI Load Balancing System with AWS, HAProxy, and Python