MCP CRUD Interview Question

@MichaelJGKopp

Basic information

About 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 config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MCP CRUD Interview Question tools

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)

Overview

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

Frequently asked questions

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.

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.

Comments

More Other MCP servers

ICSS

chokcoco

不止于 CSS

20.7K

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w