Javamcpserver4claudedesktop

🚀 Task Management Server (TasksMcpServer)

A task management service application built with Spring Boot, using SQLite database for data storage. This project demonstrates the integration of Spring Boot with SQLite and JPA to achieve efficient task management.

✨ Features

• Task management, supporting create, query, update, and delete operations
• Integration with SQLite database
• Data persistence using JPA/Hibernate
• Provision of RESTful API interfaces
• Unit tests with JUnit and Mockito

📋 Prerequisites

• Java 21 or higher
• Maven 3.6 or higher
• SQLite 3

🗃️ Database Schema

The application uses an SQLite database with the following schema:

CREATE TABLE task (
    id INTEGER PRIMARY KEY,
    name VARCHAR(255),
    category VARCHAR(255),
    status VARCHAR(255)
);

📚 Sample Data

The application comes pre - loaded with the following sample task data:

• Complete project documentation writing (Documentation, PENDING)
• Fix login issues (Bug Fix, IN_PROGRESS)
• Add new features (Development, PENDING)
• Review pull requests (Code Review, PENDING)
• Update dependencies (Maintenance, COMPLETED)
• Write unit tests (Testing, IN_PROGRESS)
• Build CI/CD pipeline (DevOps, PENDING)
• Optimize database queries (Performance, NOT_STARTED)
• Create API documentation (Documentation, PENDING)
• Conduct security audit (Security, NOT_STARTED)

📄 API Interfaces

1. Find tasks by task name
2. Find tasks by category
3. Create a new task (with default status)

🚀 Quick Start

1. Clone the repository:

git clone https://github.com/yourusername/TasksMcpServer.git
cd TasksMcpServer

2. Build the project:

mvn clean package

3. Start the application:

java -jar target/TasksMcpServer-0.0.1-SNAPSHOT.jar

📁 Project Structure

TasksMcpServer/
├── src/
│   ├── main/
│   │   ├── java/
│   │   │   └── com/example/TasksMcpServer/
│   │   │       ├── model/
│   │   │       │   └── Task.java
│   │   │       ├── repository/
│   │   │       │   └── TaskRepository.java
│   │   │       ├── service/
│   │   │       │   └── TasksMcpServerService.java
│   │   │       └── TasksMcpServerApplication.java
│   │   └── resources/
│   │       ├── application.properties
│   │       └── insert.sql
│   └── test/
│       └── java/
│           └── com/example/TasksMcpServer/
│               └── service/
│                   └── TasksMcpServerServiceTest.java
├── pom.xml
└── README.md

⚙️ Configuration

The application can be configured via the src/main/resources/application.properties file:

spring.datasource.url=jdbc:sqlite:tasks.db
spring.datasource.driver-class-name=org.sqlite.JDBC
spring.jpa.database-platform=org.hibernate.community.dialect.SQLiteDialect
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

🧪 Testing

Run tests using Maven:

mvn test

📦 Dependencies

• Spring Boot 3.4.4
• Spring Data JPA
• SQLite JDBC Driver
• Hibernate Community Dialect
• Spring Boot Test
• JUnit 5
• Mockito

📄 License

This project is licensed under the MIT license. Please refer to the LICENSE file for details.

🤝 Contribution Guidelines

1. Fork the repository
2. Create a feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a pull request