Slow queries found and fixed before users notice
Agents connect to your production database to monitor performance — identifying slow queries, suggesting index optimizations, flagging anomalies, and tracking storage trends. Proactive database health management, fully automated.
What you get
Queries exceeding your threshold identified and profiled — with execution plans, frequency, and impact on overall performance.
Specific CREATE INDEX statements with expected impact — not vague advice, but ready-to-run SQL you can apply immediately.
Bloat percentages, dead tuple counts, and vacuum frequency — keeping your tables lean and queries fast.
Utilization trends, peak usage patterns, and leak detection — so you never hit your connection limit unexpectedly.
Growth trends and capacity planning alerts — know exactly when you'll hit thresholds, months before it becomes an emergency.
Schedule it daily. The agent connects to your database, runs a full health check, and drops the report in Slack — catching problems before your users ever notice.
> Analyzing slow query log
Top 5 offenders
> Suggesting 3 index optimizations with expected impact
Table health
> Checking table bloat
> Monitoring connection pool
> Checking disk usage
> Generating health report
✓ Full health report generated
✓ 3 index optimization suggestions ready
✓ Alerts posted to #ops on Slack
For CRHQ clients
Enable the required skills
Make sure these skills are active on your satellite:
Tell the agent what to monitor
Example prompt:
Schedule daily checks (recommended)
Use the schedule skill to run this health check every day at a low-traffic hour. The agent catches slow queries, bloat, and capacity issues before they impact users — and you get a report in Slack every morning.
Get more out of this workflow
Schedule daily for continuous monitoring
A single health check is useful. Daily health checks are transformational. Schedule the agent to run every night and you'll have a complete history of your database's performance trends — catching degradation early and validating the impact of your optimizations.
scheduleCombine with Sentry to correlate DB performance with app errors
Wire the agent to check Sentry alongside your database. When a slow query spikes, the agent cross-references it with application errors and timeouts — giving you the full picture of how database performance impacts your users.
sentryStore historical metrics in project documents for trend analysis
Tell the agent to log each health check's key metrics to project documents. Over weeks and months, this builds a performance history that makes it easy to spot gradual degradation, seasonal patterns, and the real impact of schema changes.
manage-project-documentsUse manage-external-servers for deeper investigation
When the agent finds something that needs more than a query to diagnose, the manage-external-servers skill gives it direct server access. Check OS-level metrics, review PostgreSQL configs, inspect log files, or run pg_stat_statements analysis — all without you SSHing in.
manage-external-servers