Guides architectural decisions for database selection, schema modeling, and performance optimization.
This skill empowers Claude to act as a senior database architect, moving beyond simple SQL generation to strategic data modeling and infrastructure planning. It provides a structured framework for choosing the right database engine (SQL vs. Serverless vs. SQLite) and ORM (Drizzle, Prisma, Kysely) based on specific project constraints. By focusing on normalization, indexing strategies, and query optimization, it ensures your data layer is scalable and performant while avoiding common anti-patterns like N+1 queries or unnecessary over-engineering.
주요 기능
01Context-aware database and ORM selection (PostgreSQL, SQLite, Neon, etc.)
02Performance tuning via index strategies and EXPLAIN ANALYZE patterns
030 GitHub stars
04Safe migration planning for serverless and traditional environments
05Prevention of common anti-patterns like N+1 queries and SELECT * usage
06Advanced schema design focusing on normalization and relationship types
사용 사례
01Migrating from a traditional RDBMS to a serverless database stack
02Designing a scalable relational schema for a new application
03Auditing and optimizing query performance and indexing strategies
