skills.rest
birdayz
birdayzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

perf-grind

Identify and resolve performance issues in relational database queries.

3|Updated Aug 4, 2025
Search Tags:#query optimization#stress testing#performance engineering#relational database#Cascades SQL engine
One-click install
npx skills add https://github.com/birdayz/fdb-go --skill perf-grind
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: perf-grind
Source: https://github.com/birdayz/fdb-go/tree/main/.claude/skills/perf-grind
Command: npx skills add https://github.com/birdayz/fdb-go --skill perf-grind

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill assists in identifying and resolving performance issues within the relational layer, specifically in query optimization and execution.

Core Features & Use Cases

  • Performance Profiling: Identifies slow queries through stress testing and analysis.
  • Plan Validation: Validates plan selection using the planner harness.
  • Fix Implementation: Implements fixes for identified issues with emphasis on correctness and efficiency.
  • Validation and Testing: Ensures fixes are effective through multiple testing stages.
  • Documentation: Provides detailed documentation and guidance for the entire process.
  • Use Case: Ideal for a performance engineer tasked with optimizing a database query's performance, offering a structured approach to root cause analysis and resolution.

Quick Start

Run the stress test to identify slow queries and analyze them using the provided guidelines.

Frequently Asked Questions about perf-grind

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I identify slow relational database queries during stress testing?▼

Identify slow relational database queries by running stress tests to profile execution paths and isolate performance bottlenecks. This reveals inefficient queries within the relational layer for root cause analysis and manual optimization fixes.

What is a planner harness and how does it validate query optimization?▼

A planner harness validates query optimization by testing and verifying plan selection within the Cascades SQL engine. It ensures chosen execution plans are correct and efficient before applying manual fixes to the relational database layer.

What's the best way to resolve performance issues in a Cascades SQL engine?▼

Resolve Cascades SQL engine performance issues by profiling slow queries, validating plan selection using a planner harness, and implementing manual fixes. This structured approach ensures correctness and efficiency in the relational layer.

Do I need prior knowledge of database performance engineering to use this approach?▼

Yes, prior knowledge of database performance optimization techniques and the Cascades SQL engine is required. This background is necessary to interpret stress test results, validate execution plans, and implement correct manual fixes.

How do I ensure query performance fixes are effective and do not break correctness?▼

Ensure query performance fixes are effective by validating plan selection through a planner harness and conducting multiple testing stages. This verifies manual optimizations resolve execution bottlenecks without compromising relational database correctness.

Related Skills

Explore More Software Engineering Skills→
herdiansahherdiansah
23

sql-optimization-patterns

Analyze PostgreSQL execution plans and optimize SQL query performance.

Community
Advanced
miles990miles990
20

performance-optimization

Profile CPU and memory usage to identify performance bottlenecks.

Community
Advanced
D3HunterD3Hunter

review-correctness-query-planner-execution

Review database query, planner, and execution engine diffs for correctness issues.

Community
Advanced
maschadmaschad
6

benchmark-driven-development

Profile code against measurable benchmarks to identify performance bottlenecks.

Community
Advanced