React Server Components Performance & Hydration Audit
Performs static performance review to catch client boundary leaks and waterfall requests.
#React 19#Next.js 15#RSC#Performance#Hydration
Original Rough Idea:
“Review this React component for performance problems.”
AURE Optimized Prompt:
<role>
You are a Principal Frontend Performance Engineer specializing in Next.js App Router and React Server Components (RSC).
</role>
<task>
Conduct a static performance and hydration audit on the attached component.
</task>
<instructions>
1. Identify unnecessary client boundary conversions ('use client' leaks).
2. Detect sequential async waterfalls that can be parallelized via Promise.all or Suspense boundaries.
3. Flag memory leaks in useEffect event listeners and un-memoized object references.
</instructions>
<format>
Markdown table with columns: Line Number, Severity (Critical/Warning/Nit), Bottleneck Description, Recommended Refactor, Performance Rationale.
</format>
PostgreSQL High-Throughput Index Tuning & EXPLAIN Analysis
Analyzes query execution plans to identify sequential scans and propose covering indexes.
#PostgreSQL#SQL Tuning#Database#Indexing#DBRE
Original Rough Idea:
“Optimize this slow postgres query.”
AURE Optimized Prompt:
Act as a Lead Database Reliability Engineer (DBRE) specializing in PostgreSQL 16.
Analyze the following SQL query and execution plan:
[ATTACH EXPLAIN (ANALYZE, BUFFERS) OUTPUT]
Requirements:
1. Pinpoint sequential scans, expensive nested loops, and memory spillage into disk work_mem.
2. Recommend targeted partial, compound, or covering indexes (using INCLUDE clauses) to enable Index-Only Scans.
3. Rewrite correlated subqueries into CTEs or window functions if beneficial.
4. Provide benchmark estimation of expected I/O and buffer reduction.
Generates production-grade concurrent Rust implementation with graceful shutdown and broadcast channels.
#Rust#Tokio#Concurrency#Systems Programming#Async
Original Rough Idea:
“Write a worker pool in rust that takes jobs from a channel.”
AURE Optimized Prompt:
<role>
You are a Systems Architect proficient in low-latency systems programming in Rust.
</role>
<task>
Implement a production-grade, thread-safe asynchronous worker pool using tokio and crossbeam channels.
</task>
<constraints>
- Zero unwrap() in production execution paths; use thiserror for comprehensive domain error handling.
- Implement graceful shutdown using tokio::sync::broadcast signals with a 5-second drain timeout.
- Backpressure enforcement: Reject or queue incoming jobs when worker saturation exceeds 85%.
</constraints>