MCP-CRUD-Interview-Question

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.

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.