AGENT SKILL

django-db-side-computation

Move Django performance-sensitive Python loops into database-side computation with annotations, aggregates, filtered aggregates, F expressions, functions, Subquery, OuterRef, Exists, Window expressions, db_default, and GeneratedField. Use when Django code counts, sums, filters, flags, ranks, or derives values in Python after fetching rows.

License 许可
MIT
最近更新
2026-06-26
Stars
★ 0
Forks
0

01 前言 Front Matter

name
django-db-side-computation
license
MIT
metadata
{ "tags": "django,database,aggregation,orm,analytics", "version": "0.1.0", "category": "Django", "displayName": "Django DB-Side Computation" }
description
Move Django performance-sensitive Python loops into database-side computation with annotations, aggregates, filtered aggregates, F expressions, functions, Subquery, OuterRef, Exists, Window expressions, db_default, and GeneratedField. Use when Django code counts, sums, filters, flags, ranks, or derives values in Python after fetching rows.
compatibility
Codex, Claude Code, and other Agent Skills-compatible clients.

02 资源文件 1

03 SKILL.md 正文

Django DB-Side Computation

Use this skill when Django fetches rows into Python to compute values the database can compute more efficiently or more consistently.

Workflow

  1. Identify the Python computation.

    • Counts, sums, min/max, booleans, latest related rows, rankings, denormalized totals, or per-row derived fields.
    • Confirm whether the computed value must be exact, current, and transactionally consistent.
  2. Pick the SQL expression level.

    • filter(), exclude(), and F() for simple comparisons and updates.
    • annotate() and aggregates for per-object counts and totals.
    • Filtered aggregates for conditional counts and sums.
    • Exists() for yes/no related-row checks.
    • Subquery() with OuterRef() for latest or scalar related values.
    • Window() for ranks and running calculations.
    • GeneratedField for deterministic same-row computed columns when the database supports it.
  3. Validate query shape.

    • Inspect generated SQL or QuerySet.explain().
    • Clear unintended ordering before grouping when needed.
    • Confirm indexes support joins, filters, and ordering.
  4. Decide whether the result should be stored.

    • Use annotations for request-time values.
    • Use generated fields for same-row deterministic values.
    • Use materialized views or denormalized tables when cross-row aggregate queries are too expensive and can be stale.

See aggregation-patterns.md for Django expression examples.

Safety Notes

  • Database computation is not always faster; complex queries can overload the database or block OLTP work.
  • Generated fields have database-specific restrictions and PostgreSQL supports only persisted generated columns.
  • Subqueries and annotations can duplicate work if composed carelessly. Read the plan.

Verification

Compare correctness against the old Python calculation on representative data, then measure SQL time and total response time.

04 同仓库更多 Skills

ConcertoNotes
ConcertoNotes/codex-plugins

android-emulator-qa

Use when validating Android feature flows in an emulator with adb-driven launch, input, UI-tree inspection, screenshots, and logcat capture.

★ 0
ConcertoNotes
ConcertoNotes/codex-plugins

supabase-postgres-best-practices

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

★ 0
ConcertoNotes
ConcertoNotes/codex-plugins

sentry

Use when the user asks to inspect Sentry issues or events, summarize recent production errors, or pull basic Sentry health data via the Sentry API; perform read-only queries with the bundled script and require `SENTRY_AUTH_TOKEN`.

★ 0
ConcertoNotes
ConcertoNotes/codex-plugins

render-workflows

Sets up, develops, tests, and deploys Render Workflows. Covers first-time scaffolding (via CLI or manual), SDK installation (Python or TypeScript), task patterns (retries, subtasks, fan-out), local development, Dashboard deployment, and troubleshooting. Use when a user wants to set up Render Workflows for the first time, scaffold a workflow service, add or modify workflow tasks, test workflows locally, or deploy workflows to Render.

★ 0
ConcertoNotes
ConcertoNotes/codex-plugins

render-web-services

Configures Render web services—port binding, TLS, health checks, custom domains, auto-deploy, PR previews, persistent disks, and deploy lifecycle. Use when the user needs to set up a web service, fix health check failures, add a custom domain, configure zero-downtime deploys, or troubleshoot port binding issues.

★ 0
ConcertoNotes
ConcertoNotes/codex-plugins

render-static-sites

Deploys and configures static sites on Render's global CDN—build commands, publish paths, SPA routing, redirects, custom headers, and PR previews. Use when the user needs to deploy a static site, set up a React/Vue/Hugo/Gatsby frontend, configure SPA fallback routing, add redirect rules, customize response headers, or choose between a static site and a web service for their frontend. Trigger terms: static site, CDN, SPA, single-page app, React deploy, Vue deploy, Hugo, Gatsby, Docusaurus, Jekyll, staticPublishPath.

★ 0