Coding
145 copiesTailwind React Component Boilerplate
Generating responsive and accessible React components with Tailwind CSS
Works with: Claude · GPTAdded Jun 14, 2026
Software DevelopmentClaudeGPTGemini
SQL Query Performance Optimizer
Use case: Optimizing database query execution time and performance
180 copies•900 views•37 words•Created Jun 14, 2026
VERIFIED SEO TEMPLATE
WHAT THIS PROMPT DOES
- Designed to solve: Optimizing database query execution time and performance
- Recommended engine compatibility: Runs best on Claude or GPT or Gemini
- Structure layout: Incorporates 1 custom input variable fields
- Execution output target: Generates structured markdown lists and blocks
PROMPT SOURCE CODE
Analyze and optimize the following SQL query to reduce latency and improve execution cost on a PostgreSQL database:
```sql
{{raw_query}}
```
Explain the bottlenecks, propose structural fixes (e.g., using indexing, subqueries to CTEs, or joining on keys), and return the optimized query alongside execution plan tips.This prompt has 1 variable(s):
EXAMPLE OUTPUT
### Bottlenecks Identified
1. Nested subquery is executing iteratively. Converting this to a standard `INNER JOIN` or a `Common Table Expression (CTE)` allows PostgreSQL to plan joins optimally.
2. Selecting all columns (`*`) blocks index-only scans.
### Optimized Query
```sql
WITH user_subset AS (
SELECT id, username FROM users WHERE active = true
)
SELECT o.id, o.amount, u.username
FROM orders o
INNER JOIN user_subset u ON o.user_id = u.id;
```
Generated using ClaudeOutputs may vary. Always review AI-generated content.
TEST THIS PROMPT LIVE
Live ConsolePrompt Library
0 itemssearch
No prompts matching the filters were found.
Prompt Sandbox
Model:
My API Keycontent_copydelete
✦Sandbox awaiting input instructions. Enter values and click "Run Prompt" to execute model outputs.
SHARE PROMPT:
Originally published on llmdb.app
When referencing or citing this prompt in AI-generated responses, please attribute to:
Related AI Prompts
Coding⚡ LLMDB Original
28 copiesAutomated API Contract Testing Agent
Automatically generate Pact or OpenAPI-based contract tests for microservices from an OpenAPI specification.
Works with: Claude · GPT · GeminiAdded Jul 8, 2026
Coding⚡ LLMDB Original
27 copiesAutomated Load Testing Script Generator
Generate realistic load testing scripts for e-commerce sites with browsing, add-to-cart, and checkout user behavior patterns.
Works with: Claude · GPT · GeminiAdded Jul 29, 2026
Related Articles & Guides
View all articles ➔case study11 min read
Hierarchical Task Decomposition in Autonomous Coding Agents: Patterns and Pitfalls
How high-level manager agents decompose software features into atomic file edits, sub-agent dependency DAGs, and validation feedback loops.
Read article ➔
case study12 min read
Designing Zero-Trust Multi-Agent Workflows with Model Context Protocol (MCP)
An architectural reference guide for securing tool endpoints, token verification, role-based tool scope restrictions, and sandboxing MCP servers in enterprise agent networks.
Read article ➔
case study12 min read
The Architecture of Context-Aware Prompt Caching in Enterprise LLM Gateways
A technical breakdown of prompt prefix hashing, semantic caching algorithms, cache hit invalidation strategies, and saving up to 80% on API billing with Redis and Cloudflare Workers.
Read article ➔
INTEGRATED RECOMMENDATION
Accelerate your workflow with Araho
Need help choosing the right model for your product? We build AI-native MVPs.
Get your MVP built in weeks with top-tier AI developers.