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

•

Database Management

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.

Key Features

01Expert schema normalization and relational data modeling

0210 GitHub stars

03Robust transaction management and concurrency control patterns

04Production-safe migration strategy and script generation

05Idiomatic ORM implementation for SQLAlchemy and Django

06Advanced SQL query optimization and indexing techniques

Use Cases

01Designing a scalable relational database schema for a new enterprise application

02Refactoring legacy SQL queries to improve performance and reduce server load

03Generating and validating complex database migrations for evolving data structures

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add akaszubski/autonomous-dev database-design

For use in Claude.ai and ChatGPT

Download Skill