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 | 从文件导入数据到表 |