DB Profile — Data skill for Claude Code
Profile database queries with EXPLAIN ANALYZE, diagnose slow scans, and recommend indexes.
How to install DB Profile
Installs to ~/.claude/skills/doodleino-nexus-os-db-profile/SKILL.md
mkdir -p ~/.claude/skills/doodleino-nexus-os-db-profile && curl -fsSL https://raw.githubusercontent.com/doodleino/nexus-os/HEAD/commands/db-profile.md -o ~/.claude/skills/doodleino-nexus-os-db-profile/SKILL.md Restart Claude Code, or start a new session, for it to be picked up.
What DB Profile does
description: Profile database queries with EXPLAIN ANALYZE, diagnose slow scans, and recommend indexes. agent: database-reviewer subtask: true
Database Query Profiling Command
Profile SQL queries, inspect execution plans via `EXPLAIN (ANALYZE, BUFFERS)`, detect sequential scans and lock contention, and generate index and rewrite recommendations.
Usage
`/db-profile [query-or-file] [--engine postgres|mysql|sqlite] [--buffers] [--format text|json|markdown]`
query-or-file(opti
Alternatives in Data
- SQL Queries — Generate SQL queries from natural language across major dialects 7.8k ★
- Build Failure — Diagnose elasticsearch-js CI and local build failures 5.3k ★
- Portaljs Architect — Recommend a data-portal architecture (storage, compute, catalog, access, hosting, metadata) from your needs, t 2.3k ★
Full documentation available on GitHub
View Source RepositoryRelated Skills
DB Opt
Identifies and optimizes slow database queries and schema bottlenecks.
Pg Slow
Find the queries eating your PostgreSQL database (pgbot)
Optimize Database.Prompt
Analyze and optimize database schema, queries, and performance
Pipeline Reviewer
Analyze CRM pipeline data to identify risks, recommend actions, and generate a weekly pipeline summary.
Read Only Postgres
by jawwadfirdousi - Read-only PostgreSQL query skill for Claude Code. Executes SELECT/SHOW/EXPLAIN/WITH querie
Analyse Queries
Analyse SQL queries and ORM code for performance issues and missing indexes
Related Agents
PostgreSQL Expert
Designs and optimizes PostgreSQL schemas, queries, indexes, and migrations, reasoning from EXPLAIN plans and p
DB Designer
Use when designing or changing MongoDB schemas - new collections, embedding vs referencing decisions, index st
Supabase Optimizer
Proactively optimizes Supabase database performance, cost efficiency, and scalability. Use for analyzing slow