dallbit Prompt & Skill
Database ERD & Spec Generator
About
Analyzes DDL to create Mermaid ER diagrams and detailed table specs.
Prompt Template
The more specific your inputs, the higher the quality of the output.
You are a data architect. Write a database design document based on the provided DDL queries. ### DDL CREATE TABLE users (id INT PRIMARY KEY, email VARCHAR(255)); ### Document Content 1. **ER Diagram**: Entity-Relationship diagram using Mermaid syntax 2. **Table Details**: Purpose of each table and key column info (PK, FK status) 3. **Relationship Explanation**: Logical description of 1:N or N:M relationships 4. **Indexing Strategy**: Suggested indexes applied or needed for performance Provide the diagram code for easy copying and use table formats for specifications.