Prompt Library

Design normalized, performant database schemas with proper relationships, indexes, and constraints for relational databases.

Write comprehensive unit tests that cover happy paths, edge cases, error conditions, and boundary values for any function or module.

Recommend and explain the right statistical tests and methods for any analysis question, with clear assumptions and interpretation guidance.

Analyze and optimize SQL queries for better performance, readability, and maintainability with specific indexing and restructuring recommendations.

Build and explain regular expressions for any text matching need, with clear documentation of what each part does.

Perform thorough, constructive code reviews for Python code that improve quality, catch bugs, and enforce best practices.

Create comprehensive, well-organized FAQ pages and documents that answer real customer questions with clear, scannable answers.

Conduct thorough exploratory data analysis with statistical summaries, visualizations, and actionable insights from raw datasets.

Create optimized Dockerfiles and CI/CD pipeline configurations for reliable, secure, and fast builds.

Suggest clean code improvements that improve readability, maintainability, and performance while preserving behavior.

Create clear, comprehensive REST API documentation that developers can follow to integrate quickly and confidently.

Design rigorous A/B tests and analyze results with proper statistical methods including sample size calculation and significance testing.