Can this help with raw SQL queries?

Yes, it includes detection logic for raw SQL anti-patterns, such as identifying 'SELECT *' usage and queries missing appropriate LIMIT or indexing strategies.

Which ORMs does this skill support?

The skill provides specific patterns and fix examples for Prisma, Drizzle, TypeORM, and Sequelize, and can be easily customized for other libraries.

How does this skill detect N+1 queries?

It utilizes specialized grep patterns to locate database queries executed within loops—such as forEach, map, and for...of—identifying where batching or joins should be used instead.

Does it provide automated fixing?

It provides a scanning script to find issues and 'Fix Pattern' templates that Claude can use to refactor your code safely and efficiently.

Database Performance & Anti-Patterns

Name: Database Performance & Anti-Patterns
Author: JaveedIshaq

byJaveedIshaq

•

Database Management

Identifies and remediates common database performance bottlenecks like N+1 queries, unbounded fetches, and connection pool issues.

This Claude Code skill empowers developers to proactively detect and fix inefficient database patterns that degrade application performance. It provides specialized detection logic for N+1 queries, sequential awaits, and missing pagination across popular ORMs like Prisma, Drizzle, and TypeORM. By offering both automated grep-based scanning scripts and concrete refactoring templates, it helps teams optimize their data access layer, reduce database load, and ensure scalable connection management.

Key Features

01Connection pool exhaustion prevention and transaction optimization

02Identification of sequential queries for Promise.all parallelization

03Support for major ORMs including Prisma, Drizzle, and TypeORM

041 GitHub stars

05N+1 query detection and batching remediation patterns

06Automated scanning for unbounded fetches and missing LIMIT clauses

Use Cases

01Refactoring data access layers to handle high-traffic scaling

02Optimizing cloud database costs by reducing redundant query volume

03Auditing legacy codebases for latent performance bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add javeedishaq/ai-workflow-orchestrator db-anti-patterns

For use in Claude.ai and ChatGPT

Download Skill