Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Backend Models Standards · microck | DecimalAI

codingby microck

Backend Models Standards

microck/Backend Models Standards

Source microck/ordinary-claude-skills ↗License NOASSERTION

Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers.

SkillScore95Maintained

Automatic

Coding pack

Last verified 8/20/2026

What it changes

Passed 21 of 22 test cases with the skill, and 13 of 22 without it.

Without skill59%

With skill95%

Checks it passed that the model alone missed

The `is_active` column uses the `BOOLEAN` data type.
The database table name is set to `delivery_addresses`.
The `post_id` column explicitly specifies `index=True`.

and 7 more in the full report

9 fixed12 passed either way0 still failing1 broke

Pass-rate lift: +36 pp
Tokens: +92%
Agent turns: 0%
Response time: -9%

Model gemini-3.6-flashMeasured 8/20/2026v121 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/microck-backend-models-standards/SKILL.md https://app.decimal.ai/s/microck-backend-models-standards/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add microck-backend-models-standards, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/microck-backend-models-standards/ and pins it in .decimal/skills.lock

decimalai skills add microck-backend-models-standards

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/microck-backend-models-standards/SKILL.md https://app.decimal.ai/s/microck-backend-models-standards/SKILL.md

Raw file: /s/microck-backend-models-standards/SKILL.md ↗ · machine-readable summary at /s/microck-backend-models-standards.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 9 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 9

Prompt

I am creating a simple `Tag` ORM model for articles, containing `id` and `name`. Since tags are static metadata, we don't need audit timestamps on this table. Write the SQLAlchemy model class for `Tag`.

What was checked, without and with the skill
Checked	Without skill	With skill
The model defines `created_at` and `updated_at` columns.	Missed	Passed

case-09 · gemini-3.6-flash · 8/20/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md246 linessingle file

Backend Models Standards

Core Rule: Models define data structure and integrity. Keep them focused on data representation, not business logic.

When to use this skill

When creating or modifying database model files (models.py, models/, schema.prisma, etc.)
When defining ORM classes or ActiveRecord models for database tables
When establishing table relationships (one-to-many, many-to-many, has-many, belongs-to)
When configuring foreign keys, indexes, and cascade behaviors
When implementing model-level validation rules
When adding timestamp fields (created_at, updated_at) for auditing
When setting database constraints (NOT NULL, UNIQUE, CHECK constraints)
When choosing appropriate data types for model fields
When balancing normalization with query performance needs
When defining model methods or scopes for common queries

This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend models.

Naming Conventions

Models: Singular, PascalCase (User, OrderItem, PaymentMethod)

Tables: Plural, snake_case (users, order_items, payment_methods)

Relationships: Descriptive and clear

user.orders (one-to-many)
order.items (one-to-many)
product.categories (many-to-many)

Avoid generic names: data, info, record, entity

Required Fields

Timestamps on every model:

created_at = Column(DateTime, nullable=False, default=datetime.utcnow)
updated_at = Column(DateTime, nullable=False, default=datetime.utcnow, onupdate=datetime.utcnow)

Track record

Benchmark

21 / 22

test cases passed, vs 13 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

microck / ordinary-claude-skills

skills_all/backend-models-standards/SKILL.md

View on GitHub ↗

License NOASSERTIONImported 8/3/2026Version v1

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Backend Models Standards

When to use this skill

Naming Conventions

Required Fields

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills