mcpField
M
MySQL MCP Server

MySQL MCP Server

Local
github.com/kioyongDatabases11Updated 86w ago
Repository

About MySQL MCP Server

MySQL MCP Server is a Spring Boot MCP server for exposing read-only database inspection to MCP clients. It supports SELECT queries, table listing, and schema lookup.

Key features

  1. 01Run SELECT queries
  2. 02List database tables
  3. 03Retrieve table column details

Use cases

  1. 01Inspecting query results
  2. 02Finding tables in a database
  3. 03Checking a table's columns and defaults

MCP support

It exposes tools for SELECT queries, listing table names, and retrieving table schema information to MCP clients.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

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"
    }
  }
}

001.png

Example

002.png

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.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.