mysql-mcp-server-all
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | Database host | |
| MYSQL_PORT | No | Database port | 3306 |
| MYSQL_USER | Yes | Database user | |
| MCP_HTTP_HOST | No | Listen host for sse/streamable-http | 127.0.0.1 |
| MCP_HTTP_PORT | No | Listen port for sse/streamable-http | 8000 |
| MCP_TRANSPORT | No | Transport: stdio, sse, or streamable-http | stdio |
| MCP_HTTP_TOKEN | No | Bearer token for streamable-http | |
| MYSQL_DATABASE | No | Default database. Omit for multi-database mode | |
| MYSQL_PASSWORD | No | Database password | |
| MYSQL_CONNECT_TIMEOUT | No | Connection timeout in seconds | 10 |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_sqlA | Execute a read-only SQL query (SELECT / SHOW / DESCRIBE / EXPLAIN / WITH). Returns rows as JSON. Single statements only. |
| get_schema_infoB | Return column metadata (name, type, nullability, key, default) for a table. Accepts database.table notation for cross-database lookups. |
| get_table_sampleA | Fetch a representative sample of rows (max 20) from a table. Accepts database.table notation for cross-database lookups. |
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/ByteTora/mysql-mcp-server-all'
If you have feedback or need assistance with the MCP directory API, please join our Discord server