How does it coordinate the audit process?

It acts as a Level 2 coordinator, delegating specific tasks to four specialized sub-agents that run in parallel to analyze query efficiency, transaction correctness, runtime performance, and resource lifecycles.

What technologies does this auditor support?

It automatically detects common databases (e.g., PostgreSQL), ORMs (e.g., SQLAlchemy), and async frameworks (e.g., FastAPI, asyncio) by scanning your project's manifests and configuration files.

Can I run this audit independently?

Yes, while it is part of a larger workflow collection, it can be manually invoked at any time to perform a standalone audit of your persistence and performance layers.

Does this skill modify my source code?

No, it is a diagnostic tool that generates a comprehensive markdown report in your project documentation directory, providing recommendations for manual implementation.

Persistence & Performance Auditor

Name: Persistence & Performance Auditor
Author: levnikolaevich

bylevnikolaevich

•

147

•

数据库管理

Orchestrates comprehensive database and runtime performance audits by coordinating specialized analysis workers to optimize backend efficiency.

The Persistence & Performance Auditor is a high-level coordinator designed to automate the deep-dive technical assessment of a project's data persistence layer and execution efficiency. It automatically detects the technology stack—including databases like PostgreSQL, ORMs like SQLAlchemy, and async frameworks—researches current industry best practices, and manages four specialized sub-agents in parallel. These agents identify query inefficiencies, transaction risks, runtime bottlenecks, and resource lifecycle issues, ultimately producing a consolidated, prioritized report to ensure production readiness and system stability.

主要功能

01Consolidated reporting with compliance scoring and prioritized action items.

02Context-aware validation to filter out false positives in non-critical code paths.

03Automated tech stack discovery and DB-specific metadata extraction.

04147 GitHub stars

05Multi-worker orchestration for parallel analysis of queries, transactions, and resources.

06Real-time research of industry best practices via MCP integration.

使用场景

01Conducting periodic system health checks to ensure database connection pooling and ORM usage align with best practices.

02Performing pre-deployment reviews to identify N+1 queries and blocking I/O in async code.

03Auditing complex transaction logic and resource cleanup to prevent memory leaks and deadlocks.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add levnikolaevich/claude-code-skills ln-650-persistence-performance-auditor

For use in Claude.ai and ChatGPT

Download Skill

主要功能

01Consolidated reporting with compliance scoring and prioritized action items.

02Context-aware validation to filter out false positives in non-critical code paths.

03Automated tech stack discovery and DB-specific metadata extraction.

04147 GitHub stars

05Multi-worker orchestration for parallel analysis of queries, transactions, and resources.

06Real-time research of industry best practices via MCP integration.

使用场景

01Conducting periodic system health checks to ensure database connection pooling and ORM usage align with best practices.

02Performing pre-deployment reviews to identify N+1 queries and blocking I/O in async code.

03Auditing complex transaction logic and resource cleanup to prevent memory leaks and deadlocks.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add levnikolaevich/claude-code-skills ln-650-persistence-performance-auditor

For use in Claude.ai and ChatGPT

Download Skill