💻 Coding &amp; Development Prompts

SQL & Database Intermediate

SQL Query - Complex Joins and Aggregation

Write SQL queries for a database with tables: orders (id, customer_id, order_dat...

#coding #SQL #joins

React Intermediate

React Component with Hooks

Build a React component for a searchable, filterable product list. Features: 1) ...

#coding #React #hooks

#coding #API #error handling

Backend Intermediate

API Error Handling Best Practices

Show me how to implement proper error handling for a REST API in [Node.js/Python...

#database design #schema #SQL

Database Advanced

Database Schema Design from Requirements

Act as a senior database architect. Design a normalized database schema based on...

Tools & Workflow Beginner

Git Workflow Cheat Sheet

Create a comprehensive Git cheat sheet organized by task: 1) Setup (init, clone,...

#coding #Git #cheat sheet

#coding #Docker #docker-compose

DevOps Advanced

Docker Compose for Full Stack App

Write a docker-compose.yml for a full stack application with: 1) Frontend (React...

#JWT #authentication #refresh tokens

Backend Advanced

Authentication System with JWT and Refresh Tokens

Build a complete authentication system with JWT access tokens and refresh tokens...

#coding #rate limiter #Redis

Backend & APIs Advanced

Rate Limiter Middleware with Redis for Express.js

Build a production-ready rate limiting middleware for an Express.js API using Re...

api testing Intermediate

ChatGPT prompt for generating API integration test cases from docs

Act as a QA engineer focused on API integrations. I will give you API documenta...

#coding #api #testing

#code review checklist #pull request checklist #software quality

code review Intermediate

ChatGPT prompt for code review checklist before merging feature branch

Act as a senior engineer preparing a code review checklist for a feature branch ...

Python Intermediate

REST API with Flask

Build a simple REST API using Python Flask with these endpoints: 1) GET /items -...

#coding #Python #Flask

DevOps & Automation Advanced

Python Script to Monitor Website Uptime and Send Alerts

Write a Python script that monitors website uptime and sends alerts when a site ...

#coding #Python #uptime monitoring

#coding #bug report #issue ticket

bug triage Beginner

ChatGPT prompt for turning bug reports into a developer-ready issue ticket

Act as a product manager preparing issues for engineering. I will give you a me...

#python #unit tests #pytest

testing Intermediate

ChatGPT prompt for generating Python unit tests for an existing function

Act as a senior Python test engineer who follows best practices for pytest. I h...

api-design Advanced

REST API Design for a SaaS Product with Auth

Design a RESTful API for a [SaaS product type, e.g., project management app] wit...

#coding #api #rest

#unit testing #test suite #code quality

Testing Intermediate

Unit Test Suite Generator

Write a comprehensive unit test suite for the following code. Use [testing frame...

#CI/CD #GitHub Actions #deployment

DevOps Advanced

CI/CD Pipeline Configuration with GitHub Actions

Create a complete CI/CD pipeline using GitHub Actions for my project: - Project...

Frontend & UI Intermediate

Responsive Dashboard Layout with CSS Grid and Dark Mode Toggle

Create a responsive admin dashboard layout using only HTML and CSS (no framework...

#coding #CSS Grid #dashboard

api troubleshooting Advanced

ChatGPT prompt for debugging a flaky API integration in production

You are a senior backend engineer helping diagnose a flaky API integration in pr...

#debug api integration #production bug #troubleshooting prompt

#refactor duplicate code #clean code #software design

refactoring Intermediate

ChatGPT prompt for refactoring duplicated business logic safely

Act as a senior software engineer reviewing duplicated business logic across mul...