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.
커뮤니티 리뷰
아직 리뷰가 없습니다. 첫 번째 리뷰를 작성해 보세요!
대화에 참여하려면 로그인하세요