Skip to main content
Glama

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.

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

project-tracker-api/ ├── src/ │ ├── controllers/ # API route handlers │ ├── services/ # Business logic layer │ ├── models/ # Database models/schemas │ ├── middleware/ # Validation, error handling │ ├── utils/ # Helper functions and date utilities │ ├── mcp/ # MCP server implementation │ ├── config/ # Database and app configuration │ └── test/ # Test setup and utilities ├── prisma/ # Database schema and migrations ├── docs/ # API documentation and setup guides └── scripts/ # Setup and seed scripts

Architecture Overview

Architecture System Diagram

Getting Started

For the interviewer or anyone who wants to get everything running quickly:

# One-command setup (recommended) 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
  • ✅ Create environment configuration

After setup, run the demo to see all features:

# Start the API server in one terminal npm run dev # Run the demo in another terminal npm run demo

Manual Setup

If you prefer to set up manually:

  1. Clone the repository
  2. Install dependencies:
    npm install
  3. Initialize the database:
    # Create databases createdb taskflow createdb taskflow_test # Generate Prisma client npm run prisma:generate # Run migrations npm run prisma:migrate
  4. Seed test data:
    node scripts/seed-test-data.js
  5. Build the project:
    npm run build
  6. Start the development server:
    npm run dev
  7. Test MCP Integration:
    # Test MCP server npm run mcp:test # Interactive testing with MCP Inspector npm run mcp:inspector

Database Configuration

Environment Variables

Create a .env file with the following variables:

# Main database DATABASE_URL="postgresql://username:password@localhost:5432/taskflow" # Test database (separate from main) TEST_DATABASE_URL="postgresql://username:password@localhost:5432/taskflow_test" # Redis configuration REDIS_URL="redis://localhost:6379/0" TEST_REDIS_URL="redis://localhost:6379/1" # Optional: Use main database for tests (not recommended for production) USE_MAIN_DB_FOR_TESTS=false

Setting Up Test Database

  1. Create Test Database:
    createdb taskflow_test
  2. Run Migrations on Test Database:
    TEST_DATABASE_URL="postgresql://localhost:5432/taskflow_test" npx prisma migrate deploy
  3. Verify Setup:
    npm run test:verify-env

🤖 MCP Integration

For detailed MCP documentation and architecture, see docs/ASSESSMENT_DEMONSTRATION.md.

Available Scripts

Development

  • npm run dev - Start development server with hot reload
  • npm run build - Build for production
  • npm start - Start production server
  • npm run format - Format code with Prettier
  • npm run lint - Run ESLint [TODO]

Database Management

  • npm run prisma:generate - Generate Prisma client
  • npm run prisma:migrate - Run database migrations
  • npm run prisma:studio - Open Prisma Studio for main database
  • npm run prisma:studio:test - Open Prisma Studio for test database
  • npm run prisma:studio:main - Open Prisma Studio for main database

Testing

  • npm test - Run all tests
  • npm run test:unit - Run unit tests only
  • npm run test:integration - Run integration tests only
  • npm run test:coverage - Run tests with coverage report
  • npm run test:watch - Run tests in watch mode
  • npm run test:setup - Create test database
  • npm 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 server
  • npm run mcp:debug - Start MCP server in debug mode
  • npm run mcp:test - Run unified MCP tests
  • npm 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

# Run all tests npm test # Run specific test suites npm run test:unit npm run test:integration # Debug environment setup npm run test:verify-env

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

# Quick setup npm run test:setup # Reset test database npm run test:reset # Verify environment npm run test:verify-env

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

Install Server
A
security – no known vulnerabilities
F
license - not found
A
quality - confirmed to work

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.

  1. 👨‍💻 Author
    1. Technology Stack
      1. Project Structure
        1. Architecture Overview
          1. Getting Started
            1. Quick Setup (Recommended)
            2. Manual Setup
          2. Database Configuration
            1. Environment Variables
            2. Setting Up Test Database
          3. 🤖 MCP Integration
            1. Available Scripts
              1. Development
              2. Database Management
              3. Testing
              4. MCP Integration
            2. Testing
              1. Test Architecture
              2. Test Configuration
              3. Running Tests
              4. Test Utilities
              5. Test Database Management
            3. API Documentation
              1. Security and TODOs
                1. License

                  Related MCP Servers

                  • 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
                  • 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
                    53
                    3
                    TypeScript
                    MIT License
                  • -
                    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
                    • Linux
                  • -
                    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 -
                    19
                    Python
                    MIT License
                    • Linux
                    • Apple

                  View all related MCP servers

                  MCP directory API

                  We provide all the information about MCP servers via our MCP API.

                  curl -X GET 'https://glama.ai/api/mcp/v1/servers/jatinderbhola/mcp-taskflow-tracker-api'

                  If you have feedback or need assistance with the MCP directory API, please join our Discord server