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.
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.
List all table names in the database. No input required. Returns: Comma-separated list of table names.
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.
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIOur bundler currently only supports TypeScript-based servers. Check back soon!