Using Claude with DBTrail

After Claude Setup, ask in plain words.

You: Generate SQL to recover the deleted order 1042.

Claude: Here's the recovery SQL (dry-run). Review before executing:

BEGIN;
INSERT INTO `production`.`orders` (`order_id`, `customer`, `amount`, `status`)
VALUES (1042, 'acme-corp', 299.00, 'active');
COMMIT;

Better questions

• Name the server when you have several.
• Give a time range: "since the deploy at 2pm yesterday".
• Name the event type and table: "only DELETEs in mydb.orders".
• Ask for first or last: "the first DELETE after 14:00" returns oldest first without scanning everything.

Limits

• Reads the index only: no SQL execution, no data changes, no starting or stopping streams.
• No rate limits of its own.
• Who made a change (MySQL user, host, program) is not answered; the index keeps each change's raw connection_id.