📊
Mysql MCP Server Java
No description available
0 installs
Trust: 35 — Low
Data
Ask AI about Mysql MCP Server Java
Powered by Claude · Grounded in docs
I know everything about Mysql MCP Server Java. Ask me about installation, configuration, usage, or troubleshooting.
0/500
Loading tools...
Reviews
Documentation
MySQL MCP Server
Spring Boot server implementing Model Context Protocol (MCP) for MySQL database operations.
Features
- Execute SELECT queries
- List all tables in database
- Get table schema information
API
Tools
-
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
Build
Maven build:
mvn install
Usage with Claude Desktop or Cline
Add this to your mcp server config file:
{
"mysql-server": {
"command": "java",
"args": [
"-jar",
"{{ProjectDirectory}}\\target\\mcp-mysql-server-1.0.0.jar"
],
"env": {
"SPRING_DATASOURCE_URL": "jdbc:mysql://username:password@localhost:3306/database"
}
}
}

Example

License
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
