How do I install the Debugging Orm Queries skill?

Run npx skillmds@latest add tomevault-io/debugging-orm-queries in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Debugging Orm Queries safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Debugging Orm Queries?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Debugging Orm Queries free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Debugging Orm Queries?

tomevault-io (@tomevault-io) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Debugging Orm Queries by tomevault-io

Name: Debugging Orm Queries
Author: tomevault-io

Debugging Orm Queries

Converts ORM calls to raw SQL and analyzes query performance. Detects N+1 queries, missing indexes, and other anti-patterns. Use when debugging slow queries, tracing ORM-generated SQL, or optimizing database performance for Sequelize, Prisma, TypeORM (Node.js), GORM, sqlc, sqlx, ent (Go), or SQLAlchemy, Django ORM, Peewee (Python).

tomevault-io e50ae28 2 files · 2.7 KB Updated Sep 17, 2026

File contents

Debugging ORM Queries

References

Language	ORMs	Reference
Node.js	Sequelize, Prisma, TypeORM	references/nodejs.md
Go	GORM, sqlc, sqlx, ent	references/golang.md
Python	SQLAlchemy, Django, Peewee	references/python.md
Anti-patterns	N+1, indexes, pagination	references/anti_patterns.md

Scripts

# Pretty-print SQL
python scripts/sql_formatter.py "SELECT..."

# Detect N+1, missing WHERE, duplicates from log file
python scripts/query_analyzer.py queries.log [--json]

# Parse EXPLAIN output (PostgreSQL or MySQL)
psql -c "EXPLAIN ANALYZE ..." | python scripts/explain_parser.py --postgres
mysql -e "EXPLAIN FORMAT=JSON ..." | python scripts/explain_parser.py --mysql

# Node.js request-scoped query tracking (see script for setup)
# Integrates with Sequelize, Prisma, TypeORM

Quick Patterns

Enable logging: Check reference for ORM-specific config (usually logging: true or echo=True)

ORM → SQL: Enable logging, run query, capture output

SQL → ORM: Map clauses to methods:

SELECT columns → specify fields/attributes
WHERE → where/filter with operators
JOIN → include/preload/prefetch_related
ORDER BY → order/orderBy
LIMIT/OFFSET → limit/offset or cursor-based

Performance issues: Run query_analyzer.py on logs, check anti_patterns.md for solutions

Converted and distributed by TomeVault — claim your Tome and manage your conversions.

---name: debugging-orm-queriesdescription: Converts ORM calls to raw SQL and analyzes query performance. Detects N+1 queries, missing indexes, and other anti-patterns. Use when debugging slow queries, tracing ORM-generated SQL, or optimizing database performance for Sequelize, Prisma, TypeORM (Node.js), GORM, sqlc, sqlx, ent (Go), or SQLAlchemy, Django ORM, Peewee (Python).---# Debugging ORM Queries## References| Language | ORMs | Reference ||----------|------|-----------|| Node.js | Sequelize, Prisma, TypeORM | [references/nodejs.md](references/nodejs.md) || Go | GORM, sqlc, sqlx, ent | [references/golang.md](references/golang.md) || Python | SQLAlchemy, Django, Peewee | [references/python.md](references/python.md) || Anti-patterns | N+1, indexes, pagination | [references/anti_patterns.md](references/anti_patterns.md) |## Scripts```bash# Pretty-print SQLpython scripts/sql_formatter.py "SELECT..."# Detect N+1, missing WHERE, duplicates from log filepython scripts/query_analyzer.py queries.log [--json]# Parse EXPLAIN output (PostgreSQL or MySQL)psql -c "EXPLAIN ANALYZE ..." | python scripts/explain_parser.py --postgresmysql -e "EXPLAIN FORMAT=JSON ..." | python scripts/explain_parser.py --mysql# Node.js request-scoped query tracking (see script for setup)# Integrates with Sequelize, Prisma, TypeORM```## Quick Patterns**Enable logging**: Check reference for ORM-specific config (usually `logging: true` or `echo=True`)**ORM → SQL**: Enable logging, run query, capture output**SQL → ORM**: Map clauses to methods:- `SELECT columns` → specify fields/attributes- `WHERE` → `where/filter` with operators- `JOIN` → `include/preload/prefetch_related`- `ORDER BY` → `order/orderBy`- `LIMIT/OFFSET` → `limit/offset` or cursor-based**Performance issues**: Run `query_analyzer.py` on logs, check `anti_patterns.md` for solutions---> Converted and distributed by [TomeVault](https://tomevault.io/claim/galihcitta) — claim your Tome and manage your conversions.

Frequently asked questions