crud

crud is a skill for Claude Code, Codex from Chachamaru127/codex-harness. It costs 57 tokens per session (816 once invoked), scanned A, original, MIT.

A workflow that generates create, read, update, and delete operations—often called CRUD—for a database entity such as a task or user. It can include validation, permissions, relationships, search, filters, pagination, and tests.

In plain words
What is it for?
Use it to create API endpoints and related functionality for entities, including validation, authorization, database relationships, search, filtering, pagination, and tests.
Why use it?
It removes repetitive setup for database-backed features while fitting the existing database and code. It also helps cover common safety checks and access rules.

Skill for Claude CodeCodex

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.

agentmods
npx agentmods add skills/chachamaru127/codex-harness/crud
Any agent
npx skills add Chachamaru127/codex-harness --skill crud
Clone the repo
git clone --depth 1 https://github.com/Chachamaru127/codex-harness

Made for: Claude Code, Codex.

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 crud

README.md
[![agentmods](https://agentmods.dev/badge/skills/chachamaru127/codex-harness/crud.svg)](https://agentmods.dev/skills/chachamaru127/codex-harness/crud)
Your own site
<a href="https://agentmods.dev/skills/chachamaru127/codex-harness/crud"><img src="https://agentmods.dev/badge/skills/chachamaru127/codex-harness/crud.svg" alt="Measured on agentmods" height="20"></a>
Per session 57 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 816 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original 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 $0.00057 $0.00816
Opus 5 $0.00028 $0.00408
Sonnet 5 $0.00011 $0.00163
Haiku 4.5 $0.00006 $0.00082

Measured 4d ago against content hash c34c6c81f480, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

crud 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 4d 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.

.codex/skills/crud/SKILL.md · 110 lines

How it starts

The opening of the file, as written. The whole thing — 110 lines — stays where its author put it; the contents beside it link to each section on GitHub.

CRUD Skill

Auto-generates CRUD functionality for specified entities (tables) at production-ready level.

Quick Reference

  • "Create CRUD for task management" → /crud tasks
  • "Want search and pagination too" → Includes all together
  • "Include permissions (who can view/edit)" → Sets up authorization/rules together

Deliverables

  • CRUD + validation + authorization + tests, complete production-safe set
  • Minimize diff to match existing DB/code

Features:

  • Validation (Zod) auto-add
  • Auth/authorization (Row Level Security) auto-config
  • Relations (one-to-many, many-to-many) support
  • Pagination, search, filters
  • Auto-generated test cases

Auto-invoke Skills

This skill must explicitly invoke the following skills with the Skill tool:

Skill Purpose When to Call
impl Implementation (parent skill) CRUD feature implementation
verify Verification (parent skill) Post-implementation verification

Execution Flow

Detailed steps are described in the phases below.

Phase 1: Entity Analysis

  1. Parse entity name from $ARGUMENTS
  2. Detect existing schema (Prisma, Drizzle, raw SQL)
  3. Infer field types and relations

Phase 2: CRUD Generation

  1. Generate model/schema if needed
  2. Create API endpoints (REST or tRPC)
  3. Add validation schemas (Zod)
  4. Configure authorization rules

Phase 3: Test Generation

  1. Create unit tests for each endpoint
  2. Add integration tests
  3. Generate test fixtures

Phase 4: Verification

  1. Run type check
  2. Run tests
  3. Verify build

Supported Frameworks

Framework Detection Generated Files
Next.js + Prisma prisma/schema.prisma API routes, Prisma client
Next.js + Drizzle drizzle.config.ts API routes, Drizzle queries
Express express in package.json Controllers, routes
Hono hono in package.json Route handlers

Read the full file on GitHub · 110 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

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. 4d ago First seen · 110 lines · 57 tokens per session scan A c34c6c81f480

Subscribe to this mod's changes

crud is a skill published in the GitHub repository Chachamaru127/codex-harness (2 stars, last pushed 6mo ago), licensed MIT. It adds 57 tokens to every session and 816 once invoked, about $0.0003 per session on Opus 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

systematic-debugging

Use when encountering any bug, test failure, or unexpected behavior, before proposing fixes.

obra/superpowers · 21 tokens

local-ai-agents

Build local-first AI agents that run entirely on a developer workstation with Microsoft Foundry Local and Qwen function-calling models. Covers Small Language Models (SLMs), the OpenAI-compatible local endpoint, sandboxed local tools, local RAG with Chroma, local MCP servers, hybrid cloud/local routing, and the…

microsoft/ai-agents-for-beginners · 200 tokens

chronicle

Analyze Copilot session history for standup reports, usage tips, session search, and session reindexing. Use when the user asks for a standup, daily summary, usage tips, workflow recommendations, wants to search or find past sessions by keyword/file/PR, wants to reindex their session store, or asks about deleting…

microsoft/vscode · 72 tokens

imagegen

Generate or edit raster images when the task benefits from AI-created bitmap visuals such as photos, illustrations, textures, sprites, mockups, or transparent-background cutouts. Use when Codex should create a brand-new image, transform an existing image, or derive visual variants from references, and the output…

openai/codex · 113 tokens

chat-pet-sprite-creation

Use when creating or changing VS Code chat pet sprite art, sprite sheets, state animations, eye treatments, Stable/Insiders variants, or pet transitions under src/vs/workbench/contrib/chat/browser/widget/media/chatPet.

microsoft/vscode · 53 tokens

cpu-profile-analysis

Analyze V8/Chrome CPU profiles (.cpuprofile) and DevTools trace files (Trace-.json). Use when: profiling performance, investigating slow functions, comparing code paths, finding bottlenecks, analyzing timeToRequest, understanding call trees from sampling profiler data, analyzing layout/paint/rendering, investigating…

microsoft/vscode · 71 tokens