How do I install the Pm DB skill?

Run npx skillmds@latest add artsmc/pm-db in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Pm DB safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: executes scripts. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Pm DB?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Pm DB free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

artsmc (@artsmc) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Pm DB by artsmc — Agent Skill

Name: Pm DB
Rating: 4.5 (4 reviews)
Author: artsmc

File contents

Pm Db

Converted Claude skill workflow for Codex/OpenAI use.

Source

Converted from skills/pm-db/SKILL.md.

Bundled Resources

Supporting files copied from the Claude source:

references/ACCEPTANCE_CRITERIA_VERIFICATION.md
references/API_REFERENCE.md
references/DEVELOPMENT.md
references/DOCUMENTATION_REVIEW.md
references/README.md
references/SECURITY_AUDIT.md
references/USER_GUIDE.md
scripts
assets/tests
assets/migrations
assets/prisma/schema.prisma

Converted Instructions

The content below was adapted from the Claude source. Rewrite tool and runtime assumptions as needed when they refer to Claude-only features.

Codex Adaptation Notes

The helper scripts in scripts/ and SQL migrations in assets/migrations/ are the primary portable parts of this skill.
The original Claude setup used hooks for automatic tracking, but Codex does not run those automatically.
Use this skill for explicit database setup, import, migration, and reporting tasks. Treat hook references as optional application integration work.

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: ~/.codex/projects.db

Hook Sources

The original Claude setup used hook scripts for automatic tracking, but they are not native Codex behavior.

Schema

See assets/migrations/ for the vendored SQL schema and assets/prisma/schema.prisma for the Prisma schema snapshot.

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

---name: pm-dbdescription: Project management database for tracking specs, jobs, tasks, and execution. Use when Codex should run the converted pm-db workflow. Inputs: command.---# Pm DbConverted Claude skill workflow for Codex/OpenAI use.## SourceConverted from `skills/pm-db/SKILL.md`.## Bundled ResourcesSupporting files copied from the Claude source:- `references/ACCEPTANCE_CRITERIA_VERIFICATION.md`- `references/API_REFERENCE.md`- `references/DEVELOPMENT.md`- `references/DOCUMENTATION_REVIEW.md`- `references/README.md`- `references/SECURITY_AUDIT.md`- `references/USER_GUIDE.md`- `scripts`- `assets/tests`- `assets/migrations`- `assets/prisma/schema.prisma`## Converted InstructionsThe content below was adapted from the Claude source. Rewrite tool and runtime assumptions as needed when they refer to Claude-only features.## Codex Adaptation Notes- The helper scripts in `scripts/` and SQL migrations in `assets/migrations/` are the primary portable parts of this skill.- The original Claude setup used hooks for automatic tracking, but Codex does not run those automatically.- Use this skill for explicit database setup, import, migration, and reporting tasks. Treat hook references as optional application integration work.# pm-db SkillManage the project management database for tracking specifications, jobs, tasks, code reviews, and execution logs.## Available Commands### `init` - Initialize DatabaseCreates the projects.db database and runs all migrations.```bash$pm-db init$pm-db init --reset # Backup existing and create fresh database```### `import` - Import SpecificationsImports specifications from job-queue folders.```bash$pm-db import$pm-db import --project auth # Filter by project name```### `dashboard` - Show DashboardDisplays project management dashboard with metrics.```bash$pm-db dashboard$pm-db dashboard --format json$pm-db dashboard --format markdown```### `migrate` - Run MigrationsApplies pending database migrations.```bash$pm-db migrate$pm-db migrate --dry-run$pm-db migrate --target-version 2```### `backup` - Backup DatabaseCreates a timestamped backup of the database (not yet implemented).```bash$pm-db backup```## Examples```bash# 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 LocationDefault: `~/.codex/projects.db`## Hook SourcesThe original Claude setup used hook scripts for automatic tracking, but they are not native Codex behavior.## SchemaSee `assets/migrations/` for the vendored SQL schema and `assets/prisma/schema.prisma` for the Prisma schema snapshot.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

Frequently asked questions

Pm DB