Project Guardian Mcp Server

Project Guardian MCP

A focused Model Context Protocol (MCP) server designed as your project's memory system and workflow guardian. This server provides streamlined database operations and advanced knowledge graph capabilities for intelligent project management, with exactly 17 tools, 10 resources, and 28 prompts to maintain clarity and focus.

Table of Contents

• [Features](#features)
• [Project Guardian Memory System](#project-guardian-memory-system)
• [Streamlined Database Operations](#streamlined-database-operations)
• [AI Guidance System](#ai-guidance-system)
• [Advanced Features](#advanced-features)
• [Enterprise Features](#enterprise-features)
• [Requirements](#requirements)
• [Installation](#installation)
• [Available Tools](#available-tools)
• [Database Operations (7 tools)](#database-operations-7-tools)
• [Project Guardian Memory Tools (10 tools)](#project-guardian-memory-tools-10-tools)
• [AI Guidance System](#ai-guidance-system)
• [Available Resources](#available-resources)
• [Available Prompts](#available-prompts)
• [How AI Models Use Guidance](#how-ai-models-use-guidance)
• [Usage Examples](#usage-examples)
• [Project Guardian Setup](#project-guardian-setup)
• [Project Management Workflow](#project-management-workflow)
• [Database Operations](#database-operations)
• [Configuration](#configuration)
• [For Cursor IDE](#for-cursor-ide)
• [For Claude Desktop](#for-claude-desktop)
• [Project Structure](#project-structure)
• [Development](#development)
• [License](#license)

Features

Project Guardian Memory System

• Knowledge Graph: Maintain project entities, relationships, and observations
• Entity Management: Projects, tasks, people, resources with rich metadata
• Relationship Mapping: Dependencies, ownership, blockers, and connections
• Observation Tracking: Contextual notes and progress updates
• Semantic Search: Full-text search across all project knowledge
• Memory Persistence: Automatic persistence in SQLite database

Streamlined Database Operations

• Single Database: Uses only memory.db for all operations
• Core CRUD: Essential database operations (query, insert, update, delete)
• SQL Execution: Direct SQL query execution
• Data Transfer: Import/export CSV and JSON files
• 17 Tools Total: Focused toolset for maximum clarity

AI Guidance System

• 10 Resources: Templates, best practices, cached data, and comprehensive project status
• 27 Prompts: Comprehensive pre-built workflows for all aspects of project management
• Expert Guidance: Step-by-step instructions for complex operations
• Contextual Help: Adaptive prompts based on user needs
• Knowledge Base: Comprehensive project management wisdom

Advanced Features

• Schema Validation: Comprehensive input validation with Zod schemas
• Error Handling: Detailed error messages and graceful failure handling
• Connection Management: Automatic connection pooling and cleanup
• File Integration: Seamless integration with filesystem operations
• Performance: Optimized for large datasets and batch operations

Enterprise Features

• TypeScript: Fully typed with comprehensive error handling
• Input Validation: Zod schema validation for all parameters
• Error Recovery: Graceful error handling with detailed error messages
• Resource Management: Automatic cleanup of connections and resources
• Testing: Comprehensive Jest test suite with high coverage

Requirements

• Node.js: >= 18.0.0
• npm: Latest stable version
• SQLite3: Automatically installed as dependency

Installation

1. Clone the repository:

git clone https://github.com/1999AZZAR/project-guardian-mcp-server.git
cd project-guardian-mcp-server

1. Install dependencies:

npm install

1. Build the project:

npm run build

1. Test the server:

npm start

Available Tools

This MCP server provides exactly 17 focused tools for project guardianship:

Database Operations (7 tools)

execute_sql - Execute SQL Query

Execute raw SQL queries on memory.db.

Parameters:

• query (required): SQL query string
• parameters (optional): Query parameters array

query_data - Query Table Data

Query data from memory.db tables with filtering and pagination.

Parameters:

• table (required): Table name
• conditions (optional): WHERE conditions object
• limit (optional): Maximum rows to return
• offset (optional): Number of rows to skip
• orderBy (optional): Column to sort by
• orderDirection (optional): Sort direction ("ASC" or "DESC")

insert_data - Insert Records

Insert records into memory.db table.

Parameters:

• table (required): Table name
• records (required): Array of record objects to insert

update_data - Update Records

Update records in memory.db table.

Parameters:

• table (required): Table name
• conditions (required): WHERE conditions for records to update
• updates (required): Fields to update

delete_data - Delete Records

Delete records from memory.db table.

Parameters:

• table (required): Table name
• conditions (required): WHERE conditions for records to delete

import_data - Import Data

Import data from CSV or JSON file into memory.db table.

Parameters:

• table (required): Target table name
• filePath (required): Path to source file
• format (optional): File format ("csv" or "json")
• options (optional): Import options (delimiter, hasHeader)

export_data - Export Data

Export memory.db table data to CSV or JSON file.

Parameters:

• table (required): Source table name
• filePath (required): Output file path
• format (optional): Output format ("csv" or "json")
• conditions (optional): WHERE conditions to filter export
• options (optional): Export options (delimiter, includeHeader)

Project Guardian Memory Tools (10 tools)

initialize_memory - Initialize Memory System

Set up the project memory database schema and tables.

Parameters: None

create_entity - Create Project Entities

Create entities in the project knowledge graph (supports single or batch).

Parameters:

• entities (required): Array of entity objects
• name: Entity name
• entityType: Type (project, task, person, resource)
• observations: Array of notes about the entity

create_relation - Create Entity Relationships

Create relationships between project entities (supports single or batch).

Parameters:

• relations (required): Array of relation objects
• from: Source entity name
• to: Target entity name
• relationType: Relationship type (depends_on, blocks, owns, etc.)

add_observation - Add Entity Observations

Add observations/notes to project entities (supports single or batch).

Parameters:

• observations (required): Array of observation objects
• entityName: Target entity name
• contents: Array of observation strings to add

delete_entity - Delete Project Entities

Remove entities and their relations from project memory (supports single or batch).

Parameters:

• entityNames (required): Array of entity names to delete

delete_observation - Remove Entity Observations

Remove specific observations from entities (supports single or batch).

Parameters:

• deletions (required): Array of deletion objects
• entityName: Target entity name
• observations: Array of observation strings to remove

delete_relation - Delete Entity Relationships

Remove relationships between project entities (supports single or batch).

Parameters:

• relations (required): Array of relation objects to delete
• from: Source entity name
• to: Target entity name
• relationType: Relationship type to delete

read_graph - Read Project Knowledge Graph

Retrieve the entire project knowledge graph with all entities and relationships.

Parameters: None

search_nodes - Search Project Knowledge

Search for entities and relations matching a query across names, types, and content.

Parameters:

• query (required): Search term

open_node - Get Entity Details

Retrieve detailed information about project entities (supports single or batch).

Parameters:

• names (required): Array of entity names to retrieve

AI Guidance System

Project Guardian MCP includes comprehensive resources and prompts to help AI models effectively use the toolset for project management.

Available Resources

Project Guardian provides 10 key resources that AI models can read to understand project management concepts, access cached data, and get comprehensive project insights:

project-guardian://templates/entity-types

Standard entity types for project management with examples and usage guidelines.

project-guardian://templates/relationship-types

Common relationship types between project entities with practical examples.

project-guardian://templates/project-workflows

Standard workflows for using Project Guardian tools in different scenarios.

project-guardian://templates/best-practices

Comprehensive best practices guide for effective project knowledge management.

project-guardian://status/current-graph

Current state of the project knowledge graph with summary statistics.

project-guardian://cache/recent-activities

Recently performed project management activities and updates for tracking progress.

project-guardian://cache/workflow-templates

Frequently used workflow templates with examples and implementation guidance.

project-guardian://metrics/project-stats

Statistical overview of project entities, relationships, and activities with health metrics.

project-guardian://cache/team-members

Cached information about project team members and their roles within the organization.

project-guardian://status/recent-changes

Recent additions, updates, and modifications to the knowledge graph for audit and monitoring.

Available Prompts

Project Guardian offers 28 specialized prompts covering all aspects of comprehensive project management, from basic setup to advanced enterprise workflows:

Core Project Management

project-setup - Project Initialization

Arguments:

• project_name (required): Name of the project
• team_members (optional): Comma-separated list of team members

Provides step-by-step guidance for setting up a new project structure with appropriate entities and relationships.

sprint-planning - Sprint Planning

Arguments:

• sprint_name (required): Name/number of the sprint
• duration_days (optional): Sprint duration in days

Guides through comprehensive sprint planning including task breakdown, dependencies, and capacity planning.

progress-update - Progress Tracking

Arguments:

• task_name (required): Name of the task to update
• progress_notes (required): Progress update description

Structured process for updating task progress and managing dependencies.

retrospective - Project Retrospective

Arguments:

• time_period (required): Time period being reviewed (e.g., "last sprint", "Q1")

Comprehensive retrospective process including data analysis, pattern identification, and improvement action creation.

Quality & Process Management

code-review - Code Review Process

Arguments:

• pull_request_title (required): Title of the pull request being reviewed
• reviewer_name (optional): Name of the reviewer

Structured code review process with technical checklists, issue documentation, and approval workflows.

bug-tracking - Bug Management

Arguments:

• bug_description (required): Description of the bug or issue
• severity_level (optional): Critical, High, Medium, or Low severity

Complete bug tracking workflow from discovery to resolution with impact analysis and stakeholder communication.

technical-debt-assessment - Technical Debt Analysis

Arguments:

• component_name (required): Name of the component or codebase being assessed
• assessment_scope (optional): Scope of assessment (file, module, system)

Comprehensive technical debt identification, prioritization, and remediation planning.

Release & Deployment Management

release-planning - Release Planning

Arguments:

• release_version (required): Version number for the release (e.g., "v2.1.0")
• release_date (optional): Target release date

Complete release planning process including quality gates, risk assessment, and deployment coordination.

Risk & Change Management

risk-assessment - Risk Management

Arguments:

• risk_description (required): Description of the risk
• impact_level (optional): High, Medium, or Low impact

Complete workflow for documenting risks, identifying impacts, and developing mitigation strategies.

change-management - Change Control

Arguments:

• change_description (required): Description of the proposed change
• impact_assessment (optional): High, Medium, or Low impact assessment

Structured change management process with impact analysis, approval workflows, and implementation tracking.

Team & Resource Management

team-productivity - Productivity Analysis

Arguments:

• timeframe (required): Time period to analyze (week, month, quarter)
• focus_area (optional): Area to focus on (velocity, quality, collaboration)

Team productivity assessment with performance metrics, root cause analysis, and improvement planning.

resource-allocation - Resource Planning

Arguments:

• resource_type (required): Type of resource (human, infrastructure, budget)
• planning_horizon (optional): Planning timeframe (sprint, quarter, year)

Resource allocation optimization with capacity planning, gap analysis, and utilization tracking.

Documentation & Communication

stakeholder-communication - Communication Management

Arguments:

• communication_type (required): Type of communication (statusupdate, issuealert, milestone_reached)
• audience (optional): Target audience (team, management, client, all)

Stakeholder communication planning and execution with audience-specific strategies and effectiveness tracking.

documentation-management - Documentation Updates

Arguments:

• documentation_type (required): Type of documentation (api, userguide, technicalspec)
• update_reason (optional): Reason for documentation update

Documentation maintenance process with content planning, review workflows, and publishing coordination.

Requirements & Planning Management

requirements-gathering - Requirements Gathering

Arguments:

• requirement_type (required): Type of requirements (functional, non-functional, business, technical)
• stakeholders (optional): Comma-separated list of key stakeholders

Guides through comprehensive requirements gathering process with stakeholder management and requirement categorization.

user-story-management - User Story Management

Arguments:

• feature_name (required): Name of the feature or epic
• user_role (optional): Primary user role (e.g., "customer", "admin", "developer")

Structured process for creating, managing, and prioritizing user stories with acceptance criteria and dependencies.

Quality & Technical Management

testing-strategy - Testing Strategy Development

Arguments:

• application_type (required): Type of application (web, mobile, api, desktop)
• criticality_level (optional): Business criticality (critical, high, medium, low)

Comprehensive testing strategy development including automated testing, quality gates, and risk-based testing.

security-assessment - Security Assessment

Arguments:

• assessment_scope (required): Scope of security assessment (application, infrastructure, data)
• compliance_requirements (optional): Comp

…

Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: 1999AZZAR
• Source: 1999AZZAR/project-guardian-mcp-server
• License: MIT

Install and usage instructions live in the source repository linked above.