Schema | MySQL MCP Server

MySQL MCP Server

Describes the environment variables required to run the server.

Name	Required	Description
`DB_HOST`	Yes	MySQL host address
`DB_PORT`	Yes	MySQL port number
`DB_USER`	Yes	MySQL user
`DB_DATABASE`	Yes	MySQL database name
`DB_PASSWORD`	Yes	MySQL password
`AUDIT_LOG_DIR`	No	Directory for audit logs
`PERMISSION_MODE`	No	Permission mode: read_only or read_write
`AUDIT_LOG_ENABLED`	No	Enable audit logging (true/false)

Features and capabilities supported by this server

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
mysql_queryB	Execute a SELECT query against MySQL. Returns rows, field names, and row count. Results are automatically limited.
mysql_explainA	Run EXPLAIN on a SELECT statement to analyze query performance. Returns execution plan and full-scan warnings.
mysql_list_databasesA	List all accessible databases (system databases are excluded).
mysql_list_tablesB	List all tables in a database.
mysql_describe_tableA	Get column structure, indexes, and CREATE statement for a table.
mysql_executeA	[riskLevel: medium] Execute an INSERT, UPDATE, or DELETE statement. UPDATE/DELETE without WHERE are rejected by default.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/huanglixinccc/mysql-mcp-nest'

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