MCP MySQL Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
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 |
|---|---|
| connect_dbB | Connect to MySQL database (optional if environment variables are set) |
| queryB | Execute a SELECT query |
| list_tablesB | List all tables in the database |
| describe_tableB | Get table structure |
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: connect_db handles database connections, describe_table provides table structure, list_tables enumerates tables, and query executes SELECT queries. An agent can easily distinguish between these functions.
The naming follows a consistent verb_noun pattern (connect_db, describe_table, list_tables, query), with 'query' being a minor deviation as it lacks a noun component. Overall, the pattern is predictable and readable.
With only 4 tools, the set feels thin for a MySQL server, lacking essential operations like INSERT, UPDATE, DELETE, or schema modifications. While the tools cover basic querying and inspection, the count is borderline for comprehensive database interaction.
There are significant gaps in the tool surface for a MySQL server. It only supports SELECT queries and table listing/structure, missing CRUD operations (create, update, delete), transaction management, and other database manipulation functions, which will cause agent failures for common tasks.