mysql-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DEBUG | No | Enable debug mode (default: false) | false |
| TIMEOUT | No | Timeout in ms (default: 60000) | 60000 |
| MYSQL_HOST | No | MySQL server host (default: localhost) | localhost |
| MYSQL_PORT | No | MySQL server port (default: 3306) | 3306 |
| MYSQL_USER | No | MySQL user (default: root) | root |
| MYSQL_DATABASE | No | Default database name | |
| MYSQL_PASSWORD | No | MySQL password | |
| ACQUIRE_TIMEOUT | No | Acquire timeout in ms (default: 60000) | 60000 |
| CONNECTION_LIMIT | No | Connection pool limit (default: 10) | 10 |
| DOCKER_MYSQL_PORT | No | Docker MySQL port | |
| DOCKER_CONTAINER_NAME | No | Docker container name for MySQL |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| database_connectC | Connect to a MySQL or PostgreSQL database |
| database_execute_sqlA | Execute a single SQL statement on the active database connection |
| database_execute_scriptB | Execute a SQL script with multiple statements on the active database connection |
| database_execute_batchB | Execute multiple SQL statements as a batch on the active database connection |
| database_get_schemaA | Get the database schema (tables, columns, indexes, foreign keys, views) |
| database_test_connectionB | Test the active database connection |
| database_disconnectB | Close the active database connection |
| database_detect_projectB | Detect database configuration from a project directory |
| database_list_environmentsA | List detected database environments for the current project |
| database_connect_environmentB | Connect to a specific detected database environment |
| database_switch_environmentB | Switch to a different detected database environment |
| database_list_sessionsB | List active database sessions |
| database_get_project_summaryB | Get summary of the currently detected project |
| check_node_versionB | Check Node.js version |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 14 tools
Several tools have overlapping purposes: database_execute_sql, database_execute_script, and database_execute_batch all execute SQL but with subtle differences, while database_connect, database_connect_environment, and database_switch_environment cover similar connection territory. The presence of check_node_version, which has nothing to do with database operations, further confuses tool selection.
Most tools follow a consistent database_verb_noun pattern (e.g., database_connect, database_execute_sql), but the lone check_node_version breaks the convention entirely. The naming is readable but not fully uniform.
At 14 tools, the count is at the high end of the typical range but still acceptable for a database server. However, the inclusion of check_node_version, which is unrelated to MySQL/PostgreSQL work, suggests the count could be reduced or the tool placed in a separate utility server.
The tool set covers core database operations well: connecting, disconnecting, testing, executing SQL (single, script, batch), retrieving schema, managing project environments, and listing sessions. Minor gaps like explicit transaction control are not critical for a basic MCP database server, so the surface is fairly complete.