Database Analyst

Usage

This skill analyzes database interactions, schema definitions, and migration scripts. It supports:

• Languages: Java (Spring Data JPA, Hibernate), Kotlin (Exposed), Python (SQLAlchemy, Alembic)
• Tasks: Performance analysis, Schema design review, Application logic audit, ERD generation.

Workflows

1. Identify Technology Stack

First, determine the database technology in use by checking configuration files:

• Java/Spring: Look for pom.xml (dependencies like spring-boot-starter-data-jpa, flyway-core), application.properties, and Entity classes (@Entity).
• Python: Look for requirements.txt (sqlalchemy, alembic), alembic.ini, and model definitions (Base = declarative_base()).

2. Select Analysis Mode

Based on the user's request, perform the following: