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

Ready to run

npx skills add https://github.com/birdayz/fdb-go --skill perf-grind

💬 Prompt for ChatGPT / Claude Chat▼

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.