database SKILL.md skillA

database from jnpiyush/agentx is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add jnpiyush/agentx/database@v1.0.0

Pins v1.0.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
jnpiyush/agentx
Path
.github/skills/architecture/database/SKILL.md
Versions recorded
5
Latest version
v1.0.0, committed Sep 15, 2026
First version recorded
Feb 11, 2026
Size
5,812 bytes
Repository stars
19
License
Apache-2.0

Design database operations including migrations, indexing strategies, transactions, connection pooling, and ORM best practices. Use when creating database schemas, writing migrations, optimizing slow queries, configuring connection pools, or choosing between ORM frameworks.

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

# Database

> **Purpose**: Efficient, reliable database operations with migrations, indexes, and transactions. 
> **Focus**: ORM patterns, query optimization, data integrity. 
> **Note**: For database-specific details, see [PostgreSQL](../../languages/postgresql/SKILL.md) or [SQL Server](../../languages/sql-server/SKILL.md).

---

## When to Use This Skill

- Creating database schemas or migrations
- Optimizing slow database queries
- Configuring connection pooling
- Choosing between ORM frameworks
- Implementing data integrity constraints

## Prerequisites

- SQL fundamentals
- Access to a relational database

## Decision Tree

```
Database operation?
+- Schema change?
| +- New table/column? -> Migration (up + down)
| +- Rename/drop? -> Migration + verify no dependents
| - Index needed? -> CREATE INDEX CONCURRENTLY (avoid locks)
+- Query performance?
| +- Slow query? -> EXPLAIN ANALYZE -> add index or rewrite
| +- N+1 problem? -> Use eager loading / JOIN
| - Large result set? -> Pagination (cursor-based preferred)
+- Data integrity?
| +- Multiple writes? -> Use transaction
| - Concurrent access? -> Optimistic concurrency (version column)
- Connection management?
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add jnpiyush/agentx/database@sha256:fe7f37b9047ebc68

The line at the top of this page pins the label v1.0.0, 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_h63ml5llxmzcsfid.svg)](https://markdownregistry.com/a/art_h63ml5llxmzcsfid)

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

Versions

The registry has recorded 5 versions of this file, between Feb 11, 2026 and Sep 15, 2026, about one every 54 days.

versioncommittedcommitsizeaudit
v1.0.0 latest2026-09-15 f17c505 5,812 BA view · diff
v1.0.02026-03-01 969f335 5,810 BA view · diff
v1.0.02026-02-28 aa03a2e 4,778 BA view · diff
v1.0.02026-02-16 30e409a 4,786 BA view · diff
v1.0.02026-02-11 e9f9a5c 4,900 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 (5812 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

jnpiyush/agentx · 19 stars · license Apache-2.0 · pushed 2026-11-04 · branch master

API

GET https://markdownregistry.com/api/v1/artifacts/art_h63ml5llxmzcsfid
GET https://markdownregistry.com/api/v1/resolve?ref=jnpiyush/agentx/database
GET https://markdownregistry.com/api/v1/blob/fe7f37b9047ebc683fc4cb060353be85a1b39a2aac5367718889d782cbde0c71

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 jnpiyush/agentx

000-frontier-core Cursor rule
jnpiyush/agentx · .cursor/rules/000-frontier-core.mdc · Frontier canonical contracts and workspace context for Cursor.
git:20261012.38fb931 · audit A · 19 stars
ai Cursor rule
jnpiyush/agentx · .cursor/rules/ai.mdc · AI / agent / LLM workflow standards (Frontier)
git:20261010.87e53aa · audit A · 19 stars
csharp Cursor rule
jnpiyush/agentx · .cursor/rules/csharp.mdc · C# / .NET coding standards (Frontier)
git:20261010.87e53aa · audit A · 19 stars
python Cursor rule
jnpiyush/agentx · .cursor/rules/python.mdc · Python coding standards (Frontier)
git:20261010.87e53aa · audit A · 19 stars
react Cursor rule
jnpiyush/agentx · .cursor/rules/react.mdc · React / TSX frontend standards (Frontier)
git:20261010.87e53aa · audit A · 19 stars
typescript Cursor rule
jnpiyush/agentx · .cursor/rules/typescript.mdc · TypeScript / Node backend standards (Frontier)
git:20261010.87e53aa · audit A · 19 stars
agent-memory-systems SKILL.md skill
jnpiyush/agentx · .github/skills/ai-systems/agent-memory-systems/SKILL.md · Design agent memory beyond a single context window: short-term (working / scratchpad), long-term (episodic, semantic…
v1.0.0 · audit A · 19 stars
agent-observability SKILL.md skill
jnpiyush/agentx · .github/skills/ai-systems/agent-observability/SKILL.md · Instrument LLM agents with tracing, metrics, and evaluation telemetry. Use when adding OpenTelemetry GenAI semantic…
v1.0.0 · audit A · 19 stars
ai-agent-development SKILL.md skill
jnpiyush/agentx · .github/skills/ai-systems/ai-agent-development/SKILL.md · Build production-ready AI agents with Microsoft Foundry and Agent Framework. Use when creating AI agents, selecting LLM…
git:20261010.87e53aa · audit A · 19 stars
ai-evaluation SKILL.md skill
jnpiyush/agentx · .github/skills/ai-systems/ai-evaluation/SKILL.md · Use when evaluating AI quality, safety, completeness and cost with held-out tasks, executable graders, calibrated…
v1.1.0 · audit A · 19 stars
ai-safety-and-red-teaming SKILL.md skill
jnpiyush/agentx · .github/skills/ai-systems/ai-safety-and-red-teaming/SKILL.md · Defend LLM systems against prompt injection, jailbreaks, data exfiltration, and unsafe output. Covers input/output…
v1.0.0 · audit B · 19 stars
anthropic-claude SKILL.md skill
jnpiyush/agentx · .github/skills/ai-systems/anthropic-claude/SKILL.md · Implement production applications with Anthropic Claude models -- Messages API, tool use, prompt caching, adaptive…
v1.0.0 · audit A · 19 stars

Every file in jnpiyush/agentx

Other files named database

database SKILL.md skill
bug-ops/zeph · .zeph/skills/database/SKILL.md · Query and manage SQLite, PostgreSQL, and MySQL databases from the command line. Use when the user asks to run SQL…
v1.0 · audit A · 66 stars
database SKILL.md skill
msrv-tech/skills · database/SKILL.md · Создание, запуск, обновление, загрузка и выгрузка информационных баз 1С, Git и ibcmd.
git:20260930.4d99096 · audit A · 62 stars
database SKILL.md skill
event4u-app/agent-config · src/skills/database/SKILL.md · Use when designing schemas and relations, tuning queries or indexes on any SQL engine, or multi-connection patterns —…
git:20261026.9af7ad3 · audit A · 19 stars
database Cursor rule
darknecrocities/skillbuilder · .cursor/rules/database.mdc · Architect, implement, and maintain resilient relational and NoSQL databases, zero-downtime schema migrations…
git:20261029.1aa6bef · audit A · 13 stars
database SKILL.md skill
darknecrocities/skillbuilder · skills/database/SKILL.md · Architect, implement, and maintain resilient relational and NoSQL databases, zero-downtime schema migrations…
git:20261029.dcec3fc · audit A · 13 stars
database SKILL.md skill
yamanidev/claude-code-configuration · skills/database/SKILL.md · Workflow for designing, querying, and reasoning about databases — schema modeling, normalization, keys/constraints…
git:20260717.6d13f3c · audit A · 9 stars
database SKILL.md skill
dayfinggg/openai-codex-agent-skills · codex/skills/database/SKILL.md · Inspects and changes SQL schemas, queries, indexes, migrations, ORM data access, and MongoDB documents, queries…
git:20261105.e0d5bb2 · audit A · 8 stars
database SKILL.md skill
umararshad4/honey-stack · skills/database/SKILL.md · Design schemas, write safe/online migrations, add indexes, fix slow queries and N+1, get transactions and concurrency…
git:20261017.c52b424 · audit A · 5 stars

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