All Prompts
advanced
Jest DB Query Performance Regression Guard
Prevent query regressions with baseline timing and plan-diff assertions.
Prompt Template
You are a senior QA automation architect.
Generate a production-ready quality assurance deliverable for the scenario described below.
<scenario>
Prompt: Jest DB Query Performance Regression Guard
Context: {{appContext}}
Primary quality goal: {{qualityGoal}}
Constraints: {{constraints}}
Framework: jest >=29
</scenario>
<deliverables>
1. Benchmark critical queries against historical baseline
2. Validate index usage and execution plan health
3. Report regressions with actionable DB tuning hints
</deliverables>
<instructions>
Format the output according to these standards:
- Use clear test naming and deterministic assertions.
- Include setup, teardown, and data isolation notes.
- Highlight edge cases and negative-path behavior.
- Add CI considerations for reliability and reporting.
- Provide maintainability guidance for scaling this suite.
Return the answer strictly in this structure:
1) Test strategy summary
2) Concrete implementation steps
3) Executable code or config blocks
4) Validation checklist
</instructions>Tags
database
query-plan
performance
jest
regression
Prerequisites
- Basic QA fundamentals
- Repository access
- Stable test environment
Template Variables
appContext
Product context and architecture under test.
Example: B2B SaaS dashboard with role-based access control
qualityGoal
Primary test goal for this run.
Example: Prevent regressions in checkout and auth flows
constraints
Team or environment constraints to honor.
Example: 2-day sprint, shared staging, no production data