app-analyzer-optimizer

App Analyzer & Optimizer (2026 Edition)

English | Bahasa Indonesia

---

English

Description

Deep application analysis and optimization skill. Performs architectural audits, bottleneck detection, bundle analysis, database query profiling, and AI-assisted code review across Next.js, React, Node.js, Go, Python, and Rust applications.

Trigger Conditions

• Auditing an existing codebase for architectural issues or technical debt.
• Detecting performance bottlenecks (slow API routes, large bundles, N+1 queries).
• Analyzing bundle size and suggesting code splitting opportunities.
• Reviewing code quality (complexity, duplication, dead code).
• Using AI-assisted tools to accelerate code review and analysis.

Analysis Protocol (5 Phases)

Phase 1: Architecture Discovery

# Map the entire project structure
find . -type f -name "*.ts" -o -name "*.tsx" -o -name "*.go" | head -100
# Count lines per file (find largest files)
find . -name "*.ts" -exec wc -l {} + | sort -rn | head -20
# Find circular dependencies (TypeScript/JS)
npx madge --circular --extensions ts,tsx src/

Phase 2: Bundle Analysis (Next.js / Vite)

# Next.js bundle analyzer
ANALYZE=true next build

# Or install dedicated tool
npx @next/bundle-analyzer

# Vite bundle visualization
npx vite-bundle-visualizer

# Check for duplicate dependencies
npx depcheck
npx bundle-phobia-cli check package.json

Key bundle red flags:

• Any single chunk > 500KB (uncompressed).
• Importing entire libraries (import _ from 'lodash' vs import debounce from 'lodash/debounce').
• Moment.js (replace with date-fns or Temporal).
• node_modules leaking into client bundle.

Phase 3: Database Query Analysis

-- PostgreSQL: Find slow queries
SELECT query, mean_exec_time, calls, total_exec_time
FROM pg_stat_statements
ORDER BY mean_exec_time DESC
LIMIT 20;

-- Find missing indexes (sequential scans on large tables)
SELECT schemaname, tablename, attname, n_distinct, correlation
FROM pg_stats
WHERE tablename = 'your_table'
ORDER BY n_distinct DESC;

-- Detect N+1 queries: Enable query logging
-- In Drizzle:
const db = drizzle(client, { logger: true });
-- In Prisma:
DATABASE_URL="...?connection_limit=5" prisma studio