Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | MySQL server address | localhost |
| MYSQL_PORT | No | MySQL port number | 3306 |
| MYSQL_USER | Yes | MySQL username | root |
| MYSQL_TIMEOUT | No | Connection timeout in milliseconds | 60000 |
| MYSQL_DATABASE | No | Default database name | |
| MYSQL_PASSWORD | Yes | MySQL password | |
| MYSQL_CONNECTION_LIMIT | No | Connection pool size | 10 |
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 |
|---|---|
| mysql_connect | 连接到 MySQL 数据库 |
| mysql_disconnect | 断开 MySQL 数据库连接 |
| mysql_list_databases | 列出所有数据库 |
| mysql_create_database | 创建数据库 |
| mysql_drop_database | 删除数据库 |
| mysql_list_tables | 列出指定数据库的所有表 |
| mysql_describe_table | 查看表结构 |
| mysql_create_table | 创建表 |
| mysql_drop_table | 删除表 |
| mysql_query | 执行 SQL 查询 |
| mysql_insert | 插入数据到表 |
| mysql_update | 更新表数据 |
| mysql_delete | 删除表数据 |
| mysql_export_data | 导出表数据到文件 |
| mysql_import_data | 从文件导入数据到表 |