Query MySQL read-only via MCP, list tables, and inspect schemas.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mysql-query" yet — see the docs or source repo.
Use mysql-query to run a read-only query: SELECT id, customer_name, total_amount FROM orders ORDER BY created_at DESC LIMIT 10;
Returns the query results for the 10 most recent orders.
Use mysql-query to list all tables in the current database and sort them by name.
Returns a list of table names in the current database.
Use mysql-query to inspect the schema of the users table, including column names, types, and nullability.
Returns the schema details of the users table.
Developers can run read-only SELECT queries through MCP to verify data without modifying the database. They can also list tables first and then inspect the target schema.
Data analysts can list tables and inspect schemas before writing queries to confirm which fields are available. They can then run read-only queries to retrieve the needed data.
DevOps engineers can inspect table data and schemas in read-only mode during production troubleshooting, reducing the risk of accidental changes. It fits environments where querying is allowed but writes are not.
The provided information says it is a read-only MySQL query service that supports SELECT queries, listing tables, and viewing schemas. No write operations are described.
No. The description explicitly states that it is read-only, so it should be used only for non-mutating access.
The available material only states that it provides read-only MySQL querying via the MCP protocol and does not include installation or configuration details. See the source repository for specifics.
Safely inspect local MySQL schemas and query data through a read-only MCP interface.
Safely run read-only MySQL queries and inspect databases, tables, and schemas.
Read multiple MySQL databases, inspect schemas, and run safe SELECT queries.
Connect to MySQL for safe read-only queries and schema exploration.
Explore SQL schemas and run safe read-only SELECT queries.
Securely query MySQL with natural language, schemas, tables, and read-only SQL.