Search: "legacy code"

#sql optimization #query tuning #performance

ChatGPT Prompt for Refactoring a Slow SQL Query Without Breaking Results

Help me refactor a slow SQL query so it runs faster without changing the busines...

#code review #debugging #quality

Coding Advanced

Code Review Assistant

Review this code for: bugs, security issues, performance optimizations, code sty...

#code review #security #performance

coding intermediate

Code Review Checklist: Security, Performance, and Maintainability

Create a comprehensive code review checklist for [language: Python/JavaScript/Ty...

#A/B testing #statistical analysis #hypothesis testing

data advanced

A/B Test Results Analysis: Statistical Significance and Reporting

Help me analyze the results of an A/B test I ran: Experiment name: [name], Test ...

#technical documentation #API docs #developer guide

writing Advanced

Technical Documentation Writing Guide: Developer API Docs Template

Help me write professional technical documentation for [software/API/system]. I ...

#rust #error handling #result

Rust Error Handling Result Option Patterns Idiomatic Code

You are a Rust mentor. Teach me idiomatic error handling for [PROJECT TYPE — CLI...

#code review #pull request #software engineering

ChatGPT Prompt: Code Review Checklist Tailored to PR Diff Analysis

Review this pull request diff and provide structured feedback. [PASTE DIFF OR F...

#database migration #schema change #postgres

ChatGPT Prompt: Database Migration Plan with Rollback Strategy

Design a safe database migration plan for [SCHEMA CHANGE]. Details: - Database:...

#design #design-systems #components

design Advanced

Component Library Naming Convention and Folder Structure

Propose a naming convention and folder structure for a Figma + code component li...

#coding #review #feedback

Write Idiomatic Code Review Feedback

Review my pull request and write feedback that's specific, actionable, and kind....

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#code review checklist #pull request checklist #software quality

ChatGPT prompt for code review checklist before merging feature branch

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

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

excel Advanced

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

#python #web scraping #beautifulsoup

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

#coding #react #typescript

React Component with TypeScript and Custom Hook

Build a React component in TypeScript for a [component type, e.g., paginated dat...

#FastAPI #JWT #authentication

coding intermediate

Python FastAPI REST API Authentication JWT

Build a production-ready FastAPI REST API with JWT authentication. Requirements:...

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

excel advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

#api #documentation #technical-writing

writing advanced

Technical Documentation Writing Guide for API Reference

Write comprehensive API reference documentation for [API endpoint or feature]. I...

#software-contract #ip #agreement

legal advanced

Software Development Agreement Key Clauses Checklist

Create a checklist of key clauses to include and negotiate in a software develop...

excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#data #machine-learning #model-evaluation

data advanced

Machine Learning Model Evaluation and Selection Framework

You are a machine learning engineer and data scientist. I need to evaluate and s...