Server Configuration
Describes the environment variables required to run the server.
Name | Required | Description | Default |
---|---|---|---|
MYSQL_HOST | Yes | Database server hostname or IP address | localhost |
MYSQL_PORT | No | Database server port | 3306 |
MYSQL_USER | Yes | Database username | |
MYSQL_DATABASE | Yes | Database name to connect to | |
MYSQL_PASSWORD | Yes | Database password | |
MYSQL_READONLY | No | Set to true for read-only access | true |
Schema
Prompts
Interactive templates invoked by user choice
Name | Description |
---|---|
No prompts |
Resources
Contextual data attached and managed by the client
Name | Description |
---|---|
No resources |
Tools
Functions exposed to the LLM to take actions
Name | Description |
---|---|
status | Check the current database connection status. |
connect | Connect to a MySQL database. |
disconnect | Close the current MySQL database connection. |
query | Execute an SQL query on the connected database. |
list_tables | Get a list of tables in the current database. |
describe_table | Get the structure of a specific table. |
list_databases | Get a list of all accessible databases on the server. |
use_database | Switch to a different database. |
set_readonly | Enable or disable read-only mode |