Database Anti-Patterns
CommunityOptimize database performance and prevent common pitfalls.
AuthorJaveedIshaq
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps developers identify and fix common database performance anti-patterns, ensuring efficient and scalable data operations.
Core Features & Use Cases
- N+1 Query Detection: Identifies inefficient loops that cause excessive database calls.
- Sequential Query Optimization: Detects queries that could be run in parallel using
Promise.all. - Unbounded Fetch Prevention: Enforces limits on data retrieval to prevent overwhelming the database.
- Index Missing Detection: Highlights queries on non-indexed columns and suggests index creation.
- Connection Pool Management: Guides against creating new connections per request and advises on keeping transactions short.
- Use Case: A developer can use this skill to scan their codebase and receive actionable advice on how to refactor slow database queries, leading to a faster and more responsive application.
Quick Start
Scan the current project's source code for database anti-patterns using the provided bash script.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: Database Anti-Patterns Download link: https://github.com/JaveedIshaq/ai-workflow-orchestrator/archive/main.zip#database-anti-patterns Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.