DB Opt — Data skill for Claude Code
Identifies and optimizes slow database queries and schema bottlenecks.
How to install DB Opt
Installs to ~/.claude/commands/pedrol-cmd-brain-drin-db-opt.md
mkdir -p ~/.claude/commands && curl -fsSL https://raw.githubusercontent.com/pedrol-cmd/brain-drin/HEAD/.claude/commands/db-opt.md -o ~/.claude/commands/pedrol-cmd-brain-drin-db-opt.md Restart Claude Code, or start a new session, for it to be picked up.
What DB Opt does
description: Identifies and optimizes slow database queries and schema bottlenecks.
/db-opt
Optimizes your data persistence layer.
Usage
- Provide a slow query or an execution plan (
EXPLAIN). - The agent will suggest indexes, query rewrites, or schema changes.
- Verifies the performance improvement.
Specialist Agent
@database-architect
Alternatives in Data
- SQL Queries — Generate SQL queries from natural language across major dialects 7.8k ★
- Aoci Code — Local-first MCP server + CLI in Go: a persistent, governed codebase index that distills code and database sche 443 ★
- Symfony Migrations — Create and manage Doctrine migrations for database schema changes 206 ★
Full documentation available on GitHub
View Source RepositoryRelated Skills
Database Optimizer
Optimize SQL queries, design efficient indexes, and handle database migrations. Solves N+1 problems, slow quer
Pg Slow
Find the queries eating your PostgreSQL database (pgbot)
DB Profile
Profile database queries with EXPLAIN ANALYZE, diagnose slow scans, and recommend indexes.
CI Optimize
Optimize CI pipeline performance. Analyzes execution time, improves caching, parallelization, and identifies b
SQL Optimizer
Analyzes a SQL query and execution plan, identifies bottlenecks, and proposes a faster equivalent.
Optimize Database.Prompt
Analyze and optimize database schema, queries, and performance
Related Agents
Database Optimization
Database performance optimization and query tuning specialist. Use PROACTIVELY for slow queries, indexing stra
Supabase Optimizer
Proactively optimizes Supabase database performance, cost efficiency, and scalability. Use for analyzing slow
PostgreSQL Expert
Designs and optimizes PostgreSQL schemas, queries, indexes, and migrations, reasoning from EXPLAIN plans and p