prompt
Database Index Strategist
Recommend optimal indexing strategy based on query patterns and table size.
Updated June 2026
The prompt
Design an indexing strategy for: Table: {{table_name}} Schema: {{schema_description}} Access patterns: {{query_patterns}} Data volume: {{row_count}} rows Provide: 1. Index recommendations (column combinations, type) 2. Expected query improvement estimates 3. Write performance trade-offs 4. Maintenance overhead (statistics, fragmentation) 5. SQL examples showing index usage Consider {{db_type}} specifics.
Did it work? Rate this prompt
Variables
Table nameColumn definitions and typesCommon queries and filtersApproximate row countDatabase type (PostgreSQL, MySQL, etc.)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