Skip to main content
Glama
ashenud

MySQL MCP Server

by ashenud

MySQL MCP Server

A Model Context Protocol (MCP) server for MySQL database integration with Cursor IDE. This server provides tools to connect to, query, and manage MySQL databases directly from Cursor.

Features

  • ๐Ÿ”Œ Easy Connection: Connect to MySQL databases with simple configuration

  • ๐Ÿ” Query Execution: Run SQL queries and get structured results

  • ๐Ÿ“Š Database Management: List databases, tables, and table schemas

  • ๐Ÿ›ก๏ธ Secure: Supports SSL connections and prepared statements

  • โšก Performance: Connection pooling for optimal performance

  • ๐ŸŽฏ TypeScript: Fully typed for better development experience

Related MCP server: MySQL MCP

Installation

npm install -g @ashenud/mcp-mysql-server

From source

git clone https://github.com/ashenud/mcp-mysql-server.git
cd mcp-mysql-server
npm install
npm run build
npm link

Usage

Cursor IDE Configuration

Add the following to your Cursor MCP settings:

{
  "mcpServers": {
    "mysql": {
      "command": "@ashenud/mcp-mysql-server",
      "args": [],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Available Tools

1. mysql_connect

Connect to a MySQL database.

Parameters:

  • host (string, optional): MySQL host (default: "localhost")

  • port (number, optional): MySQL port (default: 3306)

  • user (string, required): MySQL username

  • password (string, required): MySQL password

  • database (string, optional): Database name

  • ssl (boolean, optional): Use SSL connection (default: false)

  • connectionLimit (number, optional): Connection pool limit (default: 10)

Example:

{
  "name": "mysql_connect",
  "arguments": {
    "host": "localhost",
    "port": 3306,
    "user": "myuser",
    "password": "mypassword",
    "database": "mydb",
    "ssl": false
  }
}

2. mysql_query

Execute a SQL query.

Parameters:

  • query (string, required): SQL query to execute

  • params (array, optional): Query parameters for prepared statements

Example:

{
  "name": "mysql_query",
  "arguments": {
    "query": "SELECT * FROM users WHERE age > ?",
    "params": ["25"]
  }
}

3. mysql_list_databases

List all available databases.

Example:

{
  "name": "mysql_list_databases",
  "arguments": {}
}

4. mysql_list_tables

List tables in a database.

Parameters:

  • database (string, optional): Database name (uses current if not provided)

Example:

{
  "name": "mysql_list_tables",
  "arguments": {
    "database": "mydb"
  }
}

5. mysql_describe_table

Get table structure and schema information.

Parameters:

  • table (string, required): Table name

  • database (string, optional): Database name (uses current if not provided)

Example:

{
  "name": "mysql_describe_table",
  "arguments": {
    "table": "users",
    "database": "mydb"
  }
}

6. mysql_disconnect

Close the MySQL connection.

Example:

{
  "name": "mysql_disconnect",
  "arguments": {}
}

Development

Prerequisites

  • Node.js 18.0.0 or higher

  • npm or yarn

Setup

  1. Clone the repository:

git clone https://github.com/ashenud/mcp-mysql-server.git
cd mcp-mysql-server
  1. Install dependencies:

npm install
  1. Build the project:

npm run build
  1. Run in development mode:

npm run dev

Testing

Run the test suite:

npm test

Configuration

The server can be configured through environment variables or by passing parameters to the mysql_connect tool:

  • MYSQL_HOST: Default MySQL host

  • MYSQL_PORT: Default MySQL port

  • MYSQL_USER: Default MySQL username

  • MYSQL_PASSWORD: Default MySQL password

  • MYSQL_DATABASE: Default database name

  • MYSQL_SSL: Use SSL connection (true/false)

Security Considerations

  • Always use strong passwords for database connections

  • Enable SSL for production environments

  • Use connection pooling to limit concurrent connections

  • Validate and sanitize all user inputs before executing queries

  • Consider using read-only database users for MCP connections

Error Handling

The server provides detailed error messages for common issues:

  • Connection failures

  • Invalid SQL queries

  • Authentication errors

  • Database access permissions

  • Network timeouts

Contributing

  1. Fork the repository

  2. Create a feature branch: git checkout -b feature-name

  3. Make your changes and add tests

  4. Commit your changes: git commit -am 'Add some feature'

  5. Push to the branch: git push origin feature-name

  6. Submit a pull request

License

MIT License - see LICENSE file for details.

Support

Changelog

1.0.0

  • Initial release

  • Basic MySQL connection and query functionality

  • Database and table listing

  • Table schema inspection

  • Connection pooling support

  • SSL connection support

Available Tools

8 tools
mysql_connectC

Connect to a MySQL database

ParametersJSON Schema
NameRequiredDescriptionDefault
hostNoMySQL hostlocalhost
portNoMySQL port
userYesMySQL username
passwordYesMySQL password
databaseNoDatabase name (optional)
sslNoUse SSL connection
connectionLimitNoConnection pool limit

TDQS

C2.7/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It states the action ('connect') but doesn't reveal critical traits: whether this creates a persistent connection pool (implied by connectionLimit parameter), authentication requirements beyond parameters, error handling, or what happens on success/failure. For a connection tool with multiple parameters, this is a significant gap in transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence with zero waste. It's appropriately sized for a basic tool definition and front-loaded with the core action. Every word earns its place, making it highly concise and well-structured.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity of a database connection tool with 7 parameters, no annotations, and no output schema, the description is incomplete. It doesn't explain what the tool returns (e.g., connection object, success status), error conditions, or behavioral nuances like connection pooling. This leaves significant gaps for an agent to use the tool effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the input schema fully documents all 7 parameters with descriptions and defaults. The description adds no additional parameter semantics beyond implying a connection action. This meets the baseline of 3, as the schema handles the heavy lifting, but the description doesn't compensate or provide extra context.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose3/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description 'Connect to a MySQL database' clearly states the verb ('connect') and resource ('MySQL database'), providing a basic purpose. However, it doesn't differentiate from siblings like mysql_setup_persistent (which might also establish connections) or specify what type of connection is established (e.g., session vs. pool). This makes it adequate but vague compared to alternatives.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance is provided on when to use this tool versus alternatives. For example, it doesn't clarify if this is for one-time queries versus persistent connections, or how it relates to mysql_setup_persistent or mysql_disconnect. The description lacks any context about prerequisites or exclusions, leaving the agent to infer usage.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

mysql_describe_tableB

Get table structure and schema information

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYesTable name
databaseNoDatabase name (optional, uses current if not provided)

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the tool 'gets' information, implying a read-only operation, but doesn't specify permissions required, whether it's safe for production use, potential rate limits, or what the output format looks like (e.g., columns, data types). For a tool with zero annotation coverage, this is insufficient, scoring a 2.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence: 'Get table structure and schema information.' It's front-loaded with the core purpose, has zero wasted words, and is appropriately sized for the tool's function, earning a perfect score for conciseness.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's moderate complexity (describing table schemas), no annotations, and no output schema, the description is minimally adequate. It states what the tool does but lacks details on behavioral traits, output format, or usage context. It's complete enough to understand the basic purpose but leaves gaps in practical application, scoring a 3.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 100% description coverage, with clear documentation for both parameters (table and database). The description doesn't add any meaning beyond what the schema providesโ€”it doesn't explain what 'structure and schema information' entails or how parameters affect the output. With high schema coverage, the baseline is 3, and the description doesn't enhance it.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description 'Get table structure and schema information' clearly states the tool's purpose with a specific verb ('Get') and resource ('table structure and schema information'). It distinguishes from siblings like mysql_list_tables (which lists tables) and mysql_query (which executes queries), but doesn't explicitly contrast with them, keeping it at a 4 rather than a 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when to prefer mysql_describe_table over other tools like mysql_query for schema inspection or how it relates to mysql_list_tables. Without any usage context or exclusions, it scores a 2.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

mysql_disconnectB

Close the MySQL connection

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It states the action ('Close') but doesn't describe what happens upon closing (e.g., terminates sessions, releases resources, irreversible without reconnection), potential side effects, or error conditions. This is a significant gap for a tool that likely involves resource management.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, clear sentence with zero wasteโ€”'Close the MySQL connection'โ€”making it front-loaded and efficiently communicates the core action without extraneous details.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (managing database connections) and lack of annotations or output schema, the description is incomplete. It doesn't explain the outcome (e.g., success/failure indicators, what happens to pending queries), prerequisites, or error handling, leaving gaps for an AI agent to understand full usage context.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has 0 parameters, and schema description coverage is 100% (since there are no parameters to describe). The description doesn't need to add parameter details, so it meets the baseline of 4 for tools with no parameters, as it avoids unnecessary complexity.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Close') and the resource ('MySQL connection'), making the purpose immediately understandable. It doesn't explicitly differentiate from siblings like 'mysql_connect' or 'mysql_status', but the verb 'Close' versus 'Connect' or 'Status' provides inherent distinction.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., requires an open connection), exclusions (e.g., don't use if no connection exists), or relationships to siblings like 'mysql_connect' for setup or 'mysql_status' for checking connection state.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

mysql_list_databasesB

List all available databases

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.2/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It states it's a list operation, implying it's read-only and non-destructive, but doesn't confirm this explicitly. It also doesn't describe output format (e.g., array of strings), error conditions, or any side effects (e.g., whether it requires specific permissions). For a tool with zero annotation coverage, this is a significant gap in transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence ('List all available databases') that is front-loaded with the core purpose. There is zero wasteโ€”every word earns its place by specifying the action, scope, and resource without unnecessary elaboration.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's low complexity (0 parameters, simple list operation) and lack of annotations or output schema, the description is minimally adequate. It states what the tool does but omits critical context like output format, error handling, and usage prerequisites. For a discovery tool in a database context, more completeness would be helpful, but it meets the minimum viable threshold.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 0 parameters with 100% coverage, meaning there are no parameters to document. The description doesn't need to add parameter semantics, so it meets the baseline of 4 for tools with no parameters. It correctly implies no inputs are required for listing databases.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description 'List all available databases' clearly states the verb ('List') and resource ('databases') with the scope modifier 'all available'. It distinguishes from siblings like mysql_list_tables (which lists tables, not databases) and mysql_query (which executes queries). However, it doesn't explicitly differentiate from mysql_status (which might also provide database information), keeping it at 4 rather than 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., needing to connect first with mysql_connect), when it's appropriate (e.g., for discovery vs. querying), or exclusions (e.g., not for modifying databases). This leaves the agent with minimal context for tool selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

mysql_list_tablesC

List tables in the current database

ParametersJSON Schema
NameRequiredDescriptionDefault
databaseNoDatabase name (optional, uses current if not provided)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden for behavioral disclosure. It states it's a list operation, implying read-only behavior, but doesn't specify whether it requires specific permissions, what format the output takes (e.g., array of table names), if there are rate limits, or any error conditions. The description is minimal and lacks important operational context for a tool that interacts with a database.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is extremely concise - a single sentence that directly states the tool's function. There's zero wasted language, no redundancy, and it's perfectly front-loaded with the essential information. Every word earns its place in this minimal but complete statement of purpose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given this is a database interaction tool with no annotations and no output schema, the description is insufficiently complete. It doesn't explain what the tool returns (table names, metadata?), doesn't mention authentication requirements (though siblings suggest connection management), and provides no context about error handling or constraints. For a tool that presumably returns structured data from MySQL, more context is needed.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, with the single parameter 'database' fully documented in the schema as optional and defaulting to current. The description doesn't add any parameter-specific information beyond what the schema provides (it doesn't mention the parameter at all). According to guidelines, when schema coverage is high (>80%), the baseline is 3 even with no param info in the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('List tables') and resource ('in the current database'), making the purpose immediately understandable. It distinguishes from siblings like mysql_list_databases (which lists databases) and mysql_describe_table (which describes a specific table). However, it doesn't specify that this lists ALL tables or mention any filtering capabilities, keeping it from a perfect score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when to use mysql_list_tables versus mysql_query for table listing, or how it relates to mysql_describe_table for detailed table information. The only implicit context is 'current database,' but no explicit usage scenarios or exclusions are provided.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

mysql_queryC

Execute a MySQL query

ParametersJSON Schema
NameRequiredDescriptionDefault
queryYesSQL query to execute
paramsNoQuery parameters for prepared statements

TDQS

C2.7/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. 'Execute a MySQL query' implies a write operation could occur, but it doesn't specify whether this tool is read-only, destructive, requires authentication, has rate limits, or what happens on errors. For a database tool with zero annotation coverage, this is a significant gap in transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is extremely concise with a single sentence ('Execute a MySQL query'), which is front-loaded and wastes no words. It efficiently conveys the core action, though this brevity contributes to gaps in other dimensions.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity of a database query tool with no annotations, no output schema, and multiple siblings, the description is incomplete. It lacks context on behavior, return values, error handling, and integration with other tools (e.g., mysql_connect). This makes it inadequate for safe and effective use by an AI agent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, with clear descriptions for both parameters ('query' and 'params'), so the schema does the heavy lifting. The description adds no additional meaning beyond what the schema provides, such as query syntax examples or param usage details. Baseline 3 is appropriate when schema coverage is high.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose3/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description 'Execute a MySQL query' clearly states the verb ('Execute') and resource ('MySQL query'), making the basic purpose understandable. However, it doesn't distinguish this tool from potential alternatives or specify what type of queries it handles (e.g., SELECT, INSERT, DDL). Compared to siblings like mysql_list_tables or mysql_describe_table, the distinction is implied but not explicit.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., requiring a connection via mysql_connect), appropriate query types, or when to choose other tools like mysql_list_databases for specific tasks. Usage is implied but not stated, leaving gaps for an AI agent.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

mysql_setup_persistentC

Set up persistent connection with default credentials

ParametersJSON Schema
NameRequiredDescriptionDefault
hostNoMySQL hostlocalhost
portNoMySQL port
userYesMySQL username
passwordYesMySQL password
databaseNoDatabase name
sslNoUse SSL connection
connectionLimitNoConnection pool limit

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden but offers minimal behavioral insight. It mentions 'persistent connection' and 'default credentials' but doesn't explain what persistence entails (e.g., connection pooling, reuse), authentication requirements beyond parameters, or potential side effects like resource consumption.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Extremely concise with a single, clear sentence that front-loads the core purpose. No wasted words or redundant information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a connection setup tool with 7 parameters, no annotations, and no output schema, the description is insufficient. It lacks details on what 'persistent' means operationally, what 'default credentials' implies, error handling, or what successful setup returns, leaving significant gaps for agent understanding.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 7 parameters. The description adds no additional parameter semantics beyond what's in the schema, maintaining the baseline score of 3 for high coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Set up') and resource ('persistent connection'), specifying it uses 'default credentials'. It distinguishes from 'mysql_connect' by implying persistence, but doesn't explicitly differentiate from all siblings like 'mysql_status' or 'mysql_disconnect'.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance on when to use this tool versus alternatives like 'mysql_connect' or other siblings. The description mentions 'default credentials' but doesn't explain what that means or when this is preferred over other connection methods.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

mysql_statusB

Check connection status and database info

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.2/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the tool checks connection status and database info, which implies a read-only operation, but doesn't specify what 'database info' includes (e.g., version, uptime), whether it requires an active connection, or any side effects like performance impact. For a tool with zero annotation coverage, this leaves significant gaps in understanding its behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence: 'Check connection status and database info'. It is front-loaded with the core purpose, has zero waste, and is appropriately sized for a simple tool. Every word earns its place by conveying essential information without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's low complexity (0 parameters, no output schema, no annotations), the description is minimally adequate. It covers the basic purpose but lacks details on what 'database info' includes or behavioral aspects. With no output schema, it doesn't explain return values, which is a gap. For a diagnostic tool, more context on expected outputs would improve completeness.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 0 parameters with 100% coverage, meaning no parameters are documented in the schema. The description doesn't add parameter details since there are none, which is appropriate. Baseline is 4 for 0 parameters, as the description doesn't need to compensate for missing schema info.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose as 'Check connection status and database info', which specifies the verb 'check' and the resources 'connection status and database info'. It distinguishes from siblings like mysql_query (executes queries) and mysql_list_databases (lists databases), though it doesn't explicitly differentiate them. The purpose is specific but could be more precise about what 'database info' entails.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., after mysql_connect), exclusions, or comparisons to siblings like mysql_list_databases (which might provide overlapping info). Usage is implied as a diagnostic check, but no explicit context is given.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

