Can it help with ORM implementation?

Yes, it includes best practice templates for SQLAlchemy ORM, including model definitions, relationship mapping, and audit timestamps.

Which databases are supported by this skill?

The database skill provides specific support and best practice patterns for PostgreSQL, MySQL, and SQLite.

Does it support modern data types like JSONB?

Absolutely. It provides specialized patterns for PostgreSQL JSONB operations, including GIN indexing and complex JSON querying.

Can this skill help optimize slow SQL queries?

Yes, it includes specialized tools for analyzing query plans (EXPLAIN ANALYZE), monitoring index usage, and identifying performance bottlenecks.

How does it handle database migrations?

The skill facilitates the creation of structured migration files with explicit BEGIN/COMMIT blocks and corresponding rollback scripts to ensure safe schema updates.

Database Management & Design

Name: Database Management & Design
Author: Lobbi-Docs

byLobbi-Docs

데이터베이스 관리

Optimizes database performance and manages schema design, migrations, and complex SQL query generation for relational databases.

소개

The Database Management skill provides comprehensive capabilities for building and maintaining robust data architectures within the Claude Code environment. It equips Claude with specialized knowledge for PostgreSQL, MySQL, and SQLite, covering everything from initial schema design and UUID-based data modeling to advanced query optimization using EXPLAIN ANALYZE. Whether you are managing complex migrations, writing high-performance SQL with Window functions and CTEs, or implementing SQLAlchemy ORM patterns, this skill ensures data integrity and performance through industry best practices.

주요 기능

SQL query generation and optimization for PostgreSQL, MySQL, and SQLite
Seamless integration with SQLAlchemy ORM and JSONB data modeling
Performance profiling using EXPLAIN ANALYZE and index usage statistics
Comprehensive migration management including rollback script generation
0 GitHub stars
Advanced schema design with UUIDs, indexing, and soft-delete patterns

사용 사례

Debugging and optimizing slow-running SQL queries to improve application latency
Automating database migration workflows for evolving data requirements
Designing and implementing relational schemas for high-scale microservices

소개

주요 기능

SQL query generation and optimization for PostgreSQL, MySQL, and SQLite
Seamless integration with SQLAlchemy ORM and JSONB data modeling
Performance profiling using EXPLAIN ANALYZE and index usage statistics
Comprehensive migration management including rollback script generation
0 GitHub stars
Advanced schema design with UUIDs, indexing, and soft-delete patterns

사용 사례

Debugging and optimizing slow-running SQL queries to improve application latency
Automating database migration workflows for evolving data requirements
Designing and implementing relational schemas for high-scale microservices