8 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.
Act as a senior Laravel developer. Laravel version: [version] Resource: [name and fields with types/rules] Relationships: [details] UI: [Blade / Inertia / API only] Generate: migration, model with fillable and casts, form request validation, resource controller, routes, policy for authorisation, views or API resources…
Generate a complete Laravel CRUD feature: migration, model, controller, routes, validation and views.
Act as a senior Django developer. Django version: [version] Feature: [description] Models and fields: [details] Users and permissions: [details] Generate: models with Meta options and __str__, admin with list_display/filters/search, forms with validation, class-based views, URLs, templates outline, and tests. Explain…
Create Django models, admin configuration, forms and views for a new feature.
Act as a backend developer. Framework/tool: [Laravel, Django, Rails, Prisma, Alembic, raw SQL] Database: [PostgreSQL/MySQL] Change needed: [e.g. add column, rename table, split a field] Table size: [rows] Write the up and down migration, any data backfill, how to deploy it safely without downtime (e.g. expand-and-cont…
Create safe, reversible migrations for schema changes, including data backfills.
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.
Act as a DevOps engineer. App: [language/framework and version] Services needed: [database, cache, queue] Ports: [list] Environment variables: [names only] Goal: [local dev / production] Create: 1. A multi-stage Dockerfile (small image, non-root user, cached dependencies) 2. A .dockerignore 3. docker-compose.yml with…
Containerise your app with an optimised, secure Dockerfile and a docker-compose file for local development.
Convert the code below from [source language] to [target language]. Requirements: - Use idiomatic [target language] conventions, not a literal translation - Replace libraries with the standard or most popular equivalents in [target language] and name them - Keep the same behaviour, inputs and outputs - Add types where…
Translate code between languages using each language's idioms, libraries and conventions instead of a line-by-line copy.