Mysql
MCP server giving AI assistants schema inspection and SQL access to MySQL and MariaDB
- Pricing
- Open source
- Platforms
- CLI, Linux, self-hosted
- Version
- 0.2.0
- Listing updated
- today
Similar MCP servers
About Mysql
Mysql is an open-source MCP server for databases. It is available on CLI, Linux and self-hosted.
The README says this Rust server lets an MCP client such as Claude read table schemas and run SQL against MySQL or MariaDB over JSON-RPC on stdio. Queries run through a connection pool, and each query can name its own database, so a single server instance can reach several databases without relying on session state.
By default the server is read-only and accepts only SELECT statements. Insert, update and delete tools, along with other write operations, are enabled only when the server is started with the dangerous-queries flag. Table names are restricted to alphanumeric characters and underscores, and values are sent as prepared-statement parameters.
It suits developers and data teams who want an assistant to explore a MySQL or MariaDB schema and answer questions from live data, with write access kept off unless explicitly enabled.
Tools this server provides (5)
Taken from the project documentation; the running server may differ.
- mysql
- Retrieve schema information for a table or all tables.
- query
- Execute SQL queries, optionally against a named database.
- insert
- Insert a row into a table when write mode is enabled.
- update
- Update rows matching conditions when write mode is enabled.
- delete
- Delete rows matching conditions when write mode is enabled.
What it does
- Schema inspection
- Returns column types, nullability, defaults, keys, indexes and constraints for a named table or all tables.
- Read-only by default
- Only SELECT queries run unless the dangerous-queries flag is set at startup.
- Per-query database selection
- A database parameter on each query chooses the target schema without a persistent USE statement.
- Connection pooling
- Maintains a pool of up to five MySQL connections with automatic retry on transient failures.
- Optional write tools
- Insert, update and delete tools return last insert ID or affected row counts when write access is enabled.
- SSL/TLS support
- Supports standard MySQL SSL/TLS connections.
Good for
- Letting an AI assistant explore an unfamiliar database schema
- Answering ad-hoc questions from production or test data with read-only queries
- Querying several databases from one assistant session
- Prototyping data updates against a development database with write mode enabled
Pricing
Open source
Free and open source under Apache-2.0.
More servers for the same service
Mysql FAQ
Does it allow writes by default?
No. The README says the server runs in read-only mode and allows only SELECT queries unless --allow-dangerous-queries is enabled.
Which database versions are supported?
The README lists MySQL 5.7+ and MariaDB 10.2+.
What license does it use?
The README states Apache-2.0.
How is it installed?
The README describes building from source with Cargo or extracting a release package, then configuring the binary in an MCP client such as Claude Desktop.
Is Mysql free?
Yes. Mysql is open source, so you can use and self-host it for free.
What are the best alternatives to Mysql?
The closest alternatives to Mysql are AdoMcp, MCP Hydrolix, MCP Toolbox for Databases, Mongodb MCP Server and MCPDBWizard for MariaDB.
Where this comes from
- Description: written from the project's README and its MCP Registry entry.