Questions it can answer
- Which recommendations are open on the orders database, and what is the fix for the first one? The answer carries the SQL, its risks and its rollback.
- Was anything waiting on locks last night? Incidents come with their level and how long statements waited.
- Which transactions stayed open while writing? Each one with how long it was open and the application name.
- Do my connection pools fit the server’s connection limit?
- Why is this query slow? A pasted query or EXPLAIN plan is analyzed exactly as in the chat box and uses your monthly allowance the same way.
How to connect
Claude, ChatGPT and Claude Desktop take the server URL from Settings → AI assistants, then ask you to sign in and choose Allow. Cursor and Claude Code use a key you create on the same screen; it works only for AI assistants, not for the dbtempo CLI. The docs article below has the steps and the config to paste.
What the assistant cannot do
- Apply a recommendation, approve a change waiting for review, or write to a database.
- See another account. It sees only your account.
- Read statement text, logins or process ids from the lock and transaction tools, or a database host, a port or a credit count from any tool.
- Keep your data from its own provider. What the assistant reads is sent to the company behind it, so connect only an assistant you already trust with this data.
Answers that say what they did not see
Durations are a minimum. An empty list means nothing was seen only when recording was on for the whole window; the coverage tool says when it was not, and why. Lock and transaction recording stays off until you turn it on for a database.