Database incident diagnosis brief: AI agent prompt
Turn blocking chains, wait stats, and slow-query clues into a root-cause brief with a recommended fix and a ready-to-assign ticket, like Cornerstone OnDemand's Orion AI multi-agent system on Amazon Bedrock that cut database diagnosis from 45 minutes to 10.
IT & Internal HelpDatabase opsintermediateThe prompt
Diagnose this database incident. Symptoms: [paste what users/SRE reported]. Metrics and waits: [paste blocking sessions, wait types, CPU, long-running queries, timestamps]. Recent changes: [paste deploys, schema changes, or unknown]. Produce: (1) most likely root cause and why, (2) what to rule out next, (3) a safe first remediation step vs anything that needs approval (e.g. killing a session), (4) a filled ticket draft: title, severity, evidence, owner team, and acceptance check. If data is incomplete, list exactly what to query next instead of guessing.
How to use it
- Copy the prompt above.
- Replace every [bracket] with your own details (or fill in the blanks on AgentPlaybook Real Estate, which remembers your answers for the next prompt).
- Paste it into ChatGPT, Claude, Gemini and review the answer before you use it.
Works with: ChatGPT, Claude, Gemini, Amazon Bedrock, your SQL monitoring/export, Jira
Real-world example: aws.amazon.com/blogs/machine-learning/how-cornerstone-ondemand-cut-dat
Featured in: AI prompts to summarize meetings, notes, documents and reports
Before you use it: what to check
Already built into this prompt
- Produce: (1) most likely root cause and why, (2) what to rule out next, (3) a safe first remediation step vs anything that needs approval (e.g.
Check yourself
- This prompt works on text other people wrote (emails, reviews, messages or web pages). That text can hide instructions aimed at AI, such as "ignore your rules and…". Paste it as material to work on, and never let the AI act on requests inside it, like paying, sharing logins or changing records. How prompt injection works →
- Check names, dates, numbers and any claim against your own source material before you use the answer. AI can misread or invent details.
Using an AI agent? Download this prompt as a SKILL.md agent skill with these checks built in, or get the .zip for Claude.ai. How to install skills.
Want to make this prompt even better? Grade it with the free prompt grader or build your own with the AI prompt generator.
32 copy-paste agent prompts (PDF) plus 5 new prompts every week.
Get it freeMore IT & Internal Help prompts
See all IT & Internal Help prompts →