TDQS

A3.5/5.0
Disambiguation5/5

Each tool has a clearly distinct purpose with no overlap: connection management (connect, disconnect, status, setup_persistent), metadata listing (databases, tables, describe_table), and query execution (query). The descriptions make it easy to tell them apart, with no ambiguity in their functions.

Naming Consistency5/5

All tool names follow a consistent 'mysql_verb_noun' pattern (e.g., mysql_connect, mysql_describe_table, mysql_list_databases). This predictable naming scheme makes it easy for agents to understand and navigate the tool set without confusion.

Tool Count5/5

With 8 tools, this server is well-scoped for MySQL database operations. It covers essential functions like connection handling, metadata exploration, and query execution, with each tool earning its place without feeling bloated or insufficient.

Completeness4/5

The tool set provides solid coverage for core MySQL workflows: connection lifecycle, database/table listing, schema inspection, and query execution. A minor gap is the lack of tools for more advanced operations like transaction management or user administration, but agents can work around this using the query tool.

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • F
    license
    A
    quality
    D
    maintenance
    A tool that provides simple API to execute SQL queries and manage MySQL databases, designed to integrate with Cursor IDE for AI assistants to directly perform database operations.
    8
    2
  • F
    license
    Not graded
    quality
    C
    maintenance
    Enables management and querying of multiple MySQL databases through natural language, allowing AI assistants to list databases, execute SQL queries, and explore database schemas.
    1
  • F
    license
    Not graded
    quality
    Not graded
    maintenance
    Enables direct interaction with MySQL databases through SQL queries, table exploration, and schema inspection with support for prepared statements and connection pooling.
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables AI assistants to interact with MySQL databases by executing SQL queries, describing table schemas, and listing tables. It provides seamless database integration for tools like Cursor through the Model Context Protocol.
    454
    MIT

Latest Blog Posts

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

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