skills.rest
fattits30-dev
fattits30-devCOMMUNITY
Explore all skills by this author →
GitHub

performance-optimization

Profile React components, analyze SQLite query plans, and reduce bundle sizes.

1|Updated Oct 8, 2025
Search Tags:#performance#React#optimization#bundle size#SQLite#memory leak#profiling
One-click install
npx skills add https://github.com/fattits30-dev/Justice-Companion --skill performance-optimization
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance-optimization
Source: https://github.com/fattits30-dev/Justice-Companion/tree/main/.claude/skills/performance-optimization
Command: npx skills add https://github.com/fattits30-dev/Justice-Companion --skill performance-optimization

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires vite-bundle-visualizer, better-sqlite3.

What problem does it solve?

This Skill identifies and resolves performance bottlenecks across React UI, SQLite database, and Electron builds. It eliminates slow user experiences and ensures your application runs smoothly and efficiently.

Core Features & Use Cases

  • React Rendering Analysis: Profiles UI for unnecessary re-renders, memoizes components, and optimizes context usage.
  • SQLite Query Optimization: Analyzes query plans, recommends missing indexes, and configures database for optimal speed (e.g., WAL mode).
  • Bundle Size Reduction: Identifies large dependencies, enables tree-shaking, and suggests dynamic imports for faster load times.
  • Use Case: When the UI feels sluggish, Claude profiles React components, analyzes SQLite query plans, and suggests code-splitting strategies, instantly pinpointing and fixing performance issues to deliver a smooth user experience.

Quick Start

Profile React components using DevTools

pnpm dev

Then open browser, React DevTools -> Profiler -> Record

Analyze SQLite query plans

sqlite3 justice.db "EXPLAIN QUERY PLAN SELECT * FROM cases WHERE user_id = 1;"

Analyze bundle size after build

pnpm build pnpm exec vite-bundle-visualizer