optimise-orm
ppryde/pip-skillsUse when the user wants to audit a Django Python file, view, model, or symbol for ORM performance issues — N+1 queries, missing or composite indexes,…
Scores out of 100 · grade B
2026-08-05Works
40% of the score80/100
- References 5 files that are not in the repo: manage.py, SKILL.md, apps/orders/views.py.
Maintained
25% of the score100/100
- no commits in the last 12 weeks
Adopted
20% of the score7/100
- 2 stars on the source repo.
Documented
15% of the score91/100
- 2,282 words with worked examples.
- Ships 15 bundled files.
Install
npx skills add ppryde/pip-skills/optimise-ormWhat the check found
| Finding | What it means |
|---|---|
| Missing files | It points at files that are not in the repository, so those steps will fail. |
Files it references that are not in the repository
What it says it does
Use when the user wants to audit a Django Python file, view, model, or symbol for ORM performance issues — N+1 queries, missing or composite indexes, bulk-write loops (.save() in loops), over-fetching wide columns, signal-bypassing .update()/bulk_* calls, slow QuerySets, slow admin changelists, slow DRF endpoints, or any Django ORM anti-pattern. Use whenever the user shares a Django file path or dotted symbol alongside performance concerns ("slow", "killing prod", "N+1", "hits the DB once per row", "make X faster", "review queryset", "audit performance", "EXPLAIN this", "optimise queries"). Do NOT use for non-Django code (SQLAlchemy, raw SQL outside the ORM, Flask), schema migrations or column adds, validation/correctness bugs, or tooling setup (Django Debug Toolbar, Silk).
Also in ppryde/pip-skills
| Artifact | Score | What the check found | Type | Reach | Last commit |
|---|---|---|---|---|---|
| orchestrateppryde/pip-skills | clean | Skill | 2 stars | 7 days ago | |
| visitationppryde/pip-skills | Missing files | Skill | 2 stars | 7 days ago | |
| clone-reviewerppryde/pip-skills | Missing files | Skill | 2 stars | 7 days ago | |
| reckoningppryde/pip-skills | Missing files | Skill | 2 stars | 7 days ago | |
| scribeppryde/pip-skills | Missing files | Skill | 2 stars | 7 days ago | |
| vigilppryde/pip-skills | Missing files | Skill | 2 stars | 7 days ago |
Other backend & apis skills
Browse all| Artifact | Score | What the check found | Category | Reach | Last commit |
|---|---|---|---|---|---|
| find-skillsvercel-labs/skills | clean | Backend & APIs | 3,040,203 installs | 2 days ago | |
| write-api-referencevercel/next.js | clean | Backend & APIs | 142k stars | today | |
| fastapifastapi/fastapi | clean | Backend & APIs | 7,944 installs | yesterday | |
| paperclippaperclipai/paperclip | clean | Backend & APIs | 3,209 installs | today | |
| onchain-pay-open-apiccxt/ccxt | clean | Backend & APIs | 44k stars | today | |
| namecheapgithub/awesome-copilot | clean | Backend & APIs | 38k stars | today |
Put this measurement in your README
A badge carrying how many listings this index holds from the repository and how many pass every static structural check. It reads from this index every time somebody loads your page, so it changes when the measurement changes and there is nothing to keep up to date. Free, no account, and the value is not something you or we can set by hand.
[](https://skillworks.kynth.studio/?q=ppryde%2Fpip-skills)Would rather not hotlink us? Every badge is also served in shields.io’s endpoint schema, so shields renders the image and your readers never talk to our domain:
Published by Toolproof, the masthead over this index and eight others. The method behind the number is at toolproof.kynth.studio/methodology, and the whole thing is readable as JSON with no key at /api.
