sql_creator

MCP tool from SmartDB MCP by wenb1n-dev

SQL query generation tool that generates corresponding SQL query statements based on different database types

How to use it

Project documentation lists sql_creator for the SmartDB MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install SmartDB MCP

$pip install SmartDB-MCP

FULL SMARTDB MCP LISTING

Other tools in SmartDB MCP (7)

execute_sql

SQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configuration

get_db_health

Analyzes database health status (connection status, transaction status, running status, lock detection) and outputs professional diagnostic reports and solutions

get_db_version

Database version query tool

get_table_desc

Searches for table structures in the database based on table names, supports multi-table queries

get_table_index

Searches for table indexes in the database based on table names, supports multi-table queries

get_table_name

Database table name query tool. Used to query all table names in the database or search for corresponding table names based on Chinese table names or table descriptions

sql_optimize

A professional SQL performance optimization tool that provides expert optimization suggestions based on execution plans, table structure information, table data volume, and table indexes.