Project Guardian MCP 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.

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

2. Install dependencies:

npm install

3. Build the project:

npm run build

4. 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
• `con