Schema | mysql-mcp

mysql-mcp

Describes the environment variables required to run the server.

Name	Required	Description
`MYSQL_SSL`	No	SSL mode (e.g., 'require', 'verify-ca')
`MYSQL_URL`	No	Connection URL (mysql://user:pass@host:3306/db)
`MYSQL_HOST`	No	Database host
`MYSQL_PORT`	No	Database port (default: 3306)
`MYSQL_USER`	No	Database user
`MYSQL_DATABASE`	No	Default database name
`MYSQL_MAX_ROWS`	No	Maximum rows returned
`MYSQL_PASSWORD`	No	Database password
`MYSQL_QUERY_TIMEOUT_MS`	No	Query timeout in milliseconds

Features and capabilities supported by this server

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
list_databasesA	List MySQL databases (schemas) visible to the configured user.
list_tablesA	List tables and views in a database. Uses MYSQL_DATABASE when database is omitted.
describe_tableA	Describe columns for a table (types, nullability, keys).
show_create_tableB	Return SHOW CREATE TABLE / VIEW DDL for a table or view.
list_indexesB	List indexes for a table.
list_foreign_keysA	List foreign-key relationships in a database, optionally filtered by table.
list_routinesB	List stored procedures and functions in a database.
list_triggersA	List triggers in a database, optionally filtered by table.
list_eventsB	List scheduled events in a database.
read_queryA	Execute a single read-only SELECT (or WITH … SELECT). Mutating SQL is rejected. Queries with FOR UPDATE / FOR SHARE / LOCK IN SHARE MODE / INTO @var require confirmed=true after a preview. Results are LIMIT-capped.
write_queryA	Execute INSERT, UPDATE, DELETE, REPLACE, or TRUNCATE. Separate from read_query. Requires confirmed=true after a strong confirmation preview.
schema_queryA	Execute CREATE, ALTER, DROP, or RENAME (DDL). Separate from write_query. Requires confirmed=true after a strong confirmation preview.
transaction_queryA	Execute multiple statements in one transaction. Preview lists per-statement risk. Requires confirmed=true.
explain_queryA	Run EXPLAIN on a SELECT / WITH query (traditional or JSON format).

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/RexySaragih/mcp-mysql'

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