Does this skill handle database migrations?

It provides best practices for executing safe migrations, particularly in serverless environments, to ensure schema changes don't result in downtime or data loss.

How does this skill help with database performance?

It provides specific strategies for indexing, N+1 query detection, and EXPLAIN ANALYZE interpretation to ensure efficient data retrieval and minimal latency.

Can it help me choose the right ORM?

Yes, the skill includes decision-making frameworks to help you choose between Drizzle, Prisma, or Kysely based on performance, type-safety, and developer experience.

Which databases does this skill support?

It offers guidance for PostgreSQL, SQLite, Neon, Turso, and other popular relational and serverless databases based on your specific infrastructure needs.

Database Design & Architecture

Name: Database Design & Architecture
Author: sickn33

bysickn33

•

31,721

•

Database Management

Guides the creation of optimized database schemas, indexing strategies, and ORM selections tailored to specific application contexts.

This skill transforms Claude into a senior database architect capable of navigating complex data modeling decisions. It moves beyond generic SQL generation by providing structured frameworks for schema normalization, performance tuning through advanced indexing, and context-aware selection between databases like PostgreSQL, SQLite, Neon, and Turso. Whether you are optimizing N+1 queries, planning safe migrations for serverless environments, or choosing between ORMs like Drizzle and Prisma, this skill ensures your data layer is scalable, efficient, and production-ready.

Key Features

01Comprehensive schema design with normalization and relationship mapping

02Safe migration strategies for serverless and traditional deployments

03Performance optimization via composite indexing and EXPLAIN ANALYZE

04ORM decision frameworks for Drizzle, Prisma, and Kysely

05Contextual database selection (PostgreSQL vs. Neon vs. Turso vs. SQLite)

0631,721 GitHub stars

Use Cases

01Designing a scalable data model for a multi-tenant SaaS application

02Refactoring slow-running queries and implementing missing indexes

03Migrating from a monolithic database to a serverless architecture

Key Features

01Comprehensive schema design with normalization and relationship mapping

02Safe migration strategies for serverless and traditional deployments

03Performance optimization via composite indexing and EXPLAIN ANALYZE

04ORM decision frameworks for Drizzle, Prisma, and Kysely

05Contextual database selection (PostgreSQL vs. Neon vs. Turso vs. SQLite)

0631,721 GitHub stars

Use Cases

01Designing a scalable data model for a multi-tenant SaaS application

02Refactoring slow-running queries and implementing missing indexes

03Migrating from a monolithic database to a serverless architecture