database-patterns

database-patterns is a skill for Claude Code from Wania-Kazmi/claude-code-autonomous-agent-workflow. It costs 38 tokens per session (2,767 once invoked), scanned A, original, no licence file.

A set of guidance for designing databases, writing SQL, using Prisma or Drizzle, and planning database changes. An ORM is a tool that lets application code work with database data using programming-language objects.

In plain words
What is it for?
Designing schemas, writing and improving SQL queries, using Prisma or Drizzle, and planning database migrations.
Why use it?
It helps avoid poorly designed tables, unsafe or inefficient queries, and migration problems when changing a database.

Skill for Claude Code

Written for Claude Code: allowed-tools in frontmatter.

Good fit Designing schemas, writing and improving SQL queries, using Prisma or Drizzle, and planning database migrations.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/wania-kazmi/claude-code-autonomous-agent-workflow/database-patterns
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add Wania-Kazmi/claude-code-autonomous-agent-workflow --skill database-patterns
Clone the repo
git clone --depth 1 https://github.com/Wania-Kazmi/claude-code-autonomous-agent-workflow

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for database-patterns

README.md
[![agentmods](https://agentmods.dev/badge/skills/wania-kazmi/claude-code-autonomous-agent-workflow/database-patterns/github.svg)](https://agentmods.dev/skills/wania-kazmi/claude-code-autonomous-agent-workflow/database-patterns)
Your own site
<a href="https://agentmods.dev/skills/wania-kazmi/claude-code-autonomous-agent-workflow/database-patterns"><img src="https://agentmods.dev/badge/skills/wania-kazmi/claude-code-autonomous-agent-workflow/database-patterns/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for database-patterns

Your own site · 80×15
<a href="https://agentmods.dev/skills/wania-kazmi/claude-code-autonomous-agent-workflow/database-patterns"><img src="https://agentmods.dev/badge/skills/wania-kazmi/claude-code-autonomous-agent-workflow/database-patterns.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 38 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,767 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin unknown No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00038 $0.02767
Opus 5.5 $0.00015 $0.01107
Sonnet 5.5 $0.00008 $0.00553
Haiku 4.5 $0.00004 $0.00277

Measured 1mo ago against content hash 2f3ff015718d, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

database-patterns scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.claude/skills/database-patterns/SKILL.md · 537 lines

The source is not reproduced here

No licence file

A repository with no LICENSE is all rights reserved by default, so the body is not copied here. The metadata, the measurements and the link are.

Read it on GitHub

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 1mo ago First seen · 537 lines · 38 tokens per session scan A 2f3ff015718d

Subscribe to this mod's changes

database-patterns is a skill published in the GitHub repository Wania-Kazmi/claude-code-autonomous-agent-workflow (5 stars, last pushed 9mo ago), with no licence file. It adds 38 tokens to every session and 2,767 once invoked, about $0.0002 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Related

Other skills, from other repositories

db-migration

Apply schema migrations safely: detect the tool, classify the change by risk, gate destructive ones behind approval, back up in prod, preview-apply-verify, roll back on failure. Use when a schema change is about to be applied to any environment.

byerlikaya/claude-starter-kit · 56 tokens

database-schema-designer

Use when designing new database tables from requirements, reviewing a schema for normalisation or performance issues, adding multi-tenancy, planning a breaking migration, or generating TypeScript/Python types from a schema. Triggers on "design the schema", "ERD", "table relationships", "schema migration", "normalise…

tmj-90/gaffer · 75 tokens

add-db-migration

Use when a ticket requires a database schema change — a new table/column, an index, a constraint, or a backfill. Invoke for "add a migration for X", "alter the schema", or any change to the persisted data model. Schema changes are high-risk; treat them carefully.

tmj-90/gaffer · 65 tokens

caching-strategy

Use when a ticket adds, changes, or debugs a cache — an in-memory memo, an HTTP cache header, a Redis layer, a CDN rule, a query-result cache — and the change must state what is cached, for how long, what invalidates it, and what happens when it is wrong. Invoke for "cache this", "it's showing stale data", "add…

tmj-90/gaffer · 95 tokens

migration-review

Use as a REVIEW LENS when judging another agent's diff that changes a database schema or data — a migration, a backfill, a dropped or renamed column, an index, a constraint — for irreversibility, locking, data loss, and deploy-order hazards before recommending approval. Invoke on every review whose diff touches a…

tmj-90/gaffer · 94 tokens

pagination-and-filtering

Use when a ticket exposes a list — an API collection endpoint, a table in the UI, an export — with paging, sorting, filtering, or search, and the result must be stable under concurrent writes, bounded in cost, and consistent with the repo's existing list conventions. Invoke for "list the X", "add pagination", "let…

tmj-90/gaffer · 95 tokens