$ loading_
Access MySQL in read-only mode via MCP for schema and data queries.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mysql-db-reader" yet — see the docs or source repo.
Using mysql-db-reader, list all databases in the current MySQL instance, then show the tables in the analytics database and the basic schema of each table.
A list of databases, the tables in analytics, and an overview of each table schema.
Use mysql-db-reader to query the number of orders and total sales from the orders table for the last 30 days, using only a SELECT statement and grouping by date.
A daily aggregated result set with order counts and sales totals, without modifying any data.
Using mysql-db-reader, run EXPLAIN for the following query and describe the likely scan scope: SELECT * FROM users WHERE email = '[email protected]';
The EXPLAIN output plus a brief explanation based on the execution plan.
Developers or DevOps engineers can inspect databases, tables, and schemas in a MySQL instance without changing data. It fits situations where safe metadata access is needed.
Data analysts can run SELECT queries to quickly inspect business data, perform simple aggregations, or validate metrics. The read-only design makes it suitable for analysis and verification tasks.
Before optimizing a query, users can run EXPLAIN to understand likely execution paths and scan behavior. This helps with performance investigation without writing to the database.
No. The description explicitly says it provides read-only MySQL access and supports listing databases, tables, schemas, plus running SELECT queries and EXPLAIN plans.
Based on the description, it supports listing databases, tables, and schemas, running SELECT queries, and viewing EXPLAIN plans. No write, update, or delete capability is mentioned.
No documentation excerpt is provided, so the installation steps, runtime requirements, and connection configuration are not confirmed here. Please check the source repository.
Safely inspect local MySQL schemas and query data through a read-only MCP interface.
Securely inspect schema and run read-only queries on one MySQL database.
Read multiple MySQL databases, inspect schemas, and run safe SELECT queries.
Safely run read-only MySQL queries and inspect databases, tables, and schemas.
Safely inspect MySQL schemas and run read-only queries.
Query and manage multiple databases with read-only access and schema inspection.