Skip to main content
Glama
liyq0307

MySQLMCP

by liyq0307
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Remote

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DEBUGNo启用调试模式，默认值: false
NODE_ENVNoNode环境 (development, production, test)，默认值: development
CACHE_TTLNo缓存过期时间(秒)，默认值: 300
LOG_LEVELNo日志级别 (debug, info, warn, error)，默认值: info
MYSQL_SSLNo是否启用SSL连接，默认值: false
BATCH_SIZENo批量操作大小，默认值: 1000
MYSQL_HOSTYes数据库主机地址，默认值: localhost
MYSQL_PORTNo数据库端口，默认值: 3306
MYSQL_USERYes数据库用户名，默认值: root
SERVER_NAMENo服务器名称，默认值: MySQL-MCP-Server
MCP_TRANSPORTNoMCP传输协议，默认值: stdio
MYSQL_CHARSETNo数据库字符集，默认值: utf8mb4
QUERY_TIMEOUTNo查询执行超时时间(毫秒)，默认值: 30000
MEMORY_AUTO_GCNo启用自动垃圾回收，默认值: true
MYSQL_DATABASEYes数据库名称，默认值: test
MYSQL_PASSWORDYes数据库密码，默认值: ""
MYSQL_TIMEZONENo数据库时区，默认值: +00:00
RATE_LIMIT_MAXNo时间窗口内最大请求数，默认值: 100
SERVER_VERSIONNo服务器版本，默认值: 1.0.0
INDEX_CACHE_SIZENo索引信息缓存大小，默认值: 64
RATE_LIMIT_WINDOWNo频率限制时间窗口(毫秒)，默认值: 60000
SCHEMA_CACHE_SIZENo表结构缓存大小，默认值: 128
MONITORING_ENABLEDNo启用性能监控，默认值: true
MYSQL_IDLE_TIMEOUTNo空闲连接超时时间(毫秒)，默认值: 300000
RATE_LIMIT_ENABLEDNo启用频率限制，默认值: true
MEMORY_HISTORY_SIZENo内存历史记录大小，默认值: 100
MYSQL_CONNECT_TIMEOUTNo连接超时时间(毫秒)，默认值: 60000
MYSQL_CONNECTION_LIMITNo连接池最大连接数，默认值: 20
SECURITY_QUERY_TIMEOUTNo查询执行超时时间(毫秒)，默认值: 30000
MONITORING_HISTORY_SIZENo指标历史记录大小，默认值: 1000
TABLE_EXISTS_CACHE_SIZENo表存在性缓存大小，默认值: 64
SECURITY_MAX_RESULT_ROWSNo每次查询最大返回行数，默认值: 1000
MEMORY_MONITORING_ENABLEDNo启用内存监控，默认值: true
MEMORY_PRESSURE_THRESHOLDNo内存压力阈值(0-1)，默认值: 0.8
SECURITY_MAX_INPUT_LENGTHNo最大输入长度（字符数），默认值: 1000
SECURITY_MAX_QUERY_LENGTHNo最大查询长度（字符数），默认值: 10000
MEMORY_MONITORING_INTERVALNo内存监控间隔(毫秒)，默认值: 30000
SYSTEM_MONITORING_INTERVALNo系统监控间隔(毫秒)，默认值: 30000
MEMORY_CACHE_CLEAR_THRESHOLDNo内存缓存清除阈值(0-1)，默认值: 0.85
MONITORING_SNAPSHOT_INTERVALNo性能快照间隔(毫秒)，默认值: 30000
SECURITY_ALLOWED_QUERY_TYPESNo允许的查询类型（逗号分隔），默认值: SELECT,INSERT,UPDATE,DELETE,SHOW,DESCRIBE,EXPLAIN,CREATE,DROP,ALTER
SECURITY_MAX_TABLE_NAME_LENGTHNo最大表名长度（字符数），默认值: 64
MONITORING_SLOW_QUERY_THRESHOLDNo慢查询阈值(毫秒)，默认值: 1000
SECURITY_ENABLE_QUERY_TYPE_RESTRICTIONSNo启用查询类型限制，默认值: 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

NameDescription

No tools

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/liyq0307/MySQLMCP'

If you have feedback or need assistance with the MCP directory API, please join our Discord server