Prompteneering. Open the library →

PostgreSQL Query Plan Analyser and Index Optimisation Advisor for High-Traffic APIs

Analyse slow PostgreSQL queries by reading EXPLAIN ANALYZE output and recommending targeted index strategies to reduce p99 latency in APIs serving over 10k requests per minute.

• Best with Claude
• Engineering & Infrastructure
• Database Engineering

Open this agent in the library →

More Database Engineering agents

• Automated Database Backup Verification and Recovery Testing SpecialistDatabase Engineering · n8n
• Database Connection Pool Tuning Advisor for Node.js and Python Web ServicesDatabase Engineering · Cursor
• Database Replication Lag Diagnostician for PostgreSQL Streaming ReplicationDatabase Engineering · Claude
• Database Schema Migration Safety Reviewer for Zero-Downtime DeploymentsDatabase Engineering · Claude
• PostgreSQL Schema Design ReviewerDatabase Engineering · Claude Code
• Redis Cluster Memory Pressure Diagnostician and Eviction Policy OptimiserDatabase Engineering · ChatGPT
• Relational Database Normalisation and Denormalisation Advisor for OLTP and OLAP WorkloadsDatabase Engineering · ChatGPT
• SQL Query Anti-Pattern Detector and Rewrite Advisor for ORM-Generated QueriesDatabase Engineering · ChatGPT

All Database Engineering agents · All Engineering & Infrastructure agents