What databases are supported by this skill?

While the principles are universal, the skill provides specific best practices for major relational databases including PostgreSQL and MySQL.

When does this skill activate?

It automatically triggers when Claude detects tasks related to database schemas, SQL queries, migrations, or ORM configuration.

Can this skill help with ORM-specific code?

Yes, it includes specialized patterns for popular ORMs like SQLAlchemy and Django ORM to ensure efficient and idiomatic database interactions.

How does it assist with query optimization?

It analyzes query structures to suggest indexing strategies, identifies N+1 problems, and recommends refactors to improve execution speed.

Does it handle database migrations?

Yes, the skill provides guidance on writing versioned migrations that maintain data integrity and minimize downtime during deployments.

Database Design & Optimization

Name: Database Design & Optimization
Author: akaszubski

byakaszubski

•

数据库管理

Architects production-ready database schemas, manages migrations, and optimizes complex SQL queries for maximum performance.

关于

The Database Design skill transforms Claude into a senior data engineer capable of handling the entire lifecycle of relational data management. It provides specialized guidance on creating normalized schemas, implementing safe migration strategies, and optimizing slow-running queries through advanced indexing and transaction management. Designed for modern development workflows, it excels at implementing idiomatic ORM patterns for SQLAlchemy and Django, ensuring your backend infrastructure is scalable, maintainable, and performant across systems like PostgreSQL and MySQL.

主要功能

Expert schema normalization and relational data modeling
10 GitHub stars
Robust transaction management and concurrency control patterns
Production-safe migration strategy and script generation
Idiomatic ORM implementation for SQLAlchemy and Django
Advanced SQL query optimization and indexing techniques

使用场景

Designing a scalable relational database schema for a new enterprise application
Refactoring legacy SQL queries to improve performance and reduce server load
Generating and validating complex database migrations for evolving data structures

关于

主要功能

Expert schema normalization and relational data modeling
10 GitHub stars
Robust transaction management and concurrency control patterns
Production-safe migration strategy and script generation
Idiomatic ORM implementation for SQLAlchemy and Django
Advanced SQL query optimization and indexing techniques

使用场景

Designing a scalable relational database schema for a new enterprise application
Refactoring legacy SQL queries to improve performance and reduce server load
Generating and validating complex database migrations for evolving data structures