prompt

Database Query Performance Analyzer

Break down slow queries and suggest indexing, query rewrites, and schema optimizations with execution plan analysis.

Updated June 2026
The prompt
Optimize this {{database_type}} query that is executing in {{execution_time}}ms. Analyze the execution plan and dataset size:

{{slow_query}}

Table schemas:
{{table_schemas}}

Suggest: (1) index strategy, (2) query rewrite, (3) schema adjustments. Prioritize by {{optimization_goal}}.
Did it work? Rate this prompt

Variables

Database System (PostgreSQL, MySQL, MongoDB)
The slow query
Relevant table definitions
Current execution time in ms
Goal (latency, throughput, resource cost)

Details

Author

AI Khazna

License

—

Security

—

Type

prompt

Related assets

More curated picks in Development & Code.

mcp serverclaude_codecursorcodex
npm install @modelcontextprotocol/server-everything
Everything
Reference / test server that exercises all features of the MCP protocol — prompts, resources, tools.★ 4.9 · 5,000+
mcp serverclaude_codecursorcodex
npm install @modelcontextprotocol/server-memory
Memory
Knowledge graph-based persistent memory system. Lets agents remember facts across conversations.★ 4.9 · 5,000+
mcp serverclaude_codecursorcodex
npm install @modelcontextprotocol/server-filesystem
Filesystem
Secure file operations with configurable access controls. Read, write, list, and search local files.★ 4.9 · 5,000+
mcp serverclaude_codecursorcodex
npm install @modelcontextprotocol/server-git
Git
Tools to read, search, and manipulate Git repositories — log, diff, blame, branches, and more.★ 4.9 · 5,000+
mcp serverclaude_codecursorcodex
npm install @modelcontextprotocol/server-fetch
Fetch
Web content fetching and conversion server for efficient LLM usage. Retrieves and converts URLs to clean markdown.★ 4.9 · 5,000+
mcp serverclaude_codecursorcodex
npm install @modelcontextprotocol/server-sequentialthinking
Sequential Thinking
Dynamic problem-solving through structured thought sequences with branching, revision, and reflection.★ 4.9 · 5,000+

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

Automated Web Security Scan

security

PageSpeed Analyzer

performance

AI Content Quality Test

arabic content

AI Agent / MCP Server Tester

ai testing

Site Stack Detector

migration

AI SEO / AEO / GEO Audit

ai visibility

llms.txt Generator

ai visibility

Readability Score

arabic content

Schema / JSON-LD Builder

ai visibility

AI Cost Calculator

ai testing

Headline Analyzer

arabic content

More in Development & Code