hainrixz/claude-db

1

db-connection-pooling Audit connection management — serverless functions opening direct Postgres connections, transaction-mode pooler misus…

hainrixz/claude-db

68

2

db-normalization Audit relational schema normalization — 1NF through 3NF violations, repeating groups and CSV-in-a-column, partial and…

hainrixz/claude-db

67

3

db-multitenancy Audit multi-tenant data isolation — tenant model fit (shared rows vs schema vs database), missing or unenforced tenan…

hainrixz/claude-db

66

4

audit Audit a database schema, ORM model, or migrations for design and performance — produces two independent 0-100 scores …

hainrixz/claude-db

64

5

db-indexing Audit index coverage for the query workload — composite index column order (ESR), covering and partial indexes, speci…

hainrixz/claude-db

64

6

db-security-access Audit access control and data protection — Row-Level Security state, PII handling, encryption at-rest and in-transit …

hainrixz/claude-db

64

7

checklist Render a production-readiness GO/NO-GO grid for a database — runs a read-only audit, then maps the findings onto a fi…

hainrixz/claude-db

63

8

db-index-hygiene Audit index bloat — exact-duplicate indexes, redundant indexes whose key is a prefix of another, and unused indexes t…

hainrixz/claude-db

63

9

fix Opt-in writer (the /claude-db:fix command). Applies the safe, reversible schema/migration changes from an audit — add…

hainrixz/claude-db

63

10

db-concurrency Audit concurrency correctness — transaction isolation level, lost-update / read-modify-write races, queue-worker cont…

hainrixz/claude-db

62

11

db-constraints Audit data-integrity constraints — missing NOT NULL on required columns, absent CHECK constraints for domain rules, m…

hainrixz/claude-db

62

12

db-defaults-generated Audit column defaults and generated columns — application-side timestamps that should be DB defaults, non-determinist…

hainrixz/claude-db

62

13

db-engine-selection Engine selection (M0) — at design/start time, recommends a database paradigm and engine for a described workload (acc…

hainrixz/claude-db

62

14

db-keys Audit primary-key strategy — missing PK (severity 5), surrogate vs natural keys, UUIDv4 index fragmentation vs time-o…

hainrixz/claude-db

62

15

db-migration-safety Migration-safety lint (M22) — the static contract the migration-safety auditor (MSA) and db-migration-writer enforce …

hainrixz/claude-db

62

16

db-naming Audit naming conventions — inconsistent table/column casing and pluralization, ambiguous or reserved-word identifiers…

hainrixz/claude-db

62

17

db-orchestrator Orchestrates a full database audit — detects the stack(s), dispatches read-only auditor subagents in parallel by para…

hainrixz/claude-db

62

18

db-query-patterns Audit query-shape anti-patterns — SELECT *, structural N+1 (directional), OFFSET pagination vs keyset, and non-SARGab…

hainrixz/claude-db

62

19

db-referential-integrity Audit foreign-key integrity — missing FKs that allow orphan rows (financial/auth = severity 5), absent or unsafe ON D…

hainrixz/claude-db

62

20

db-storage-bloat Audit storage operability — VACUUM / autovacuum health and table-and-index bloat, transaction-ID wraparound risk (sev…

hainrixz/claude-db

62

21

db-types-precision Audit column types and precision — money stored as float/double (severity 5), naive timestamp vs timestamptz/UTC, jso…

hainrixz/claude-db

62

22

design Greenfield database design — pick the right engine for a new project, compare it against the boring default, and hand…

hainrixz/claude-db

62

23

introspect Tier-1 live read-only introspection. Connects to the running database through a DB MCP server's read-class tools (pre…

hainrixz/claude-db

62

24

score Recompute and display the two database scores (Design & Integrity + Performance & Scale) from a findings JSON, withou…

hainrixz/claude-db

62

25

stack-detect Detects the database stack(s) of a project — paradigm, engine, ORM, platform, and the authoritative source_of_truth —…

hainrixz/claude-db

62

26

db-partitioning-sharding Audit horizontal scaling topology — declarative partitioning fit for large/time-series tables, hot-partition / skewed…

hainrixz/claude-db

61

27

db-platform-fit Managed-platform fitness (M21) — checks the project against the realities of its hosting platform (Supabase, Neon, Pl…

hainrixz/claude-db

61

28

db-replicas-views Audit read-scaling correctness — read-your-writes consistency when reads are routed to replicas, and materialized-vie…

hainrixz/claude-db

61

29

db-specialized-fit Specialized-engine fitness (M20) — checks whether a vector, time-series/OLAP, graph, or search store is configured co…

hainrixz/claude-db

61

30

explain Explain a database schema, model, or a single finding in plain language, with a paradigm-aware diagram — what the tab…

hainrixz/claude-db

61

31

migrate Lint a database migration for safety before it runs — classify lock level, table rewrite, and reversibility; flag des…

hainrixz/claude-db

61

32

next Coach the user on what to fix first — rank the audit findings into a single, ordered to-do list by score impact and e…

hainrixz/claude-db

61

33

seed Generate FK-aware, deterministic sample/seed data from a database schema, ORM model, or migrations — INSERT statement…

hainrixz/claude-db

61

34

start Guided, jargon-free starting point for people with no schema and no database yet — a short 7-question wizard that tur…

hainrixz/claude-db

61

35

db-temporal-history Audit temporal and lifecycle modeling — soft-delete consistency and its uniqueness/query traps, presence and integrit…

hainrixz/claude-db

60