Open Database Design Homework Framework

Public-ready framework for running database design assignments with agent help.

Repo now ships reusable pieces only:

• AGENTS.md for repo-wide operating rules
• skills/ for workflow and task instructions
• templates/ for clean assignment scaffolds
• scripts/ for conversion, export, and context utilities

Private coursework and generated outputs belong in workspace/. That directory is local-only and ignored.

Quick Start

1. Copy template:
   • cp -R templates/homework workspace/HW_1
2. Drop assignment files into:
   • workspace/HW_1/materials/src/
3. Ask the agent to follow:
   • skills/homework_pipeline/SKILL.md

Canonical Structure

AGENTS.md
skills/
templates/
scripts/
workspace/            # local-only, ignored

Skills

• skills/homework_pipeline/SKILL.md: end-to-end orchestration
• skills/prepare_materials/SKILL.md: ingest assignment docs and load needed validators
• skills/create_iteration/SKILL.md: build first full draft
• skills/improve_iteration/SKILL.md: grade, evaluate, fix, iterate
• skills/finalize_export/SKILL.md: package final deliverables
• skills/pdf_to_markdown/SKILL.md: convert source docs to markdown
• skills/grader/SKILL.md: score draft against rubric
• skills/er_notation/SKILL.md: validate Chen ER diagrams
• skills/uml_notation/SKILL.md: validate UML class diagrams
• skills/md2pdf_export/SKILL.md: render markdown to HTML/PDF
• skills/ucu_mermaid_to_drawio/SKILL.md: optional Draw.io export for ER diagrams

Local Work Policy

• Keep course PDFs, rubrics, submissions, generated reports, SQL dumps, exports, and private answers under workspace/
• Do not commit workspace/ when publishing a clean public repo
• If old private files already exist in git history, publish from a fresh repo initialized from the cleaned tree

Scripts

• convert_to_markdown.py
• convert_to_markdown.sh
• convert_to_markdown_poppler.sh
• scripts/export_report.sh
• scripts/extract_context_summary.py

Publish Flow

1. Clean tree with only reusable framework tracked.
2. Keep personal work under ignored workspace/.
3. Create a new repo from this sanitized tree.