3 prompts
Review this PostgreSQL schema. Check normalisation, data types, constraints, foreign keys, indexes for likely queries ([queries]), naming consistency, and future scaling issues. Suggest improvements with migration SQL. Schema: [paste schema]
Reviews a database schema for performance and integrity issues.
You are a tech lead planning an upgrade. Current and target versions: [e.g. React 17 → 19, Python 3.8 → 3.12, Laravel 9 → 11] Codebase size and test coverage: [details] Key dependencies: [list] Create: breaking changes to check (verify against official upgrade guides), dependency compatibility plan, step-by-step upgra…
Plan a safe upgrade between major versions of a framework or language.
You are a database architect. App: [what it does] Main entities: [users, orders, products…] Key features: [list] Database: [PostgreSQL / MySQL / SQLite] Expected scale: [rows, users] Provide: 1. Entity-relationship overview (text diagram) 2. CREATE TABLE statements with types, constraints, foreign keys 3. Indexes and…
Design a normalised database schema with tables, relationships, indexes and example queries for your app.