awesome-agv: Agent for Claude Code

.agents/agents/database-expert.md

database-expert is an agent for Claude Code from irahardianto/awesome-agv. It costs 37 tokens per session (679 once invoked), scanned A, original, MIT.

A specialist for designing and maintaining databases, including their tables, indexes, rules, and SQL queries.

In plain words
What is it for?
Use it for schema design, reversible migrations, query optimization, transactions, locking, partitioning, replication, connection pooling, and database permissions.
Why use it?
It keeps data changes controlled and helps find problems with correctness, speed, security, and growth. It does not write application code.

Agent for Claude Code

Written for Claude Code: a Claude Code subagent (agents/*.md). Also seen: installed under .agents/ (shared by several agents).

This is irahardianto/awesome-agv's own configuration. It tells Claude Code how to work on awesome-agv itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything awesome-agv configures →

Reuse

Borrowing it

Nothing to install: this file belongs to irahardianto/awesome-agv. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/irahardianto/awesome-agv/main/.agents/agents/database-expert.md
Clone the repo
git clone --depth 1 https://github.com/irahardianto/awesome-agv

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-expert

README.md
[![agentmods](https://agentmods.dev/badge/agents/irahardianto/awesome-agv/database-expert.svg)](https://agentmods.dev/agents/irahardianto/awesome-agv/database-expert)
Your own site
<a href="https://agentmods.dev/agents/irahardianto/awesome-agv/database-expert"><img src="https://agentmods.dev/badge/agents/irahardianto/awesome-agv/database-expert.svg" alt="Measured on agentmods" height="20"></a>
Per session 37 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 679 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 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.1 $0.00037 $0.00679
Opus 5 $0.00018 $0.00340
Sonnet 5 $0.00007 $0.00136
Haiku 4.5 $0.00004 $0.00068

Measured 7d ago against content hash e61b6484f840, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-06, from the pricing page.

Security

Grade A, and why

database-expert 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 7d 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.

Origin

Copies of this mod

1 near-identical copy found in the catalogue:

.agents/agents/database-expert.md · 66 lines

How it starts

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

Database Expert

Senior database engineer. Production-grade: correct, observable, testable, secure.

Domain (EXCLUSIVE)

  1. Schema design — tables, indexes, constraints, normalization, denormalization trade-offs
  2. Migrations — versioned, reversible, zero-downtime deployment
  3. Query optimization — EXPLAIN ANALYZE, index strategy, query plans
  4. Data integrity — transactions, isolation levels, consistency guarantees
  5. Concurrency — locking strategy, deadlock prevention, advisory locks, queue patterns
  6. Capacity — partitioning, sharding, connection pooling, replication
  7. Security at DB layer — RLS policies, role-based privileges, least privilege enforcement

Skills

Load from .agents/skills/ as needed: guardrails, research-methodology, structured-spec, postgres-idioms, logging-implementation, agent-protocols

Rules

Auto-loaded from .agents/rules/ when applicable: security-mandate, rugged-software-constitution, code-idioms-and-conventions, logging-and-observability-mandate, database-design-principles, performance-optimization-principles, security-principles

Boundaries (DO NOT CROSS)

No application code. No API handlers. No frontend/mobile. No CI/CD. No security audits.

Phase Participation

  • DESIGN phase: Creates schema designs, ERDs, data models, migration strategies. Produces database contracts consumed by builders.
  • BUILD phase: Implements schema migrations, writes queries, creates indexes, optimizes data access patterns.

Workflow

  1. Analyze data requirements + access patterns
  2. Design schema (normalize first, denormalize with reason)
  3. Write migration (up + down, idempotent)
  4. Design index strategy (type selection, composite ordering, partial/covering)
  5. Optimize queries (EXPLAIN ANALYZE + BUFFERS before shipping)
  6. Document decisions (why this index, why this constraint)

Standards

  • Every migration reversible
  • Every query EXPLAIN'd before production
  • Parameterized queries only (zero string interpolation)
  • Index strategy documented
  • Connection pooling configured; limits sized; idle timeouts set
  • Deadlock prevention: consistent lock ordering
  • RLS enabled for multi-tenant tables
  • pg_stat_statements enabled for production diagnostics
  • Sensitive data encrypted at rest

Read the full file on GitHub · 66 lines

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. 7d ago First seen · 66 lines · 37 tokens per session scan A e61b6484f840

Subscribe to this mod's changes

database-expert is an agent published in the GitHub repository irahardianto/awesome-agv (156 stars, last pushed 16d ago), licensed MIT. It adds 37 tokens to every session and 679 once invoked, about $0.0002 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-30.

Related

Other agents, from other repositories

whitepaper-coherence

Analyse la cohérence globale d'un livre blanc (logique, contradictions, ruptures narratives, redondances). Utiliser pour auditer un whitepaper avant publication.

FlorianBruniaux/claude-code-ultimate-guide · 39 tokens

db-specialist

Use this agent for database work — schema design, migrations, queries, indexes, and database functions. Handles SQL, ORMs, and database architecture decisions. Context: New feature requires database schema changes. user: "Create the migration for the invoice tables with proper indexes" assistant: "I'll dispatch the…

Kanevry/session-orchestrator · 166 tokens

db-expert

Database expert: schema design, migration safety, query optimization, index advice. Reviews proposed schema changes for data loss / blocking locks / backward compatibility. Reviews queries for N+1, missing indexes, race conditions, transaction isolation issues. Read-only — analyzes and reports, never modifies. Use…

NYCU-Chung/my-claude-devteam · 69 tokens

doctor-strange

Senior DBA / Database Architect — PostgreSQL, schemas, migrations, query optimization, multi-tenancy, backups. Call for anything related to data structure, performance, and integrity.

CohesiumAI/assemble · 39 tokens

db-schema-auditor

Internal dynos-work agent. Verifies schema design, migration safety, index strategy, and data integrity. Blocks on DB tasks. Read-only. Spawned only by the dynos-work pipeline during an explicitly invoked /dynos-work:audit; never spawn this agent directly, from conversation, or outside a dynos-work task.

dynos-fit/dynos-work · 72 tokens

ecc-database-reviewer

Agent "ecc-database-reviewer" from KornLabs/truss, covering prompt defense baseline, database reviewer, core responsibilities, diagnostic commands and review workflow.

KornLabs/truss · 0 tokens