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

0•

Database Management

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.

Key Features

01SQL query generation and optimization for PostgreSQL, MySQL, and SQLite

02Seamless integration with SQLAlchemy ORM and JSONB data modeling

03Performance profiling using EXPLAIN ANALYZE and index usage statistics

04Comprehensive migration management including rollback script generation

050 GitHub stars

06Advanced schema design with UUIDs, indexing, and soft-delete patterns

Use Cases

01Debugging and optimizing slow-running SQL queries to improve application latency

02Automating database migration workflows for evolving data requirements

03Designing and implementing relational schemas for high-scale microservices

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lobbi-docs/claude database

For use in Claude.ai and ChatGPT

Download Skill