Operations · Advanced

Database performance and query health auditor

Monitor relational databases, surface slow queries, and draft index optimizations for engineering review

Use with BotBento Markdown

Opens BotBento. Paste the prompt into a bot; nothing is preconfigured.

  1. On a scheduleDaily query telemetry audit
  2. ThenAnalyze slow logs and explain plans
  3. ResultPost optimization brief for review

Continuously inspect query logs and schema definitions to identify performance bottlenecks, locking issues, and missing indexes. Receive periodic diagnostic summaries and recommended schema modifications directly in your team communication channel without applying structural changes automatically.

Prompt to start with

BotBentoRecommended
Analyze database telemetry, slow query logs, and schema definitions on a routine schedule. Flag sequential scans, high-latency joins, and schema bloat. Draft recommended index additions or query rewrites with estimated impact. Never execute DDL changes, alter table structures, drop objects, or send messages to team channels without explicit human confirmation.