DB Schema Expert — Data & AI agent for Claude Code
Use PROACTIVELY for anything touching prisma/schema.prisma, database migrations, raw SQL, slow query optimization, index design, data modeling, or PostgreSQL-specific features (JSONB, full-text sear.
How to install DB Schema Expert
Installs to ~/.claude/agents/johnmarvin237-claude-code-toolkit-db-schema-expert.md
mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/JohnMarvin237/claude-code-toolkit/HEAD/agents/db-schema-expert.md -o ~/.claude/agents/johnmarvin237-claude-code-toolkit-db-schema-expert.md Restart Claude Code, or start a new session, for it to be picked up.
What DB Schema Expert does
name: db-schema-expert description: Use PROACTIVELY for anything touching `prisma/schema.prisma`, database migrations, raw SQL, slow query optimization, index design, data modeling, or PostgreSQL-specific features (JSONB, full-text search, RLS, partitioning). MUST BE USED whenever a task requires a new model/field, a migration, or query performance investigation. Do NOT invoke for application-layer Prisma queries — route to `@backend-dev`. tools: Read, Write, Edit, Bash, Glob, Grep model: so
Alternatives in Data & AI
- Database Migration — Master database schema and data migrations across ORMs (Sequelize, TypeORM, Prisma), including rollb 31.9k ★
- Patina Detector — Triggers when Claude needs to find AI-writing patterns or suspect zones in KO/EN/ZH/JA text 352 ★
- Peer Reviewer Computational — A simulated peer reviewer specializing in computational social science methods — NLP/text-as-data, machine lea 134 ★
Full documentation available on GitHub
View Source RepositoryRelated Agents
PostgreSQL Expert
Designs and optimizes PostgreSQL schemas, queries, indexes, and migrations, reasoning from EXPLAIN plans and p
Postgres Pro
PostgreSQL database expert. Query optimization, index design, schema design, performance tuning, Prisma optimi
Agente Datos
Construye y extiende soluciones de datos al estilo del POC FHIR: JSON crudo en Postgres jsonb (equivalente ope
Hygiene Auditor
Scans a repository read-only for anything that must not be published — secrets, personal data, absolute home p
DB Designer
Use when designing or changing MongoDB schemas - new collections, embedding vs referencing decisions, index st
Database Design
Database Design Agent (PostgreSQL + Prisma)
Related Skills
Claude Code Postgres
Query a real PostgreSQL database in plain English from the terminal with Claude Code, safely: read-only role f
Bar Query
Direct read-only query against a BAR Observatory capture database (tools, timeline, errors, or raw SQL)
Add Database Railway
Set up PostgreSQL database with Prisma ORM and complete data layer.