MCP-CRUD-Interview-Question

Name: MCP-CRUD-Interview-Question
Author: MichaelJGKopp

@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.

基本情報

カテゴリ

その他

ランタイム

java

トランスポート

stdio

公開者

MichaelJGKopp

設定

標準の設定はありません

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

リポジトリ

ツール

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

FAQ from MCP-CRUD-Interview-Question

What are the runtime dependencies?

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

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.

Where is the data stored?

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

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.