Audit LinaPro backend APIs for SQL performance anti-patterns and generate issue cards.
npx skills add https://github.com/linaproai/linapro --skill lina-perf-audit
Please help me install this Agent Skill. Skill: lina-perf-audit Source: https://github.com/linaproai/linapro/tree/main/.agents/skills/lina-perf-audit Command: npx skills add https://github.com/linaproai/linapro --skill lina-perf-audit
LinaPro backend APIs often harbor performance anti-patterns like N+1 queries, missing indexes, unbounded lists, and unexpected write side effects in read endpoints. Manually auditing a full module set is slow, inconsistent, and easy to miss. This skill delivers a systematic, repeatable audit that prepares the environment, runs concurrent sub-agents, and produces both run reports and persistent issue cards.
Use the lina-perf-audit skill to run a complete performance audit of all LinaPro backend APIs and generate persistent issue cards with reproduction evidence.
High-intent search queries and answers about installing and using this skill.
An automated performance audit detects N+1 queries and missing indexes by running concurrent sub-agents that trace SQL via Trace-ID, classify severity, and generate persistent issue cards with reproduction steps and remediation recommendations.
Backend API performance anti-patterns include N+1 queries, missing indexes, unbounded lists, repeated reads, mergeable SQL calls, blocking loop operations, and read-request write side effects.
Track recurring performance issues by generating fingerprint-deduplicated issue cards under a persistent directory, ensuring each anti-pattern is recorded once with SQL evidence, source references, and remediation steps.
Yes, you can automate SQL trace analysis across a full endpoint catalog by distributing the workload across concurrent sub-agents that probe routes, trace SQL via Trace-ID, and classify findings as HIGH, MEDIUM, or LOW.
Yes, a full-lifecycle performance audit requires resetting the database, restarting services, installing built-in plugins, and loading stress fixtures before scanning endpoints and probing routes for anti-patterns.
vecearGenerate deterministic seed data with Prisma and Faker factory functions.
LerianStudioAutomate infrastructure security audits with phased scanning and compliance mapping.
VictoriaMetricsQuery VictoriaTraces Jaeger-compatible HTTP API via curl for traces and dependencies.
DaytimeBluesMeasure Core Web Vitals and analyze bundles with Lighthouse CLI.
