Optimizes database architecture by providing expert guidance on schema design, ORM selection, and performance indexing.
The Database Design skill empowers Claude to act as a senior database architect, moving beyond generic SQL generation to provide strategic data modeling and infrastructure advice. It guides the selection of databases (such as PostgreSQL, Neon, or SQLite) and ORMs (like Drizzle, Prisma, or Kysely) based on specific project contexts while enforcing industry best practices for normalization, indexing, and migration management. This skill is essential for developers building data-intensive applications who need to ensure long-term scalability and query efficiency from the initial design phase.
Características Principales
010 GitHub stars
02Strategic indexing and query performance optimization patterns
03Context-aware database and ORM selection (PostgreSQL, Neon, Turso, SQLite)
04Best practices for safe migrations and serverless database environments
05Identification and resolution of anti-patterns like N+1 queries and SELECT *
06Advanced schema normalization and relationship mapping guidance
Casos de Uso
01Migrating from traditional database setups to serverless architectures like Neon or Turso
02Designing a scalable relational schema for a new full-stack SaaS application
03Optimizing slow database queries through strategic indexing and EXPLAIN ANALYZE logic