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, and default value.
Community Reviews
No reviews yet. Be the first to review!
Sign in to join the conversation
