Canonical: https://botbento.com/usecases/database-performance-and-query-health-auditor/
Format: Markdown representation of the public HTML page.

[Home](/) / [Use cases](/usecases/) / [Operations](/usecases/?category=ops)

Operations · Advanced

# Database performance and query health auditor

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

[Use with BotBento ](https://app.botbento.com/?ref=usecases&utm_source=botbento.com&utm_medium=usecases&utm_campaign=database-performance-and-query-health-auditor)Copy promptShare[Markdown](/text/usecases/database-performance-and-query-health-auditor/index.md)

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

- On a scheduleDaily query telemetry audit
- ThenAnalyze slow logs and explain plans
- 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.
```

Copy

## Tools it uses

DatabaseSlackTerminal

## Works with

BotBento

## Tags

- database
- dba
- sql
- performance
- devops

## Source

[Show HN: DeepSQL – A self-hostable DBA agent for Postgres and MySQL](https://news.ycombinator.com/item?id=48980286)
Hacker News · checked 2026-10-15

Summarized in our own words. Any results described there are the authors’ own, not measured by BotBento.

By BotBento Editorial · Added 2026-10-15 · Updated 2026-10-15 · [Suggest a correction](/contact/)

## Related use cases

-

Operationsadvanced

## [Coding Agent Model Routing and Cost Optimizer](/usecases/coding-agent-model-routing-and-cost-optimizer/)

Direct development agent prompts to suitable language models based on task complexity and budget

TerminalGitHubDatabaseSlack
-

Operationsintermediate

## [Governed text-to-SQL and analytics reporting](/usecases/governed-text-to-sql-and-analytics-reporting/)

Translate natural language business questions into vetted SQL queries and visual data reports.

DatabaseTerminalChat
-

Operationsintermediate

## [Monitoring multi-step deployment workflows](/usecases/monitoring-multi-step-deployment-workflows/)

Track distributed deployment steps, health checks, and failure retries automatically

TerminalGitHubSlackDatabase