skills.rest
ddobrin
ddobrinCOMMUNITY
Explore all skills by this author →
Website𝕏@ddobrinGitHub

database-analyst

Analyze database interactions, schemas, and migrations for performance issues and design flaws.

39|6|Updated Nov 7, 2025
Search Tags:#performance#database#audit#migration#orm#analyze#erd
One-click install
npx skills add https://github.com/ddobrin/gemini-plan-commands --skill database-analyst
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-analyst
Source: https://github.com/ddobrin/gemini-plan-commands/tree/main/skills/database-analyst
Command: npx skills add https://github.com/ddobrin/gemini-plan-commands --skill database-analyst

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill analyzes database interactions, schema definitions, and migration scripts to help teams identify performance issues, design flaws, and drift between models and reality.

Core Features & Use Cases

  • Performance analysis of queries, indexes, and migrations.
  • Schema design review and ERD generation.
  • Application logic audit across Java (Spring Data JPA, Hibernate), Kotlin (Exposed), and Python (SQLAlchemy, Alembic).
  • Migration script review and anti-pattern detection.

Quick Start

Analyze the current project’s database layer and generate an ERD with recommended optimizations.

Frequently Asked Questions about database-analyst

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I detect N+1 queries and missing indexes in my database schema?▼

Database schema analysis detects N+1 queries and missing indexes by auditing application logic and schema definitions. It reviews ORM interactions across Java, Kotlin, and Python projects to pinpoint performance issues and suggest concrete improvements for query efficiency.

Can I analyze SQLAlchemy and Alembic migrations for anti-patterns and risks?▼

Yes, migration script review supports Python projects using SQLAlchemy and Alembic. The database analysis identifies migration risks and anti-patterns, helping teams catch design flaws and drift between models and reality before deployment.

How do I generate an ERD and review database schema design for my project?▼

Schema design review and ERD generation analyze your current project's database layer to map entity relationships. This process evaluates schema definitions and interactions to identify design flaws and recommend structural optimizations.

Does this database audit support Spring Data JPA, Hibernate, and Kotlin Exposed?▼

Application logic audit covers Java with Spring Data JPA and Hibernate, plus Kotlin with Exposed. The database analysis reviews ORM interactions and schema definitions across these frameworks to identify performance issues and design flaws.

What's the best way to identify drift between ORM models and actual database migrations?▼

Analyzing database interactions and migration scripts identifies drift between ORM models and reality. The audit evaluates schema definitions against application logic to detect design flaws, migration risks, and missing indexes across your codebase.

Why does my database migration script fail the performance audit?▼

Migration script review detects anti-patterns and migration risks that cause performance issues. The database audit analyzes schema definitions and interactions to identify design flaws, suggesting concrete improvements to resolve script failures.

Related Skills

Explore More Software Engineering Skills→
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate
VilnaCRM-OrgVilnaCRM-Org
5

query-performance-analysis

Detect and fix N+1 queries, slow queries, and missing indexes in MongoDB-backed PHP endpoints.

Official
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
omanjayaomanjaya

database-performance

Identify and implement database performance optimizations for queries, schemas, and caching.

Community
Advanced