MCP Server MySQL

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MYSQL_HOST`	Yes	The MySQL host address	localhost
`MYSQL_PORT`	Yes	The MySQL port number	3306
`MYSQL_USER`	Yes	The MySQL username	root
`MYSQL_DATABASE`	No	The MySQL database name (optional)
`MYSQL_PASSWORD`	Yes	The MySQL password
`MYSQL_ALLOW_DELETE`	No	Set to "false" to disable DELETE operations	true
`MYSQL_ALLOW_INSERT`	No	Set to "false" to disable INSERT operations	true
`MYSQL_ALLOW_UPDATE`	No	Set to "false" to disable UPDATE operations	true

Server capabilities have not been inspected yet.

Functions exposed to the LLM to take actions

Name	Description
connectA	Connect to a MySQL database. If not called explicitly, will use environment variables for connection.
queryB	Execute a SELECT query and return results. Use this for reading data.
executeB	Execute an INSERT, UPDATE, DELETE or other modifying query. Returns affected rows count.
list_databasesB	List all databases on the MySQL server
list_tablesB	List all tables in the current or specified database
describe_tableC	Get the structure/schema of a table
create_tableC	Create a new table with specified columns
alter_tableC	Modify an existing table structure
drop_tableC	Drop/delete a table
create_databaseC	Create a new database
drop_databaseC	Drop/delete a database
use_databaseC	Switch to a different database
create_indexC	Create an index on a table
drop_indexC	Drop an index from a table
health_checkB	Check database connection health and get server status

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

Latest Blog Posts

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

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

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