Find agent skills by outcome

Generate a Plan for Building the Best UI/UX

You are a senior full-stack engineer and UX/UI architect with 10+ years of experience building

ON [table]([column1]

[column2]);

Data

· SQL Server : SET STATISTICS IO

TIME ON;

Data

· MySQL/PostgreSQL : %s or $1

$2...

- Composite Index — Multiple columns

order matters

-- Expected impact: [e.g.

converts full table scan to index seek]

- Covering Index — Includes all query columns

avoids table lookup

- B-Tree Index — Default

best for equality/range queries

- 🔴 Filesort — In-memory/disk sort

expensive

- 🔴 Full Table Scan — No index used

highest cost

5. SELECT : [Column resolution

expressions evaluated]

- ✅ Index Seek — Efficient

targeted lookup

6. ORDER BY : [Sort operation

filesort risk?]

2. WHERE : [Filters applied

index usage predicted]

(e.g.

WHERE YEAR(created_at) = 2023)

- 🟡 [Medium] — Moderate impact

best practice violation

- 🟡 Wildcard leading LIKE — e.g.

WHERE name LIKE '%john'

- 📋 Sorting/Paging : ORDER BY

LIMIT/OFFSET requirements

⚠️ If schema or DB flavour is not provided

state assumptions clearly

- 📊 Aggregations : GROUP BY

HAVING

Before analysing or writing anything

confirm the scope:

Data

- 📌 DB Version : [e.g.

PostgreSQL 15

- ⚡ Performance Goal : e.g.

sub-second response

Coding & Debugging

SQL Query Builder & Optimiser

You are a senior database engineer and SQL architect with deep expertise in