Database Architect & Schema Designer

概要

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.

主な機能

• Context-aware database and ORM selection (PostgreSQL, SQLite, Neon, etc.)
• Performance tuning via index strategies and EXPLAIN ANALYZE patterns
• 0 GitHub stars
• Safe migration planning for serverless and traditional environments
• Prevention of common anti-patterns like N+1 queries and SELECT * usage
• Advanced schema design focusing on normalization and relationship types

ユースケース

• Migrating from a traditional RDBMS to a serverless database stack
• Designing a scalable relational schema for a new application
• Auditing and optimizing query performance and indexing strategies