Skip to main content
Glama
CCCT173

mysql-mcp-pro

by CCCT173

begin_transaction

Open a new transaction and obtain a session ID to execute multiple queries within the same transaction. Requires commit or rollback to release the connection.

Instructions

开启一个新事务,返回 session_id。后续在 execute_query 中传入 session_id 即可在同一事务里执行多语句。 记得在结束时调用 commit_transaction 或 rollback_transaction。

⚠️ 事务会独占一条连接,请在操作完毕后及时 commit/rollback。

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
databaseNo
Behavior4/5

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

Without annotations, the description carries the burden. It discloses that the transaction occupies a connection and should be committed/rolled back promptly, but could mention timeout or concurrency aspects.

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?

Three sentences, front-loaded with purpose, each sentence adds value with no redundancy.

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

Completeness5/5

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

For a simple tool with one optional parameter and no output schema, the description provides sufficient information: purpose, return value, usage, and behavioral warning.

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

Parameters2/5

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

The only parameter 'database' is not explained in the description, and schema coverage is 0%. The description does not add meaning beyond the schema, leaving the agent uncertain about its purpose.

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

Purpose5/5

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

The description clearly states that the tool starts a new transaction and returns a session_id, which distinguishes it from siblings like commit and rollback.

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

Usage Guidelines5/5

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

It explicitly instructs to pass the session_id to execute_query and to call commit_transaction or rollback_transaction, and warns about connection exclusivity.

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

Install Server

Other Tools

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/CCCT173/mysql-mcp-pro'

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