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.