flat-persistence SKILL.md skillA

flat-persistence from wntic/pyhouse is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add wntic/pyhouse/flat-persistence@git:20261011.4a676ac

Pins git:20261011.4a676ac in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
wntic/pyhouse
Path
plugins/pyhouse-flat/skills/flat-persistence/SKILL.md
Versions recorded
5
Latest version
git:20261011.4a676ac, committed Oct 11, 2026
First version recorded
Sep 29, 2026
Size
13,035 bytes
Repository stars
3
License
MIT

Use when a flat-layered service reads or writes a datastore — its table definitions, its component-owned settings class, the repository class that owns each write's transaction and builds its statements, and where its migration history lives. Owns one data-access package per store named for its technology, the SQLAlchemy Core binding of `persistence`'s store-generic rules, application-minted time-ordered keys, the settings class and engine factory the process definition builds, and one…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Flat Persistence — one package per store owns the data access

The package a `flat-layered` service keeps its data access in — the *data access* role kind in that
skill's import contract — named for the store's technology: `postgres/` for the relational store the
templates bind. It holds the table definitions, the write path and the mapping from stored rows back to
the service's own types. Where the service owns the store's schema, its migration history is data, not code, and
sits at the distribution root under `migrations/` in a directory named for the same store.

**Load `persistence` before writing any file below**; the templates satisfy its rules and do not
restate them. It owns the store-generic obligations — the declared transaction owner, translation at
this package's edge, generated constraint names, the pure row mapping, stored types, conflicts and
ordering, deduplication left to the store, batched writes, paged reads, and migrations — and which of
them bind, answered once there from the store's properties. This skill adds the flat family's shape
around them — one package per store, its settings class and engine factory, the key policy and where
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add wntic/pyhouse/flat-persistence@sha256:0f8a336be0a28cf7

The line at the top of this page pins the label git:20261011.4a676ac, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_bw4bvzwdtmavjiw2.svg)](https://markdownregistry.com/a/art_bw4bvzwdtmavjiw2)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 5 versions of this file, between Sep 29, 2026 and Oct 11, 2026, about one every 3 days.

versioncommittedcommitsizeaudit
git:20261011.4a676ac latest2026-10-11 4a676ac 13,035 BA view · diff
git:20261011.37500a32026-10-11 37500a3 13,046 BA view · diff
git:20261001.97bffe22026-10-01 97bffe2 13,730 BA view · diff
git:20261001.94aae442026-10-01 94aae44 13,730 BA view · diff
git:20260929.47c8a082026-09-29 47c8a08 13,093 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (13035 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

wntic/pyhouse · 3 stars · license MIT · pushed 2026-11-05 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_bw4bvzwdtmavjiw2
GET https://markdownregistry.com/api/v1/resolve?ref=wntic/pyhouse/flat-persistence
GET https://markdownregistry.com/api/v1/blob/0f8a336be0a28cf70a8ec38b69badaa495a17be6712c803c3180722ab95ac4b2

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from wntic/pyhouse

CLAUDE.md CLAUDE.md file
wntic/pyhouse · CLAUDE.md
git:20261102.436d0c3 · audit A · 3 stars
flat-entrypoint SKILL.md skill
wntic/pyhouse · plugins/pyhouse-flat/skills/flat-entrypoint/SKILL.md · Use when choosing how a flat-layered service is triggered and writing the process that triggers it — one run per…
git:20261011.122368f · audit A · 3 stars
flat-layered SKILL.md skill
wntic/pyhouse · plugins/pyhouse-flat/skills/flat-layered/SKILL.md · Use when structuring a worker, crawler, pipeline, ETL job or integration service whose family is already settled as…
git:20261011.4a676ac · audit A · 3 stars
flat-project-setup SKILL.md skill
wntic/pyhouse · plugins/pyhouse-flat/skills/flat-project-setup/SKILL.md · Use when laying a flat-layered service down once — which runtime and development libraries each of its roles brings…
git:20261011.5171fc0 · audit A · 3 stars
flat-test-entrypoint SKILL.md skill
wntic/pyhouse · plugins/pyhouse-flat/skills/flat-test-entrypoint/SKILL.md · Use when testing what a flat-layered service's trigger actually runs — the function it calls end to end against the…
git:20261011.5171fc0 · audit A · 3 stars
flat-test-integration-setup SKILL.md skill
wntic/pyhouse · plugins/pyhouse-flat/skills/flat-test-integration-setup/SKILL.md · Use when laying the shared fixtures a flat-layered service's integration tests rest on — the suite-owned datastore…
git:20261011.4a676ac · audit A · 3 stars
flat-test-persistence SKILL.md skill
wntic/pyhouse · plugins/pyhouse-flat/skills/flat-test-persistence/SKILL.md · Use when testing a flat-layered service's data-access package against the real datastore — its tables and the…
git:20261011.37d6f36 · audit A · 3 stars
flat-test-service-client SKILL.md skill
wntic/pyhouse · plugins/pyhouse-flat/skills/flat-test-service-client/SKILL.md · Use when testing one external-service HTTP client class with its transport stubbed — URL assembly, the outgoing…
git:20261011.5171fc0 · audit A · 3 stars
git-branching SKILL.md skill
wntic/pyhouse · plugins/pyhouse-git/skills/git-branching/SKILL.md · Use when starting a branch, deciding how a change reaches the mainline, cleaning a branch's history before it lands, or…
git:20261011.4a676ac · audit A · 3 stars
git-commit-message SKILL.md skill
wntic/pyhouse · plugins/pyhouse-git/skills/git-commit-message/SKILL.md · Use when writing a commit message or a merge or pull request's title or description, or deciding what type, scope or…
git:20261011.4a676ac · audit A · 3 stars
hex-application SKILL.md skill
wntic/pyhouse · plugins/pyhouse-hex/skills/hex-application/SKILL.md · Use when writing a use case — a CQRS command handler, a query handler, or its frozen input DTO — including a command…
git:20261014.20fc6e0 · audit A · 3 stars
hex-architecture SKILL.md skill
wntic/pyhouse · plugins/pyhouse-hex/skills/hex-architecture/SKILL.md · Use when the family is already settled as hexagonal and the question is where a module belongs or whether an import may…
git:20261014.20fc6e0 · audit A · 3 stars

Every file in wntic/pyhouse

Browse by kind, by grade A, or by owner.