MCP.so
ログイン

Spring Boot MySQL Project

@angelo848

リポジトリ

Spring Boot MySQL Project について

概要はまだありません

基本情報

カテゴリ

データベース

ランタイム

java

トランスポート

stdio

公開者

angelo848

設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Spring Boot MySQL Project?

Spring Boot MySQL Project is an MCP server that provides database access to a MySQL database using Spring Boot, HikariCP connection pool, and Hibernate. It is designed for developers who want to interact with MySQL databases through MCP clients.

How to use Spring Boot MySQL Project?

Create a MySQL database named demo, update credentials in application.properties if needed, then build with Maven (mvn clean install) and run via mvn spring-boot:run or java -jar. For MCP client usage, configure the server with JSON providing database host, port, schema, user, and password as JVM arguments.

Key features of Spring Boot MySQL Project

  • Uses Spring Boot with MySQL and HikariCP connection pool.
  • Hibernate ddl-auto set to update for automatic schema changes.
  • Supports MCP stdio transport.
  • Configurable via application.properties and JVM arguments.
  • Default connection pool size of 10.
  • Runs on port 8080.

Use cases of Spring Boot MySQL Project

  • Querying a MySQL database from an MCP client.
  • Managing database schema automatically via Hibernate.
  • Connecting to a remote MySQL database using MCP configuration.
  • Debugging the MCP server with the inspector tool.

FAQ from Spring Boot MySQL Project

What is the mandatory configuration for stdio mode?

Set spring.main.web-application-type=none in application.properties to avoid a web server startup error when using stdio.

How to debug the MCP server?

Use the MCP inspector with the command: npx @modelcontextprotocol/inspector java -Dspring.ai.mcp.server.stdio=true -jar /path/to/project/target/java-mysql-mcp-0.0.1-SNAPSHOT.jar. Logs are written to ./mcp-mysql-stdio-server.log.

What are the default database credentials?

Default username is root and password is root for the demo database.

How to configure database connection in an MCP client?

Provide a JSON configuration with JVM arguments: -Ddb.hostenv=host:port, -Ddb.schema=/demo, -Ddb.user=username, -Ddb.passwordenv=password.

What is the default server port?

The default port is 8080.

コメント

「データベース」の他のコンテンツ

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Elasticsearch MCP Server

elastic

685

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193