LLM/prompt for coding

Spec to Code

Autogen migration from mermaid chart in a markdown file

• Result: not entirely reliable
• Agent: AnythingLLM
• Model: Gemma 4 E4B

Prompt

Please read docs/MAINSYS_DB.md, and generate DDL.
This DDL must satisfy the following rules:

- with "COMMENT ON" syntax for each table
- with "COMMENT ON" syntax for each column
- with "ADD CONSTRAINT" syntax for each foreign key

When DDL satisfied the 3 rules above.

- find the latest *.up.sql in assets\migrations
- write this DDL
- find the latest *.down.sql in assets\migrations
- write reverse DDL

Risks

• Table name order conflict with SQL syntax.