MySQL ReadOnly MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | No | MySQL server address | localhost |
| MYSQL_PORT | No | MySQL server port | 3306 |
| MYSQL_USER | Yes | MySQL username | |
| MYSQL_SSL_CA | No | SSL CA certificate path | |
| MYSQL_SSL_KEY | No | SSL client key path | |
| MYSQL_DATABASE | No | Default database to connect to | |
| MYSQL_PASSWORD | Yes | MySQL password | |
| MYSQL_SSL_CERT | No | SSL client certificate path | |
| MYSQL_SSL_REJECT_UNAUTHORIZED | No | Whether to reject unauthorized SSL certificates | true |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| mysql_queryA | Execute a read-only SQL query on MySQL database |
| mysql_list_tablesB | List all tables in the database |
| mysql_describe_tableC | Get table structure and column information |
| mysql_list_databasesB | List all available databases |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 4 tools
Each tool has a clearly distinct purpose with no overlap: describe_table focuses on schema details, list_databases and list_tables handle enumeration at different levels, and query provides general read-only execution. An agent can easily distinguish between these four functions.
All tools follow a consistent 'mysql_verb_noun' pattern with snake_case throughout (e.g., mysql_describe_table, mysql_list_databases). This predictable naming scheme makes the tool set easy to navigate and understand.
Four tools is a reasonable number for a read-only MySQL server, covering core operations like listing databases/tables, describing structure, and executing queries. It's slightly lean but well-scoped, with no obvious bloat or missing essentials for the stated purpose.
For a read-only MySQL server, the tool set covers key operations: enumeration (databases, tables), schema inspection (describe_table), and data retrieval (query). Minor gaps might include tools for viewing indexes or constraints, but agents can work around this with queries, making it largely complete.