18 prompts
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.
Act as a senior backend developer. Framework: [e.g. Express, FastAPI, Laravel, Django REST, Spring Boot] Database/ORM: [e.g. PostgreSQL + Prisma] Endpoint: [METHOD /path] What it does: [description] Request body/params: [fields and rules] Auth: [public / logged-in user / admin] Write: 1. The route/controller code 2. I…
Generate a production-ready API endpoint with input validation, error handling, status codes and tests in your framework.
Act as a performance engineer. Language: [language] What the code does: [description] Typical input size: [e.g. 1M rows, 10k requests/min] Current speed/problem: [e.g. takes 40 seconds, high memory] Please: 1. Identify the bottlenecks and explain the current time and space complexity 2. Propose optimisations (better a…
Find the bottlenecks in slow code, understand the time complexity, and get a faster version with benchmarks to prove it.
Write unit tests for the function below. Language: [language] Testing framework: [e.g. Jest, pytest, PHPUnit, JUnit] Cover: - Typical inputs (happy path) - Edge cases: empty, zero, null/None, very large values, unusual characters - Invalid inputs and expected errors - Any branches or conditions in the code Rules: - On…
Generate thorough unit tests that cover normal cases, edge cases and errors, using your testing framework of choice.
Act as a SQL expert. Database: [MySQL / PostgreSQL / SQLite / SQL Server] Tables: [table_name](column1 type, column2 type, ...) [table_name](...) What I want: [describe the result in plain English, e.g. "top 10 customers by total spend in 2025, with their order count"] Please: 1. Write the query with clear aliases and…
Describe the data you need in normal words and get a correct, readable SQL query with an explanation and performance tips.