MCP Server MySQL
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | The MySQL host address | localhost |
| MYSQL_PORT | Yes | The MySQL port number | 3306 |
| MYSQL_USER | Yes | The MySQL username | root |
| MYSQL_DATABASE | No | The MySQL database name (optional) | |
| MYSQL_PASSWORD | Yes | The MySQL password | |
| MYSQL_ALLOW_DELETE | No | Set to "false" to disable DELETE operations | true |
| MYSQL_ALLOW_INSERT | No | Set to "false" to disable INSERT operations | true |
| MYSQL_ALLOW_UPDATE | No | Set to "false" to disable UPDATE operations | 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 |
|---|---|
| connectA | Connect to a MySQL database. If not called explicitly, will use environment variables for connection. |
| queryB | Execute a SELECT query and return results. Use this for reading data. |
| executeB | Execute an INSERT, UPDATE, DELETE or other modifying query. Returns affected rows count. |
| list_databasesB | List all databases on the MySQL server |
| list_tablesB | List all tables in the current or specified database |
| describe_tableC | Get the structure/schema of a table |
| create_tableC | Create a new table with specified columns |
| alter_tableC | Modify an existing table structure |
| drop_tableC | Drop/delete a table |
| create_databaseC | Create a new database |
| drop_databaseC | Drop/delete a database |
| use_databaseC | Switch to a different database |
| create_indexC | Create an index on a table |
| drop_indexC | Drop an index from a table |
| health_checkB | Check database connection health and get server status |
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 15 tools
Every tool has a clearly distinct purpose with no ambiguity. Each tool targets a specific database operation (e.g., create_table vs. alter_table, query vs. execute) with clear boundaries between read operations, write operations, and administrative tasks.
Tool names follow a consistent verb_noun pattern throughout (e.g., create_database, list_tables, drop_index). All names use snake_case with descriptive verbs that clearly indicate the action being performed.
15 tools is well-scoped for a MySQL database server, covering essential CRUD operations, schema management, and administrative functions. Each tool earns its place without redundancy or bloat.
The toolset provides complete coverage for MySQL database operations including connection management, database/table lifecycle (create, describe, drop), data manipulation (query, execute), indexing, and administrative functions. No obvious gaps exist for core database workflows.