AI Prompts for Developers: Code Faster, Debug Smarter

Design a real-time notification system for a social media app with:
- Tech stack: Node.js, PostgreSQL, Redis, WebSocket
- Scale: 1M daily active users
- Requirements: <100ms delivery, offline queue, read receipts
- Include: architecture diagram (text), database schema, key API endpoints
- Consider: failure modes and graceful degradation

Design a PostgreSQL schema for a multi-tenant SaaS project management tool.
Entities: Organizations, Users, Projects, Tasks, Comments, Attachments
Requirements:
- Row-level security per organization
- Soft deletes on all entities
- Audit trail (created_by, updated_by, timestamps)
- Optimized for: listing tasks by project and assignee
Include indexes and explain your choices.

Write a Next.js API route (App Router) that:
- Accepts POST requests with JSON body: { email, plan, paymentMethodId }
- Validates input with Zod
- Creates a Stripe subscription
- Stores the subscription in a PostgreSQL database using Prisma
- Returns the subscription details
- Handles errors with proper HTTP status codes
- Include TypeScript types for request/response

Create a React component 'DataTable' with TypeScript that:
- Accepts generic data array and column definitions
- Supports sorting (click column headers)
- Supports pagination (10/25/50 per page)
- Supports row selection with checkboxes
- Uses Tailwind CSS for styling
- Follows the compound component pattern
- Is fully accessible (ARIA attributes, keyboard navigation)
Don't use any external table library.

Refactor this code to:
1. Follow SOLID principles
2. Extract reusable utility functions
3. Add proper TypeScript types (no 'any')
4. Improve error handling
5. Add JSDoc comments for public functions
Explain each change and why it improves the code.

[PASTE CODE]

I'm getting this error in production:

Error: ECONNREFUSED 127.0.0.1:5432

Context:
- Node.js 20, Express, PostgreSQL 16, Docker Compose
- Works locally, fails in Docker
- Started after adding a new service to docker-compose.yml
- Database container is running (verified with docker ps)

What's causing this and how do I fix it?

This database query takes 8 seconds on a table with 2M rows:

[PASTE QUERY]

Table schema: [PASTE SCHEMA]
Existing indexes: [LIST]

Analyze the query plan, identify bottlenecks, and suggest:
1. Query optimizations
2. Index recommendations
3. Schema changes if needed
4. Caching strategy

Write tests for this function using Vitest:

[PASTE FUNCTION]

Include:
- Happy path tests (3-5 cases)
- Edge cases (empty input, boundary values)
- Error cases (invalid input, network failures)
- Type checking for TypeScript
- Use describe/it blocks with clear names
- Mock external dependencies
- Aim for >90% branch coverage

Generate a conventional commit message for these changes. Follow the format: type(scope): description

[PASTE DIFF]

Write a GitHub Actions workflow that:
- Triggers on push to main and PRs
- Runs linting (ESLint), type checking (tsc), and tests (Vitest)
- Builds the Next.js app
- Deploys to Vercel on main branch only
- Caches node_modules and .next/cache
- Fails fast if any step errors