MCPVault

optimizeSql

MCP tool from Alibabacloud Dms MCP Server by aliyun

Analyzes and optimizes SQL performance.

How to use it

optimizeSql is exposed by the Alibabacloud Dms MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the optimizeSql tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

FULL ALIBABACLOUD DMS MCP SERVER LISTING

Other tools in Alibabacloud Dms MCP Server (16)

addInstance

Adds an instance to DMS. Only Aliyun instances are supported.

answerSqlSyntax

Answers SQL syntax-related questions.

approveOrder

Approves or rejects an order in DMS.

askDatabase

Natural language querying of a database (NL2SQL + execute SQL).

createDataChangeOrder

Creates a data change order in DMS.

executeScript

Executes an SQL script and returns the result.

fixSql

Analyzes and fixes SQL errors.

generateSql

Converts natural language questions into SQL queries.

getDatabase

Retrieves detailed information about a specific database.

getInstance

Retrieves detailed information about an instance based on host and port.

getOrderInfo

Retrieves order information from DMS.

getTableDetailInfo

Retrieves detailed information about a specific table.

listInstances

Search for instances from DMS.

listTables

Lists tables under a specified database.

searchDatabase

Searches databases based on schemaName.

submitOrderApproval

Submits the order for approval in DMS.