review-database

Apply stage-gated section edits to the Database Diagram with audit logging.

Updated Apr 26, 2026
One-click install
npx skills add https://github.com/aoecosystem/project-foundations --skill review-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: review-database
Source: https://github.com/aoecosystem/project-foundations/tree/main/.cursor/skills/review-database
Command: npx skills add https://github.com/aoecosystem/project-foundations --skill review-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides an interactive, section-by-section editor for the Database Diagram, enforcing stage gates and preserving an audit trail to ensure consistent, reviewed changes.

Core Features & Use Cases

  • Stage-gated edits: edit one diagram section at a time (Schema Overview, Entity Definitions, Relationships, Indexes Strategy, Migration & Versioning, ERD — Visual) with inline diffs and saved history.
  • Session-state awareness: reads SESSION-STATE.md to enforce Draft/Approved states and to warn that re-opening from Approved reverts to Draft.
  • Audit-friendly workflow: automatically bumps versions and appends audit logs on each save, ensuring traceability for reviews and approvals.
  • Show section menu & in-memory edits: present a clear menu of six sections and apply changes in memory while preserving formatting.
  • Diff-driven saves: provide a diff summary before committing updates to disk and state.
  • Loop or hand off: continue editing or lock the change via /approve-database to proceed to the next pipeline stage.

Quick Start

Invoke /review-database, select a section, apply your changes, and save to create an audited update.

Frequently Asked Questions about review-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I review database diagram changes section by section with an audit trail?▼

Review database diagram changes section by section with an audit trail by applying controlled edits within a gated workflow, ensuring consistency and traceability. The skill enforces stage gates, presents a six-section menu, and records an audit log on each save.

What is stage-gated editing for an ERD visual diagram?▼

Stage-gated editing for an ERD visual diagram is a workflow mechanism that restricts modifications to specific sections until current changes are saved. It enforces DATABASE_DRAFT or DATABASE_APPROVED states to ensure reviewed and traceable database schema updates.

Can I track schema migration versioning and entity definitions with inline diffs?▼

Yes, you can track schema migration versioning and entity definitions with inline diffs. The skill provides a diff summary before committing updates to disk and automatically bumps versions on each save to preserve history.

How do I re-open an approved database diagram for further edits?▼

To re-open an approved database diagram, you trigger a transition from the DATABASE_APPROVED stage back to DATABASE_DRAFT. The skill reads SESSION-STATE.md to warn that re-opening from Approved reverts the diagram to Draft status.

Does the database review workflow support indexing strategy and relationship definitions?▼

Yes, the database review workflow supports indexing strategy and relationship definitions through its six-section menu. You can select and apply changes to these specific sections individually while preserving formatting and maintaining an audit log.

What happens if I modify an entity definition without an approved draft state?▼

Modifying an entity definition without an approved draft state is prevented by the stage gate enforcement. The skill reads SESSION-STATE.md to verify the current workflow stage, blocking updates that do not meet the required draft or approved conditions.