ytyng/sql-agent-mcp-server
If you are the rightful owner of sql-agent-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
The SQL Agent MCP Server is a versatile server designed to connect to MySQL and PostgreSQL databases, allowing for efficient query execution and database management.
Tools
Functions exposed to the LLM to take actions
sql_query
Execute SQL queries.
get_server_list
Get a list of registered servers.
get_table_list
Get a list of tables for the specified server.
get_table_schema
Get schema information for a table.
get_mysql_status
Get status information for MySQL servers.
get_mysql_variables
Get variable information for MySQL servers.
get_mysql_processlist
Get process list for MySQL servers.
get_mysql_databases
Get database list for MySQL servers.
get_mysql_table_status
Get table status for MySQL servers.
get_mysql_indexes
Get index information for MySQL servers.
analyze_mysql_table
Analyze table for MySQL servers.
optimize_mysql_table
Optimize table for MySQL servers.
check_mysql_table
Check table for MySQL servers.
repair_mysql_table
Repair table for MySQL servers.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client