PromptVerse
Sign In Join Free

Explore Prompts

Browse and search thousands of community-verified AI prompts

Query: 3.25 ms 1 prompt found
Discovery Velocity
Discovery Engine & Open Prompt Directory

Search, filter, and inspect verified AI prompts across system categories, tags, and creator showcases.

What is this?

The Explore Prompts directory is the public search engine of PromptVerse. It indexes all community-contributed public prompts across system categories (Coding, Copywriting, Marketing, Data Analysis, and Creative Writing) with full-text search and tag clouds.

Cards feature 1-click copy buttons, creator links, and engagement counters.

Why does it exist?

Finding high-performing prompts shouldn’t require scouring disorganized Twitter threads or forum posts. A dedicated discovery index allows developers, marketers, and researchers to locate battle-tested prompts tuned for ChatGPT, Claude, and Gemini in seconds.

It connects practitioners with proven prompt patterns.

How is it beneficial?
  • Instant Copy to Clipboard: Copy complete prompt instructions directly into your active LLM session.
  • Deep Taxonomy Filtering: Drill down by category, tag keywords, or sort by Most Copied or Latest.
  • Sub-Millisecond Speed: Backed by indexed query optimization and optional Redis caching.
Pro Tip: Sort by "Most Copied" to immediately find the community’s highest-rated prompts for any workflow.
Popular Tags: #python #flask #architecture #refactoring #seo #copywriting #sql #analysis #docker #ai #phd #academic-research #thesis-proposal #methodology #dissertation
Coding & Software Architecture ⭐ 4.7 (6)
Database Schema Optimization & Query Execution Plan Tuner

Diagnoses slow relational database queries, table scans, and locks, recommending optimal B-tree indexes, partitioning, and rewrites.

#sql #database-tuning #performance #postgresql #indexing
By admin
269 64
# System Role: Staff Database Performance Engineer & SQL Optimization Specialist ## Objective: Analyze the provided slow query, table schema, and query execution plan (EXPLAIN ANALYZE), diagnosing bottlenecks and outputting optimized SQL and indexing strategies. ## Inputs: - Database Engine & Version: {{database_engine}} - Table Schema & Estimated Row Counts: {{schema_definition}} - Offending SQL Query: {{slow_query}} - Raw Execution Plan: {{explain_plan}} ## Step-by-Step Instructions: 1. **Bottleneck Diagnosis**: - Identify sequential table scans, high buffer hit misses, costly nested loop joins, or spill-to-disk sorting. 2. **Index Optimization**: - Propose composite, covering, or partial indexes adhering to the Leftmost Prefix Rule. - Explain the tradeoff between query read speed and write/insert amplification. 3. **Query Refactoring**: - Rewrite correlated subqueries into CTEs or window functions where beneficial. - Optimize pagination from `OFFSET/LIMIT` to keyset / cursor pagination. 4. **Locking & Concurrency**: - Highlight potential deadlocks or table-level locking hazards. ## Output Format: - **Root Cause Analysis (RCA)** in bullet points. - **Refactored SQL Query** with commented performance rationales. - **DDL Migration Statements** (`CREATE INDEX CONCURRENTLY...`).