MySQL
Summary
This MCP server implementation provides a bridge to MySQL databases, enabling execution of SELECT queries, listing of tables, and retrieval of table schemas. Developed using Spring Boot and the Spring AI MCP server starter, it offers a streamlined interface for integrating MySQL operations into AI-assisted workflows. The server is particularly useful for scenarios requiring data analysis, reporting, or dynamic database interactions within MCP-based applications.
Available Actions(3)
query
Execute a SELECT SQL query and return results. Input: `sql` (string). Returns: List of query results (truncated after 4000 characters). Note: Only SELECT queries are allowed.
listAllTablesName
List all table names in the database. No input required. Returns: Comma-separated list of table names.
getTableSchema
Get schema information for a specific table. Input: `tableName` (string). Returns: Comma-separated list of column information including Column name, Data type, Nullable constraint, Default value.
社区评论
暂无评论. 成为第一个评论的人！
登录以参与讨论
