working-with-databases SKILL.md skillA

working-with-databases from dayfinggg/openai-codex-agent-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add dayfinggg/openai-codex-agent-skills/working-with-databases@git:20261015.18f69f5

Pins git:20261015.18f69f5 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
dayfinggg/openai-codex-agent-skills
Path
codex/skills/working-with-databases/SKILL.md
Versions recorded
3
Latest version
git:20261015.18f69f5, committed Oct 15, 2026
First version recorded
Sep 29, 2026
Size
6,586 bytes
Repository stars
8
License
MIT

Designs schemas and writes queries, migrations, and data access code for SQL and NoSQL stores with injection-safe queries. Use when writing or reviewing SQL, ORM code, schema or index changes, migrations, Redis caching, or slow queries.

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

# Working with databases

The data model is part of the design, and the database product is a detail. Keep business rules independent of the storage technology, put every query behind a repository or gateway owned by the application, and still design the schema, keys, and indexes with care, because data outlives code. This skill owns SQL and NoSQL injection, the writing-secure-code skill covers the other injection sinks and access control, and the adding-observability skill covers what may be logged. When the project already has conventions for naming, migrations, or data access, follow them.

## Data access in the architecture

- The use case layer declares a repository interface in business terms (`find_active_orders_for(customer_id)`), and an adapter implements it with SQL, an ORM, or a NoSQL client. The applying-clean-architecture skill covers the layers.
- Map rows and documents to domain objects inside the adapter. ORM models, cursors, and driver types never leave it.
- One repository per aggregate, meaning a cluster of objects that changes together, not one per table.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add dayfinggg/openai-codex-agent-skills/working-with-databases@sha256:91a72f34ca7a0d00

The line at the top of this page pins the label git:20261015.18f69f5, 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_zr7yior6zepxmnqe.svg)](https://markdownregistry.com/a/art_zr7yior6zepxmnqe)

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

Versions

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

versioncommittedcommitsizeaudit
git:20261015.18f69f5 latest2026-10-15 18f69f5 6,586 BA view · diff
git:20260930.baa3c292026-09-30 baa3c29 2,201 BA view · diff
git:20260929.55c44aa2026-09-29 55c44aa 2,104 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 (6586 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

dayfinggg/openai-codex-agent-skills · 8 stars · license MIT · pushed 2026-10-15 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_zr7yior6zepxmnqe
GET https://markdownregistry.com/api/v1/resolve?ref=dayfinggg/openai-codex-agent-skills/working-with-databases
GET https://markdownregistry.com/api/v1/blob/91a72f34ca7a0d000c1c9588d0c7231c5d173b790447370a94af7bce517ebf43

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 dayfinggg/openai-codex-agent-skills

adding-observability SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/adding-observability/SKILL.md · Adds and reviews logs, metrics, traces, error reporting, and health endpoints with OpenTelemetry and structured…
git:20261015.18f69f5 · audit A · 8 stars
applying-clean-architecture SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/applying-clean-architecture/SKILL.md · Structures applications with business rules at the center and frameworks, databases, and UI behind ports and adapters…
git:20261015.18f69f5 · audit A · 8 stars
applying-design-patterns SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/applying-design-patterns/SKILL.md · Chooses, introduces, and removes design patterns such as Strategy, Factory, Adapter, and Observer, starting from a real…
git:20261015.18f69f5 · audit A · 8 stars
building-resilient-services SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/building-resilient-services/SKILL.md · Makes service code survive slow and failing dependencies with timeouts, retries, circuit breakers, idempotent handlers…
git:20261015.18f69f5 · audit A · 8 stars
designing-http-apis SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/designing-http-apis/SKILL.md · Designs and reviews HTTP and REST JSON APIs by current standards for methods, status codes, errors, and OpenAPI…
git:20261015.18f69f5 · audit A · 8 stars
designing-user-interfaces SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/designing-user-interfaces/SKILL.md · Designs, builds, and reviews user interfaces for web and mobile with usability heuristics, WCAG 2.2 AA, and design…
git:20261015.18f69f5 · audit A · 8 stars
managing-dependencies-and-ci SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/managing-dependencies-and-ci/SKILL.md · Adds, updates, and removes dependencies and hardens CI with maintained packages, committed lockfiles, pinned images and…
git:20261015.18f69f5 · audit A · 8 stars
planning-implementation SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/planning-implementation/SKILL.md · Studies a coding task in a larger codebase before any edit, settles open decisions with the user, agrees on a short…
git:20261015.18f69f5 · audit A · 8 stars
recording-architecture-decisions SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/recording-architecture-decisions/SKILL.md · Records architecture decisions as ADRs in the repository's format or MADR and draws C4 diagrams as text. Use when asked…
git:20261015.18f69f5 · audit A · 8 stars
releasing-software SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/releasing-software/SKILL.md · Versions and publishes software by SemVer with trusted publishing, provenance, and SBOMs. Use when bumping a version…
git:20261015.18f69f5 · audit A · 8 stars
securing-llm-features SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/securing-llm-features/SKILL.md · Secures code that uses large language models against prompt injection, excessive agency, unsafe output handling, data…
git:20261015.18f69f5 · audit A · 8 stars
working-with-3d-graphics SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/working-with-3d-graphics/SKILL.md · Builds, scripts, and reviews 3D work in Blender, Unreal Engine 5, three.js, React Three Fiber, Babylon.js, and glTF…
git:20261015.18f69f5 · audit A · 8 stars

Every file in dayfinggg/openai-codex-agent-skills

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