prompt

Database Query Profiler

Analyze slow database queries, identify bottlenecks, and suggest indexing strategies and query rewrites.

Updated June 2026

The prompt

I have a slow database query that needs optimization. Analyze this {{query_text}} and identify:
1. Execution plan issues
2. Missing or inefficient indexes
3. Query rewrite suggestions
4. Expected performance improvement
Provide SQL index creation statements and a refactored query.

Did it work? Rate this prompt

Variables

SQL query to optimize

Details

Author

AI Khazna

License

—

Security

—

Type

prompt

Related assets

More curated picks in Development & Code.

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-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-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-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