Connects to MySQL databases, providing tools for schema introspection and secure SQL query execution via an MCP server.
Sponsored
This Python-based MCP server leverages FastMCP to establish a robust connection to MySQL databases. It offers a comprehensive set of functionalities for interacting with your database, including listing databases and tables, describing table schemas, and executing SQL queries. Designed with security in mind, it operates in a read-only mode by default, with explicit configuration options to enable write operations (INSERT, UPDATE, DELETE) under strict conditions, such as requiring a WHERE clause for UPDATE/DELETE statements. The server supports flexible configuration through environment variables or .env files, including advanced TLS/SSL settings for secure connections, making it ideal for integrating MySQL capabilities into development workflows and AI assistant tools like Cursor.
Key Features
01List all available databases
02List tables within a specified database
030 GitHub stars
04Describe table schema (columns, types, keys)
05Execute validated SQL queries (read-only by default, configurable for writes)
06Supports secure MySQL connections with TLS/SSL, certificate validation, and mTLS
Use Cases
01Integrating MySQL database access and management into AI coding assistants (e.g., Cursor)
02Automating database schema exploration and introspection tasks
03Providing a secure, controlled interface for executing SQL queries on MySQL databases
