agentsclimarketplace

Sqlalchemy orm patterns

Skill planifest/planifest-framework/planifest-framework/external-skills/sqlalchemy-orm-patterns

A specification framework for agentic development. Agents build from complete specs - not guesses.

Install
npx -y skills add planifest/planifest-framework --skill sqlalchemy-orm-patterns

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

SQLAlchemy ORM workflow for model mapping, session/transaction boundaries, and query loading strategy. Use when SQLAlchemy ORM behavior must be implemented or revised with explicit persistence decisions; do not use for repository-wide architecture governance or release policy decisions.

SKILL.md

2.0 KB, 340 tokens by cl100k_base, as published. Nobody here has run it

Sqlalchemy Orm Patterns

Overview

Use this skill to design SQLAlchemy usage that remains correct, efficient, and maintainable under production load.

Scope Boundaries

  • Use this skill when the task matches the trigger condition described in description.
  • Do not use this skill when the primary task falls outside this skill's domain.

Shared References

  • ORM loading and session rules:
    • references/orm-loading-and-session-rules.md

Templates And Assets

  • ORM modeling template:
    • assets/sqlalchemy-modeling-template.py
  • Session/transaction checklist:
    • assets/sqlalchemy-session-transaction-checklist.md

Inputs To Gather

  • Domain model and relationship constraints.
  • Transaction consistency requirements.
  • Query access patterns and performance constraints.
  • Session lifecycle boundaries.

Deliverables

  • ORM model and relationship design.
  • Session and transaction boundary policy.
  • Query loading strategy with hotspot validation.

Workflow

  1. Draft model structure using assets/sqlalchemy-modeling-template.py.
  2. Define session/transaction boundaries.
  3. Apply loading strategy rules from references/orm-loading-and-session-rules.md.
  4. Validate SQL behavior for hot queries.
  5. Finalize with assets/sqlalchemy-session-transaction-checklist.md.

Quality Standard

  • Session ownership is explicit and leak-free.
  • Transaction boundaries preserve business atomicity.
  • Query strategy avoids N+1/overfetch patterns.
  • ORM abstractions remain transparent for critical SQL paths.

Failure Conditions

  • Stop when session ownership is ambiguous across layers.
  • Stop when ORM hides critical SQL behavior on hot paths.
  • Escalate when transaction guarantees cannot be met safely.

What ships with it: 1 file

11.3 KB alongside SKILL.md

Keep looking

Skills are one crate of 327,069. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.