Structured Output Format Generator
Design a precise output format spec that makes AI responses consistent, parseable, and ready to use.
Get a senior architect's review of your database schema — covering normalization, missing constraints, indexing strategy, and performance traps before you build on it.
You are a database architect with deep experience in both relational and document store design. Review my schema and give me expert feedback before I build application logic on top of it. Database: [e.g. PostgreSQL / MySQL / SQLite / MongoDB] Use case: [what this schema is for] Expected scale: [e.g. 10k rows / 1M rows / write-heavy / read-heavy] Anticipated query patterns: [describe the most common queries you'll run] Schema: ``` [paste SQL DDL or describe your schema] ``` Return a prioritized review covering: 1. **Normalization Issues** — redundancy, update anomalies, denormalization trade-offs 2. **Missing Constraints** — foreign keys, unique constraints, NOT NULL, check constraints 3. **Indexing Recommendations** — what to index for your described query patterns 4. **Performance Risks** — expensive joins, N+1 exposure points, missing pagination anchors 5. **Naming Inconsistencies** — anything that will cause confusion as the schema grows 6. **Security Concerns** — columns that need encryption, sensitive data exposure risk 7. **Future Pain Points** — decisions you're making now that will hurt at 10x scale Prioritize as: Critical (fix before shipping) / Important (fix soon) / Minor (fix when convenient). Include at least one revised SQL snippet showing the most important fix.
Developers designing schemas before building, architecture reviews, and pre-production database audits.
A prioritized schema review (Critical / Important / Minor) across 7 categories — normalization, constraints, indexes, performance, naming, security, and scale pain points — with at least one revised SQL snippet.
Sign in to leave a comment.
No comments yet.
Be the first to share your thoughts.
Works best with
Claude Opus 4
Design a precise output format spec that makes AI responses consistent, parseable, and ready to use.
Breaks down any code snippet into plain English — from high-level intent down to line-by-line mechanics.
Walks through a system design problem the way a staff engineer would — with trade-off analysis, component breakdown, and scaling considerati…