Uses SQLite as the local database backend for storing project management data including organizations, projects, tickets, tasks, and notes with fast querying via WAL mode.
What is this?
tpm-mcp is a local MCP (Model Context Protocol) server that gives Claude the ability to track your projects, features, and tasks. Think of it as having a dedicated TPM who:
Remembers what you're working on across sessions
Breaks down complex features into manageable tasks
Tracks progress and blockers
Gives you instant status updates
All data stays local in a fast SQLite database. No cloud. No subscriptions. Just you and your AI TPM.
Demo
Features
Fast | Sub-millisecond queries with SQLite + WAL mode |
Local | All data in
|
Natural | Just talk - "I finished the auth feature" |
Hierarchical | Orgs → Projects → Tickets → Tasks |
Rich Metadata | Priority, tags, assignees, complexity, notes |
Export/Import | Full JSON export/import for backup and migration |
Installation
1. Clone & Install
2. Add to Claude Code
Add to ~/.claude/settings.json:
3. (Optional) Enable TPM Agent Behavior
For the full experience, add the TPM agent instructions:
Then in your CLAUDE.md:
Usage
Quick Commands
Say this... | Claude will... |
| Show full roadmap |
| Create a new ticket |
| Mark ticket done |
| Create subtasks |
| Show blocked items |
Workflow Example
Tools Reference
Tool | Description |
| Full roadmap with all orgs, projects, tickets, tasks |
| Detailed view of one ticket with its tasks |
| Server stats and database info |
Tool | Description |
| Create ticket with title, description, priority, tags |
| Update status, priority, assignees, etc. |
| List tickets, filter by project or status |
Tool | Description |
| Create task under a ticket |
| Update task status, details, complexity |
| List tasks, filter by ticket or status |
Tool | Description |
| Create organization |
| List all organizations |
| Create project under org |
| List projects |
| Add note to any entity |
Data Model
Ticket Statuses: backlog → planned → in-progress → done | blocked
Task Statuses: pending → in-progress → done | blocked
Priorities: critical > high > medium > low
Export & Import
Export and import your project data to JSON for backup, restore, or interoperability with other tools.
Export Data
Export all your project data to JSON:
Import Data
Import data from a JSON export file to recreate your database or restore from backup:
The JSON format includes all data: organizations, projects, tickets, tasks, notes, and task dependencies. Use cases:
Backup & Restore: Export your data regularly, restore if database gets corrupted
Recreate Database: Start fresh by importing from a previous export
Export to Other Tools: Use the JSON format to migrate to other project management tools
Sync Between Machines: Export on one machine, import on another
PDF Status Reports
Generate beautiful, shareable PDF reports from your project data.
Using the Report Skill
The tpm-report skill teaches Claude how to generate professional status reports. To enable it:
Then ask Claude:
Prerequisites
tpm-mcp: This MCP server (for
roadmap_viewdata)Playwright MCP: For automatic HTML → PDF conversion
Installing Playwright MCP
Add to ~/.claude/settings.json:
Without Playwright, Claude will generate an HTML file you can manually print to PDF.
What's in the Report?
Section | Contents |
Progress Overview | Visual progress bars for tickets and tasks |
Project Breakdown | Completed, in-progress, and backlog items per project |
Key Milestones | Major achievements and current focus |
Blockers & Risks | Items requiring attention |
Manual Report Generation
If you prefer manual control, use roadmap_view with JSON format:
Then use your preferred tool to format the output.
Migration from Legacy Trackers
Coming from a legacy JSON-based tracker with a different format?
This tool converts from older JSON tracker formats. For standard export/import, use tpm-json-export and tpm-json-import above.
Development
Why Local?
Privacy: Your project data never leaves your machine
Speed: SQLite is incredibly fast for this use case
Reliability: No API rate limits, no outages, works offline
Simplicity: One database file, easy to backup or sync
License
MIT - do whatever you want with it.