Slow query diagnosis
Prompts that reason about access paths, cardinality and scans.
24 curated prompts
SQL Prompts
SQL prompts should produce reviewable reasoning, not a single opaque query. These templates ask for the diagnosis, the rewrite options, their trade-offs, and the evidence behind each recommendation.
SQL promptsAI SQL promptsquery optimization prompts
Correctness and joins
Templates for detecting wrong joins, duplicates and NULL handling bugs.
Migration safety
Prompts that flag locking, backfill and rollback concerns.
Featured AI prompt templates
Copy-ready prompts selected from this topic cluster.
TextData Analysis
CSV Data Quality Profiler
Profiles CSV and spreadsheet data before trusting it for analysis, imports, or dashboards, infers column types, measures missing values, duplicates, mixed types, outliers, whitespace, and encoding issues, and generates a prioritized quality report with concrete fixes.
TextCoding
Comprehensive Codebase Auditor
Exhaustively analyze entire codebase to identify, classify, and prioritize all verifiable bugs, security vulnerabilities, and critical issues.
CodeCoding
SQL Assistant
Senior database engineer and SQL expert supporting query writing, schema design, optimization, and architecture across multiple databases.
TextCoding
Terraform/OpenTofu Infrastructure as Code Specialist
Manages infrastructure code as production-grade software, emphasizing versioning, testing, and rollback capabilities. Enforces strict response contracts with pre-diagnosis of failure modes.
TextData Analysis
Senior Data Analyst: Translating Data into Business Insights and Actionable Recommendations
Act as a senior data analyst who transforms data into business insights and actionable recommendations. Possess expertise in SQL querying, statistical analysis, A/B testing, funnel analysis, retention metrics, and more. Follow a structured analytical process: question scoping, data validation, methodology selection, statistical rigor, visualization, and action planning. Supports outputs for ad-hoc analysis, metric definition, A/B testing, and cohort analysis.
TextData Analysis
Senior Analytics Engineer Prompt
This prompt defines the role, skills, process, and best practices of a senior analytics engineer building scalable, maintainable data pipelines and analytical systems in production.
TextCoding
Dockerfile Best Practices Reviewer
Reviews Dockerfiles for security, image size, build cache, and runtime reliability, then returns a corrected Dockerfile and .dockerignore.
TextCoding
Act as a Senior Codebase Auditor & Tech Debt Refactorer
Senior Codebase Auditor & Tech Debt Refactorer, focusing on code quality, maintainability, and technical debt auditing.
TextCoding
Codebase Knowledge Graph Architect
Transforms code, databases, infrastructure, and documentation into a structured knowledge graph, identifying architectural key points, dependencies, and design decisions.
TextCoding
Web Quality Auditor
Conducts comprehensive frontend audits covering performance, accessibility, SEO, and best practices. Treats Lighthouse as a diagnostic tool, delivering ruthless, specific, and actionable findings with file references and severity levels.
TextData Analysis
Performance Profiler
Diagnose performance bottlenecks based on observed symptoms and tech stack, then generate a prioritized optimization plan with implementation guidance and validation methodology.
TextData Analysis
Enterprise Data Platform Architecture Design (2026 Standard)
Design a comprehensive, cloud-native data platform for mid-to-large enterprises supporting real-time analytics, AI/ML pipelines, data mesh, and strong compliance across multi-cloud environments.
What context does a SQL prompt need?
Table definitions, indexes, row counts by order of magnitude, and the execution plan or timing you already observed.
Should I paste production data?
No. Use schema plus a few anonymised rows. Never include credentials or personal data.
How do I evaluate the suggested rewrite?
Ask for expected plan changes and a measurement method, then verify against a staging copy before shipping.