Real prompts. From real codebases. 5399 patterns to learn from.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Use when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.

Define a PRIMARY KEY for reference tables (users, orders, etc.). Not always needed for time-series/event/log data. When used, prefer BIGINT GENERATED ALWAYS AS IDENTITY; use UUID only when global uniqueness/opacity is needed., Normalize first (to 3NF) to eliminate data redundancy and update anomalies; denormalize only for measured, high-ROI reads where join performance is proven problematic. Prema...

Primary Framework: [React 18.x / Vue 3.x / Angular 15+ / Next.js 14+ / Other], Language: [TypeScript / JavaScript / Other], Styling: [Tailwind CSS / Styled Components / CSS Modules / SCSS / Other], State Management: [Redux Toolkit / Zustand / Jotai / Context API / Other], UI Components: [Custom / Material-UI / Ant Design / Chakra UI / Other], Icons: [Lucide / Heroicons / Font Awesome / Custom SVGs...

Secret rotation patterns and Lambda rotation functions. Rotation Strategies. Single User Rotation. One user, password changes in place. Brief connection interruption during rotation. Alternating Users Rotation. Two users alternate, zero downtime. Built-in Rotation Functions. RDS PostgreSQL. RDS MySQL. Deploy Rotation Lambda. Custom Rotation Lambda. Lambda Structure. API Key Rotation Example. VPC C...

The most comprehensive, practical, and engineer-authored performance optimization instructions for all languages, frameworks, and stacks. Covers frontend, backend, and database best practices with actionable guidance, scenario-based checklists, troubleshooting, and pro tips.