pm-db

pm-db Skill

Manage the project management database for tracking specifications, jobs, tasks, code reviews, and execution logs.

Available Commands

init - Initialize Database

Creates the projects.db database and runs all migrations.

/pm-db init
/pm-db init --reset  # Backup existing and create fresh database

import - Import Specifications

Imports specifications from job-queue folders.

/pm-db import
/pm-db import --project auth  # Filter by project name

dashboard - Show Dashboard

Displays project management dashboard with metrics.

/pm-db dashboard
/pm-db dashboard --format json
/pm-db dashboard --format markdown

migrate - Run Migrations

Applies pending database migrations.

/pm-db migrate
/pm-db migrate --dry-run
/pm-db migrate --target-version 2

backup - Backup Database

Creates a timestamped backup of the database (not yet implemented).

/pm-db backup

Examples

# First-time setup
/pm-db init

# Import all specs
/pm-db import

# View dashboard
/pm-db dashboard

# Export to JSON
/pm-db dashboard --format json

Database Location

Default: ~/.claude/projects.db

Hooks

The pm-db system includes automatic hooks:

• on-job-start - Creates job record when /start-phase begins
• on-task-start - Creates task record when task starts
• on-tool-use - Logs every command execution
• on-code-review - Stores code review summaries
• on-task-complete - Marks task complete
• on-agent-assign - Records agent assignments

Schema

See migrations/ for complete database schema.

Tables:

• projects - Top-level projects
• specs - Specifications (FRD, FRS, GS, TR, task-list)
• jobs - Execution jobs
• tasks - Individual tasks within jobs
• code_reviews - Code review results
• execution_logs - Command execution logs
• agent_assignments - Agent work assignments