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 |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| connect | Connect to a MySQL database. If not called explicitly, will use environment variables for connection. |
| query | Execute a SELECT query and return results. Use this for reading data. |
| execute | Execute an INSERT, UPDATE, DELETE or other modifying query. Returns affected rows count. |
| list_databases | List all databases on the MySQL server |
| list_tables | List all tables in the current or specified database |
| describe_table | Get the structure/schema of a table |
| create_table | Create a new table with specified columns |
| alter_table | Modify an existing table structure |
| drop_table | Drop/delete a table |
| create_database | Create a new database |
| drop_database | Drop/delete a database |
| use_database | Switch to a different database |
| create_index | Create an index on a table |
| drop_index | Drop an index from a table |
| health_check | 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 | |