How does this skill help choose between different databases?

The skill evaluates project requirements like deployment environment, scalability needs, and complexity to recommend the best fit, such as SQLite for simplicity or Neon for serverless PostgreSQL.

Does this skill automate database migrations?

It provides the decision-making framework and best practices for safe migrations, ensuring schema changes are handled correctly across different environments.

Can it help fix slow database queries?

Yes, it provides guidance on indexing strategies, EXPLAIN ANALYZE interpretation, and identifying N+1 query patterns to significantly improve performance.

Which ORMs are supported by this skill?

It includes specialized knowledge for modern ORMs and query builders including Drizzle, Prisma, and Kysely, helping you choose the right level of abstraction.

Database Design Architect

Name: Database Design Architect
Author: claudiodearaujo

byclaudiodearaujo

•

数据库管理

Architects efficient, scalable database schemas and selects optimal data stacks based on specific project requirements.

The Database Design Architect skill empowers Claude to move beyond generic SQL patterns by applying rigorous architectural principles to data modeling. It guides the selection of databases—such as PostgreSQL, SQLite, or Neon—and ORMs like Drizzle or Prisma by analyzing the specific deployment context and performance needs. By enforcing best practices in normalization, strategic indexing, and migration planning, this skill ensures that backend systems are built on a robust, performant foundation while avoiding common pitfalls like N+1 queries and improper data types.

主要功能

01Automated schema normalization and relationship mapping

02Detection and prevention of common database anti-patterns

03Safe migration planning for serverless and traditional environments

04Performance-driven indexing and query optimization strategies

05Contextual database and ORM selection (PostgreSQL, SQLite, Neon, Drizzle, Prisma)

061 GitHub stars

使用场景

01Architecting a new serverless backend with optimized data structures

02Refactoring existing schemas to improve query performance and scalability

03Selecting the right database stack for a specific deployment environment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro database-design

For use in Claude.ai and ChatGPT

Download Skill