MCP MySQL Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | No | The database host | localhost |
| DB_NAME | No | The database name | |
| DB_PORT | No | The database port | 3306 |
| DB_USER | No | The database user | root |
| DB_PASSWORD | No | The database password |
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_dbC | Connect to MySQL database using URL or config |
| queryC | Execute a SELECT query |
| executeC | Execute an INSERT, UPDATE, or DELETE query |
| list_tablesB | List all tables in the database |
| describe_tableB | Get table structure |
| create_tableC | Create a new table in the database |
| add_columnC | Add a new column to existing table |
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 7 tools
Each tool has a clearly distinct purpose with no overlap: add_column modifies table structure, connect_db handles connections, create_table creates tables, describe_table inspects structure, execute handles write queries, list_tables enumerates tables, and query handles read queries. The separation between execute (for INSERT/UPDATE/DELETE) and query (for SELECT) is particularly well-defined.
All tools follow a consistent verb_noun pattern with clear, descriptive names in snake_case: add_column, connect_db, create_table, describe_table, execute, list_tables, query. The naming convention is uniform throughout the set, making it easy to predict tool functions.
With 7 tools, this server is well-scoped for MySQL database operations. Each tool serves a distinct, essential function in the database management workflow, from connection and table listing to query execution and schema modification. The count is neither too sparse nor bloated.
The tool set covers core MySQL operations effectively: connection management, table CRUD (create, list, describe), schema modification (add_column), and query execution (both read and write). A minor gap is the lack of tools for deleting tables or columns, which might require workarounds using execute, but the surface is otherwise complete for basic database interactions.