mcp-mysql-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MAX_ROWS | No | Maximum query result rows (default: 1000) | |
| READONLY | No | Read-only mode (default: true) | |
| ALLOW_DDL | No | Allow DDL statements (default: false) | |
| MYSQL_DSN | No | DSN connection string mysql://user:pass@host:port/db, mutually exclusive with individual variables | |
| POOL_SIZE | No | Connection pool size (default: 5) | |
| MYSQL_HOST | No | Database host (default: 127.0.0.1) | |
| MYSQL_PORT | No | Database port (default: 3306) | |
| MYSQL_USER | No | Database user (required if not using DSN) | |
| QUERY_TIMEOUT | No | Query timeout in milliseconds (default: 30000) | |
| MYSQL_DATABASE | No | Default database | |
| MYSQL_PASSWORD | No | Database password (required if not using DSN) | |
| MYSQL_PROFILES_FILE | No | Path to profiles.yml file (overrides default ~/.mcp-mysql/profiles.yml) |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_profilesA | List all available database profiles (passwords hidden) |
| use_profileA | Switch the current database profile (validates connectivity before switching) |
| current_profileA | Show the current active database profile info |
| queryC | Execute SQL query (SELECT, SHOW, etc. In readonly mode, only reads are allowed) |
| list_databasesB | List all accessible databases |
| list_tablesB | List tables in a database with row counts |
| describe_tableA | Show table structure: columns, types, indexes |
| explain_queryC | Run EXPLAIN on a SELECT query and provide analysis |
| generate_schema_docB | Generate Markdown documentation for database tables |
| analyze_relationsB | Analyze table relationships via foreign keys and indexes |
| table_statsB | Show table statistics: row counts, data/index sizes, update time |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/81832310/mcp-mysql-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server