MCP.so
ログイン

MCP CRUD Interview Question

@MichaelJGKopp

基本情報

カテゴリ

その他

トランスポート

stdio

作者

MichaelJGKopp

MCP CRUD Interview Question について

A lightweight MCP server for managing interview questions. Built with Spring AI and JpaRepository, it communicates via STDIO and integrates with agents like Claude Desktop, requiring explicit permission to execute methods.

MCP CRUD Interview Question の設定

標準の設定はありません

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

リポジトリ

MCP CRUD Interview Question のツール

5

Retrieves interview questions filtered by a specific category

Retrieves all interview questions in the database

Creates a new interview question or updates an existing one

Deletes an interview question by its ID

Deletes all interview questions (use with caution)

概要

What is MCP-CRUD-Interview-Question?

MCP-CRUD-Interview-Question is a Spring Boot‑based MCP server that provides tool‑based CRUD access to a MySQL database of interview questions. It is built with Spring AI and is intended for developers and AI models that need to manage interview question data programmatically.

How to use MCP-CRUD-Interview-Question?

Clone the repository, create the MySQL database mcp_interview_questions_db, configure the connection via application.properties or environment variables (DB_URL, DB_USERNAME, DB_PASSWORD, SERVER_PORT), then build with Maven and run the JAR file. AI models interact with the server through the exposed MCP tools.

Key features of MCP-CRUD-Interview-Question

  • Full CRUD for interview questions
  • Category‑based filtering of questions
  • Tool‑based API via Spring AI annotations
  • MySQL database persistence
  • Five predefined MCP tools for data operations
  • Auto‑schema update via Hibernate

Use cases of MCP-CRUD-Interview-Question

  • AI assistants retrieving interview questions by category for study sessions
  • Adding new questions to a knowledge base through tool calls
  • Updating existing questions with improved answers
  • Deleting outdated or incorrect questions by ID
  • Bulk clearing all questions for resetting a demo environment

よくある質問

1

What are the runtime dependencies?

Java 24, a MySQL database, and Maven 3.6+ (or a compatible build tool) are required.

2

How do I configure the database connection?

Set the environment variables `DB_URL`, `DB_USERNAME`, and `DB_PASSWORD`, or edit the corresponding values in `application.properties`.

3

Where is the data stored?

All interview questions are persisted in a MySQL database named `mcp_interview_questions_db`.

4

Are there any limits on field lengths?

The `difficulty` field is limited to 10 characters, `question` to 1000 characters, and `answer` to 10000 characters. Other fields have no defined limit in the README.

5

Does this server expose a web UI?

No; the configuration `spring.main.web-application-type=none` means it runs purely as an MCP server without a traditional web interface.

コメント

「その他」の他のコンテンツ