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.

コメント

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

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

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 Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569