Skip to main content
Glama
eeantoss

mysql-mcp-server

by eeantoss

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DEBUGNoEnable debug mode (default: false)false
TIMEOUTNoTimeout in ms (default: 60000)60000
MYSQL_HOSTNoMySQL server host (default: localhost)localhost
MYSQL_PORTNoMySQL server port (default: 3306)3306
MYSQL_USERNoMySQL user (default: root)root
MYSQL_DATABASENoDefault database name
MYSQL_PASSWORDNoMySQL password
ACQUIRE_TIMEOUTNoAcquire timeout in ms (default: 60000)60000
CONNECTION_LIMITNoConnection pool limit (default: 10)10
DOCKER_MYSQL_PORTNoDocker MySQL port
DOCKER_CONTAINER_NAMENoDocker 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

CapabilityDetails
tools
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
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

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

C2.9/5.0

Scored across 14 tools

Disambiguation2/5

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.

Naming Consistency3/5

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.

Tool Count3/5

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.

Completeness4/5

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.

Maintenance

ActivitySlowing
ResponsivenessNo issues