💻 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

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...

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

#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...

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

#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...

#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...

technical documentation Intermediate

ChatGPT prompt for documenting a legacy API endpoint before refactoring

Act as a senior software engineer doing archaeology on legacy code. I need to do...

#legacy api documentation #refactor preparation prompt #endpoint behavior mapping

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

Python intermediate

Python FastAPI: Build Production-Ready REST APIs

Act as a senior Python backend engineer experienced with FastAPI. Help me build ...

#coding #python #fastapi

#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...

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

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

#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...

#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 ...