Index Advisor

GPTClaudeGemini··▲ 1,377 copies·updated 2026-07-14

index-advisor.prompt

# Postgres Index Advisor

Use this prompt to create optimal indexes.

---

## 🧠 Prompt

Suggest optimal indexes for this query/table. Include:

- Index type  
- Why it's needed  
- Expected performance gain  

**Query & Table Schema:**

when to use it

Community prompt sourced from the open-source GitHub repo garlichck/chatgpt-prompt-for-software-engineer (MIT). A "Index Advisor" style prompt — adapt the placeholders and specifics to your task. Imported as-is and not independently retested here, so check the output before relying on it.