skills.rest
LuisSambrano
LuisSambranoCOMMUNITY
Explore all skills by this author →
𝕏@luissambrano_uxGitHub

db-design

Guide database schema design, ORM selection, and safe migrations.

7|2|Updated Jan 28, 2026
Search Tags:#performance#schema design#database#postgresql#migrations#orm
One-click install
npx skills add https://github.com/LuisSambrano/antigravity-config --skill db-design-luissambrano
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-design
Source: https://github.com/LuisSambrano/antigravity-config/tree/main/skills/3-web/db-design
Command: npx skills add https://github.com/LuisSambrano/antigravity-config --skill db-design-luissambrano

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill provides guidance and best practices for designing efficient and maintainable database schemas, helping you avoid common pitfalls and make informed decisions about database and ORM selection.

Core Features & Use Cases

  • Database & ORM Selection: Offers decision trees and comparisons for choosing the right database (PostgreSQL, Neon, Turso, SQLite) and ORM (Drizzle, Prisma, Kysely).
  • Schema Design: Covers normalization, primary key strategies, timestamp conventions, and relationship types.
  • Performance Optimization: Provides insights into indexing strategies and query optimization techniques like identifying and solving N+1 problems.
  • Migrations: Outlines safe migration practices for zero-downtime changes.
  • Use Case: When starting a new project, use this Skill to decide between PostgreSQL and Turso, select Prisma as your ORM, and design your initial user and product tables following normalization best practices.

Quick Start

Use the db-design skill to help me choose a database for a new web application that needs to scale globally.

Frequently Asked Questions about db-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a database schema for a new web application?▼

Database schema design requires applying normalization principles, selecting primary key strategies, standardizing timestamp conventions, and defining relationship types to ensure data integrity and maintainability.

What is the best way to choose between PostgreSQL, Neon, Turso, and SQLite?▼

Choosing between PostgreSQL, Neon, Turso, and SQLite involves evaluating decision trees based on your deployment environment, such as whether you need serverless, edge, or globally scalable database infrastructure.

How do I run safe database migrations with zero downtime?▼

Safe database migrations with zero downtime require specific practices to apply schema changes without interrupting active connections, ensuring reliable deployments across various environments including serverless and edge.

How do I fix N+1 query problems and optimize database indexing?▼

Fixing N+1 query problems and optimizing database indexing involves applying targeted query optimization techniques and strategic indexing strategies to significantly reduce redundant database calls and improve performance.

Drizzle vs Prisma vs Kysely: which ORM should I choose?▼

Comparing Drizzle, Prisma, and Kysely ORMs requires evaluating their specific feature sets, developer experience, and how well they integrate with your chosen database like PostgreSQL or SQLite for schema management.

Related Skills

Explore More Software Engineering Skills→
TbK0ngTbK0ng

trellis-bootstrap

Initialize Trellis AI workflow scaffolding with .trellis structure, memory, and CLI hooks.

Community
Intermediate
inbharataiinbharatai
22

db-schema-designer

Design normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.

Community
Intermediate
tranhieutttranhieutt
70

drizzle-orm-expert

Design and validate type-safe Drizzle ORM schemas, queries, and migrations for TypeScript projects.

Community
Advanced
Geralt1983Geralt1983
1

Database Designer

Design relational and NoSQL database schemas with normalization and indexing guidance.

Community
Advanced