General
PromptBeginner5 minmarkdown
- 🔴 Full Table Scan — No index used
highest cost
0
Explore
Find agent skills by outcome
62,200 skills indexed with the new KISS metadata standard.
Showing 24 of 62,200Categories: General, Business, Coding & Debugging, Data
General
PromptBeginner5 minmarkdown
5. SELECT : [Column resolution
expressions evaluated]
0
General
PromptBeginner5 minmarkdown
6. ORDER BY : [Sort operation
filesort risk?]
0
General
PromptBeginner5 minmarkdown
- ✅ Index Seek — Efficient
targeted lookup
0
Business
PromptBeginner5 minmarkdown
3. GROUP BY : [Grouping strategy
sort operation needed?]
0
General
PromptBeginner5 minmarkdown
2. WHERE : [Filters applied
index usage predicted]
0
Business
PromptBeginner5 minmarkdown
1. FROM & JOINs : [Tables accessed
join strategy predicted]
0
General
PromptBeginner5 minmarkdown
- 🟡 [Medium] — Moderate impact
best practice violation
0
General
PromptBeginner5 minmarkdown
- 🟡 Wildcard leading LIKE — e.g.
WHERE name LIKE '%john'
0
General
PromptBeginner5 minmarkdown
(e.g.
WHERE YEAR(created_at) = 2023)
0
General
PromptBeginner5 minmarkdown
- 📊 Aggregations : GROUP BY
HAVING
0
General
PromptBeginner5 minmarkdown
- 📋 Sorting/Paging : ORDER BY
LIMIT/OFFSET requirements
0
General
PromptBeginner5 minmarkdown
⚠️ If schema or DB flavour is not provided
state assumptions clearly
0
Data
PromptBeginner5 minmarkdown
- 📌 DB Version : [e.g.
PostgreSQL 15
0
General
PromptBeginner5 minmarkdown
Before analysing or writing anything
confirm the scope:
0
General
PromptBeginner5 minmarkdown
- ⚡ Performance Goal : e.g.
sub-second response
0
Coding & Debugging
PromptBeginner5 minmarkdown
SQL Query Builder & Optimiser
You are a senior database engineer and SQL architect with deep expertise in
0
General
PromptBeginner5 minmarkdown
query optimisation
execution planning
0
Data
PromptBeginner5 minmarkdown
and SQL security across MySQL
PostgreSQL
0
General
PromptBeginner5 minmarkdown
- Set payment frequency (e.g. weekly
monthly..etc) ${frequency}
0
Business
PromptBeginner5 minmarkdown
Stripe Payment Builder
Act as a Stripe Payment Setup Assistant. You are an expert in configuring Stripe payment options for various business needs. Your task is to set up a payment process that allows customization based on...
0
General
PromptBeginner5 minmarkdown
✅ HikariCP (default in Spring Boot
fastest
0
General
PromptBeginner5 minmarkdown
❌ Jedis (older pattern
topology issues)
0
Coding & Debugging
PromptBeginner5 minmarkdown
✅ Lettuce (reactive
auto-reconnect)
0