Powers the REST API for project and task management, handling HTTP requests and routing for the application
Provides database storage for project and task management data, allowing persistent storage and retrieval of project information through Prisma ORM
Provides ORM capabilities for database operations, enabling type-safe database queries and migrations for the project tracker
Implements caching functionality for the project tracker API, improving performance for frequently accessed project and task data
Project Tracker API with MCP Integration
A TypeScript-based REST API for project and task management with MCP (Model Context Protocol) integration.
👨💻 Author
Jatinder (Jay) Bhola - Engineering Leader & Tech Lead
- 🏠 Location: Toronto, ON, Canada
- 🎯 Expertise: Cloud-Native & Event-Driven Architectures, Building Scalable Systems
- 🔗 Connect: GitHub | LinkedIn
"Engineering leader with 10+ years of experience improving developer workflows and scaling cloud-native systems. Proven track record in leading and delivering high-impact, customer-facing platforms and empowering engineering teams to build fast, resilient web applications."
Technology Stack
- Node.js 18+ with TypeScript
- Express.js framework
- PostgreSQL with Prisma ORM
- Redis for caching
- Zod for validation
- Jest for testing
- Swagger/OpenAPI for documentation
- MCP SDK for agent integration
Project Structure
Architecture Overview
Getting Started
Quick Setup (Recommended)
For the interviewer or anyone who wants to get everything running quickly:
This will:
- ✅ Install all dependencies
- ✅ Start PostgreSQL and Redis services
- ✅ Create databases and run migrations
- ✅ Seed test data
- ✅ Build the project
- ✅ Run tests to verify everything works
- ✅ Create environment configuration
After setup, run the demo to see all features:
Manual Setup
If you prefer to set up manually:
- Clone the repository
- Install dependencies:
- Initialize the database:
- Seed test data:
- Build the project:
- Start the development server:
- Test MCP Integration:
Database Configuration
Environment Variables
Create a .env
file with the following variables:
Setting Up Test Database
- Create Test Database:
- Run Migrations on Test Database:
- Verify Setup:
🤖 MCP Integration
For detailed MCP documentation and architecture, see docs/ASSESSMENT_DEMONSTRATION.md.
Available Scripts
Development
npm run dev
- Start development server with hot reloadnpm run build
- Build for productionnpm start
- Start production servernpm run format
- Format code with Prettiernpm run lint
- Run ESLint [TODO]
Database Management
npm run prisma:generate
- Generate Prisma clientnpm run prisma:migrate
- Run database migrationsnpm run prisma:studio
- Open Prisma Studio for main databasenpm run prisma:studio:test
- Open Prisma Studio for test databasenpm run prisma:studio:main
- Open Prisma Studio for main database
Testing
npm test
- Run all testsnpm run test:unit
- Run unit tests onlynpm run test:integration
- Run integration tests onlynpm run test:coverage
- Run tests with coverage reportnpm run test:watch
- Run tests in watch modenpm run test:setup
- Create test databasenpm run test:reset
- Reset test database (drop, recreate, migrate)npm run test:verify-env
- Verify environment variables
MCP Integration
npm run mcp:start
- Start MCP servernpm run mcp:debug
- Start MCP server in debug modenpm run mcp:test
- Run unified MCP testsnpm run mcp:inspector
- Start MCP Inspector for interactive testing
Testing
Test Architecture
The project uses a comprehensive testing setup with:
- Unit Tests: Test individual service methods and business logic
- Integration Tests: Test API endpoints and database interactions
- Test Utilities: Centralized test data builders and assertions
- Date Utils: Centralized date conversion utilities for consistent testing
Test Configuration
- Separate Test Database: Prevents accidental data loss
- Redis Isolation: Uses separate Redis database for tests
- Environment Detection: Automatic test environment setup
- Clean Test Data: Automatic cleanup between tests
Running Tests
Test Utilities
The test suite includes centralized utilities:
- TestData: Builders for creating test projects and tasks
- Assertions: Common assertion helpers for date comparisons
- MockUtils: Utilities for mocking cache and service calls
- TestEnv: Environment detection and configuration
Test Database Management
API Documentation
Once the server is running, visit /api/docs
for the Swagger documentation with organized endpoints:
- Projects: CRUD operations for project management
- Tasks: CRUD operations for task management
Security and TODOs
Read more about the MUST HAVE security integration
License
Code has been produced with the help of Claude IDE
ISC
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
A TypeScript-based REST API that integrates project and task management with MCP (Model Context Protocol), allowing users to manage projects and tasks through natural language interactions.
Related MCP Servers
- AsecurityAlicenseAqualityA TypeScript Model Context Protocol server that integrates with Google Tasks API, allowing users to create, list, update, delete, and toggle completion status of tasks.Last updated -45JavaScriptMIT License
- AsecurityAlicenseAqualityAn MCP server implementation that integrates with Backlog API, enabling project management operations including issues, projects, and wikis through natural language interactions.Last updated -12533TypeScriptMIT License
- -securityAlicense-qualityAI-driven task management application that operates via MCP, enabling autonomous creation, organization, and execution of tasks with support for subtasks, priorities, and progress tracking.Last updated -2PythonMIT License
- -securityAlicense-qualityA Model Context Protocol server providing comprehensive task management capabilities with support for project organization, task tracking, and automatic PRD parsing into actionable items.Last updated -19PythonMIT License