Can it help me write safer database migrations?

Yes, it includes a comprehensive migration review checklist to ensure migrations are reversible, prevent data loss, and avoid table locking on large datasets.

Does it enforce database design best practices?

Absolutely. It guides users toward 3NF normalization, singular table naming, consistent primary/foreign key patterns, and proper index selection.

What databases and ORMs does this skill support?

This skill supports PostgreSQL, MySQL, and SQLite, with specialized patterns for Prisma, Drizzle, and TypeORM.

Is this skill useful for full-text search or JSON columns?

Yes, it contains database-specific patterns for advanced features like GIN indexes for JSONB in PostgreSQL and full-text search in MySQL.

How does this skill help with performance bottlenecks?

It provides tools for identifying slow queries using EXPLAIN ANALYZE and offers specific patterns to solve N+1 query problems using eager loading and joins.

Database Workflows & Optimization

Name: Database Workflows & Optimization
Author: hgeldenhuys

byhgeldenhuys

•

Database Management

Streamlines database schema design, migration management, and query performance optimization across major ORMs and SQL dialects.

The Database Workflows skill empowers Claude to act as an expert Database Administrator and backend architect. It provides standardized patterns for designing normalized schemas, reviewing migration safety, and identifying performance bottlenecks like N+1 queries. Whether you are working with Prisma, Drizzle, or TypeORM, this skill ensures best practices are followed—from enforcing naming conventions to implementing advanced indexing strategies for PostgreSQL, MySQL, and SQLite. It is an essential tool for maintaining high-performance, scalable, and well-structured data layers.

Key Features

01Proactive N+1 query detection and prevention patterns for popular ORMs

02Query performance analysis using EXPLAIN ANALYZE and intelligent indexing

03Database-specific optimization guides for PostgreSQL, MySQL, and SQLite

04Migration safety audits including reversibility and data loss prevention

05Automated schema review for 3NF normalization and consistent naming conventions

061 GitHub stars

Use Cases

01Designing a scalable database schema for a new application feature

02Validating ORM migrations to prevent production downtime or data loss during deployment

03Reviewing and refactoring slow database queries in an existing production codebase

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hgeldenhuys/claude-code-sdk database-workflows

For use in Claude.ai and ChatGPT

Download Skill