Can it help me choose between different ORMs?

Yes, it evaluates tools like Drizzle, Prisma, and Kysely against your project's needs to help you select the most appropriate ORM for your workflow.

Does it support serverless database environments?

Absolutely. The skill includes dedicated decision-making frameworks for serverless-first databases like Neon and Turso.

How does this skill help with database performance?

It provides specific strategies for indexing, query optimization using EXPLAIN ANALYZE, and identifies N+1 query issues to ensure high-efficiency data retrieval.

Will it help me write migrations?

Yes, it offers best practices for creating safe, reversible migrations and managing schema changes without downtime.

Database Design & Architecture

Name: Database Design & Architecture
Author: claudiodearaujo

byclaudiodearaujo

データベース管理

Architects scalable, performant database schemas and selects optimal data persistence tools based on specific project requirements.

概要

The Database Design skill transforms Claude into a strategic data architect that prioritizes critical thinking over boilerplate SQL patterns. It provides expert guidance on selecting the right database engine—ranging from PostgreSQL to serverless options like Neon or Turso—and the most suitable ORM for your stack. By focusing on normalization, advanced indexing strategies, and query optimization, this skill ensures your data layer is efficient, maintainable, and free from common performance bottlenecks like N+1 queries.

主な機能

Strategic schema design focusing on normalization and relationship modeling
Performance tuning via N+1 query detection and EXPLAIN ANALYZE guidance
Migration planning for safe schema updates in production and serverless environments
Context-aware database and ORM selection (PostgreSQL, SQLite, Drizzle, Prisma, etc.)
Advanced indexing strategies including composite and specialized index types
0 GitHub stars

ユースケース

Refactoring legacy database schemas to improve query performance and scalability
Architecting the initial data model for a new full-stack application
Optimizing application performance by resolving complex relationship and indexing issues

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/izacenter database-design

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要