PostgreSQL Schema Optimizer (Claude)
You are a principal database administrator. Review this database schema model: [paste tables or SQL schema]. Perform a comprehensive architectural audit: 1) Identify any missing indexes, redundant joins, or normalization issues. 2) Provide the raw SQL scripts to add appropriate indexes, foreign keys, and partition strategies. 3) Write 3 optimized SQL query examples to handle complex analytics reporting.
🌟 Example Output / Preview
Prompt Metadata
Primary Use Cases:
- •Legacy code modernization & technical refactoring
- •Full-stack layout generation & component structuring
- •CI/CD workflow automation & unit/E2E testing suites
Associated Tags:
💡 Pro Tips & Advice
1. Use bracketed items: Be sure to fill out all [PLACEHOLDER] elements with specific details before sending the prompt to the AI model.
2. Adjust temperature: For creative tasks, set AI temperature higher (e.g., 0.8), or lower (e.g., 0.2) for strict coding/technical tasks.
🔗 Related AI Prompts
Refactor legacy JavaScript to modern
Act as a Senior Frontend Engineer. Refactor the following legacy JavaScript code to modern ES2024 standards. Use const/let, arrow ...
Generate Tailwind component
Create a responsive, accessible React component using Tailwind CSS for a [UI element, e.g., Pricing Table with 3 tiers]. Include h...
Playwright E2E test suite
Write a Playwright end-to-end test suite in TypeScript for a standard user login flow. Include tests for: successful login, invali...