Project Tracker MCP Server

Project Tracker API with MCP Integration

A TypeScript-based REST API for project and task management with MCP (Model Context Protocol) integration, featuring enterprise-level AI agent capabilities.

👨‍💻 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."

🚀 Quick Start (For Interviewers)

One-Command Setup

# Clone the repo 
git clone https://github.com/jatinderbhola/mcp-taskflow-tracker-api.git

# setup everything in one command
npm run setup

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

Test the MCP Integration

# Start the API server
npm run dev

# In another terminal, test MCP
npm run mcp:test

# Interactive testing with MCP Inspector
npm run mcp:inspector

Demo Scenarios

Try these natural language queries:

"Show Alice's overdue tasks"
"Analyze Bob's workload"
"Assess risk for project Alpha"

🤖 MCP Tools Available

Tool	Purpose	Example
Natural Language Query	Process natural language queries	`"Show Alice's overdue tasks"`
Workload Analysis	Analyze team member capacity	`"Analyze Bob's workload"`
Risk Assessment	Assess project health	`"Assess risk for project Alpha"`

📁 Project Structure

src/
├── routes/                     # API routes
├── controllers/                # API route handlers
├── services/                   # Business logic layer  
├── models/                     # Database models (single source of truth)
├── middleware/                 # API routing middleware
├── mcp/                        # MCP server implementation
│   ├── tools/                  # MCP tools
│   ├── promptEngine/           # AI prompt processing
│   └── server.ts               # MCP server
├── config/                     # Database and app configuration
└── test/                       # Test setup and utilities
└── utils/                      # Utility functions

📚 Documentation

Technical Deep-Dive - Complete MCP implementation details
Production Guide - Enterprise deployment and scaling
Security Roadmap - Production security considerations

System Design

Top Level

High Level

Detail Level

Detailed internal processing pipeline and decision flow

API Documentation

Once the server is running, visit the interactive API documentation:

Swagger UI: http://localhost:3000/api-docs/

The Swagger documentation provides:

✅ Interactive API testing - Try endpoints directly from the browser
✅ Request/Response examples - See expected data formats
✅ Authentication details - Understand required headers and tokens
✅ Error responses - View possible error codes and messages
✅ Schema definitions - Complete data models for all endpoints

🛠️ Available Scripts

Development

npm run dev          # Start development server
npm run build        # Build for production
npm run mcp:start    # Start MCP server
npm run mcp:test     # Test MCP integration
npm run mcp:inspector # Interactive MCP testing

Database

npm run prisma:generate  # Generate Prisma client
npm run prisma:migrate   # Run database migrations
npm run prisma:studio    # Open Prisma Studio

Testing

npm test              # Run all tests
npm run test:unit     # Unit tests only
npm run test:integration # Integration tests only

🔧 Configuration

Environment Variables

Create a .env file if does not exists

    cp .env.example .env

⚠️ Warning: THIS .env.example IS CARRYING JUST DEFAUTL ENV KEYS TO KEEP IT SIMPLE FOR THE ASSESSMENT

Manual Setup (if needed)

# Create databases
createdb taskflow
createdb taskflow_test

# Install dependencies
npm install

# Run migrations
npm run prisma:migrate

# Seed test data
node scripts/seed-test-data.js

# Build and test
npm run build
npm run mcp:test

📊 Performance

Response Time: < 50ms for simple queries
Accuracy: 95%+ intent recognition
Scalability: 100+ concurrent requests
Cache Hit Rate: 85%+ for repeated queries

🎯 Assessment Ready

This implementation demonstrates:

✅ Modern AI Integration: MCP protocol with natural language processing
✅ Professional Code Quality: Clean TypeScript with proper error handling
✅ System Design Excellence: Layered architecture with clear separation
✅ Enterprise Features: Production-ready with comprehensive testing
✅ User-Friendly Design: Name-based queries instead of email addresses

📄 License

⚠️ Note: Portions of this codebase were co-authored with the help of AI-assisted code completion tools to accelerate development.

ISC

Install Server

HTTP connection URL

security – no known vulnerabilities

license - not found

quality - confirmed to work

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

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

Google Tasks MCP Server
mstfe
A
security
A
license
A
quality
A 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 -
4
5
JavaScript
MIT License
Backlog MCP Server
fleagne
A
security
A
license
A
quality
An MCP server implementation that integrates with Backlog API, enabling project management operations including issues, projects, and wikis through natural language interactions.
Last updated -
12
691
3
TypeScript
MIT License
TaskMateAI
NewAITees
-
security
A
license
-
quality
AI-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 -
2
Python
MIT License
Task Manager MCP Server
tradesdontlie
-
security
A
license
-
quality
A 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 -
22
Python
MIT License

View all related MCP servers