debugging-orm-queries
CommunityAutomate ORM debugging and SQL optimization.
Authorgalihcitta
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps developers diagnose and optimize ORM-generated SQL by translating ORM calls into raw SQL, detecting anti-patterns (like N+1 queries and missing indexes), and providing practical guidance across Node.js, Go, and Python ecosystems.
Core Features & Use Cases
- ORM → SQL conversion: Translate common ORM calls into equivalent SQL for analysis.
- SQL → ORM guidance: Map raw SQL back into ORM patterns for refactoring.
- N+1 detection: Identify N+1 query patterns in logs and suggest eager loading or batching.
- Explain analysis: Interpret EXPLAIN outputs to pinpoint slow operations and indexing gaps.
- Cross-language coverage: Guidance for Sequelize/Prisma/TypeORM (Node.js), GORM/sqlc/sqlx/ent (Go), SQLAlchemy/Django/Peewee (Python).
Quick Start
- Run the query analyzer on your ORM logs: python scripts/query_analyzer.py queries.log
- Pretty-print captured SQL: python scripts/sql_formatter.py "SELECT..."
- See evaluation scenarios in evaluations.json to validate improvements.
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: debugging-orm-queries Download link: https://github.com/galihcitta/dotclaudeskills/archive/main.zip#debugging-orm-queries Please download this .zip file, extract it, and install it in the .claude/skills/ directory.