approve-database

Lock and validate Database Diagram transitioning from draft to approved state.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Lock and validate the Database Diagram as part of the approval workflow, transitioning from DATABASE_DRAFT to DATABASE_APPROVED.

Core Features & Use Cases

  • Verifies Mermaid erDiagram compiles to ensure diagram integrity.
  • Checks that every relationship in SoW Section 3 has a matching entity in Section 2.
  • Updates session-memory/SESSION-STATE.md and appends an audit log upon approval.
  • Enforces stage-gate to prevent progression until all quality checks pass.

Quick Start

Review the draft and run /approve-database to lock the diagram and advance the workflow.

Frequently Asked Questions about approve-database

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

FAQPage Schema
How do I validate a Mermaid erDiagram before final approval?▼

Validating a Mermaid erDiagram before final approval requires checking diagram integrity and confirming every SoW relationship matches a defined entity. The approval workflow enforces these stage-gate quality checks to prevent progression from draft to approved.

What is the best way to lock a database diagram and update the audit log?▼

Locking a database diagram and updating the audit log occurs by finalizing the DATABASE_DRAFT stage. This transitions the session state to DATABASE_APPROVED while appending a secure audit log entry recording the diagram validation.

Why does my database diagram workflow stage fail to progress to approved?▼

Your database diagram workflow fails to progress to approved when quality gate conditions are unmet. The stage-gate enforces relationship coverage and Mermaid erDiagram compilation, prompting resolution of any integrity errors before retrying.

How do I check if SoW relationships have matching entities in my database diagram?▼

Checking SoW relationships against database diagram entities is handled automatically during the approval workflow. The validation process cross-references Section 3 relationships against Section 2 entities to ensure complete coverage before locking.

Does the database approval workflow update session memory state automatically?▼

The database approval workflow updates session memory state automatically upon successful validation. It modifies SESSION-STATE.md to reflect the transition from DATABASE_DRAFT to DATABASE_APPROVED and appends a corresponding audit log.

When do I need to enforce a stage-gate in a database diagram workflow?▼

Enforcing a stage-gate in a database diagram workflow is needed when finalizing the DATABASE_DRAFT stage. It ensures diagram integrity, validates relationship coverage, and prevents progression until all quality gate conditions successfully pass.