Does this skill support both SQL and NoSQL databases?

Yes, while it has deep expertise in PostgreSQL and MySQL, it also provides design patterns and optimization strategies for NoSQL databases.

Can it help me fix slow database queries?

Absolutely. It uses EXPLAIN ANALYZE metrics to identify sequential scans and suggests specific indexing or query rewrites to improve execution time.

Does it provide guidance on data integrity?

Yes, it includes patterns for primary/foreign keys, check constraints, and exclusion constraints to prevent data corruption at the database level.

What is its approach to database migrations?

It follows a safety-first approach using transactions, concurrent index creation, and batching to ensure zero-downtime deployments.

Database Design & Optimization

Name: Database Design & Optimization
Author: julianromli

byjulianromli

•

101

•

数据库管理

Architects, optimizes, and migrates SQL and NoSQL database schemas using industry-standard best practices for performance and integrity.

The Database Design skill provides Claude with specialized knowledge to handle complex data modeling tasks, ranging from initial schema normalization to advanced query optimization. It offers production-ready patterns for PostgreSQL, MySQL, and NoSQL environments, including sophisticated indexing strategies like GIN and partial indexes. Whether you are building a new application from scratch or refactoring a legacy database for scale, this skill ensures your data layer is robust, performant, and capable of handling zero-downtime migrations.

主要功能

01Advanced indexing strategies (Composite, GIN, Partial, and Covering)

02Schema normalization and denormalization templates

03Zero-downtime migration patterns for high-traffic tables

04101 GitHub stars

05Data integrity enforcement via complex constraints and exclusion rules

06Query performance analysis using EXPLAIN ANALYZE and buffers

使用场景

01Optimizing slow-running SQL queries through index analysis and CTE refactoring

02Designing a scalable multi-tenant relational schema for a new SaaS platform

03Executing safe, multi-step migrations for adding columns to production databases

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add julianromli/opencode-template database-design

For use in Claude.ai and ChatGPT

Download Skill