skills.rest
OmarMira
OmarMiraCOMMUNITY
Explore all skills by this author →
GitHub

database-design

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

Updated Dec 24, 2025
Search Tags:#schema design#database#migrations#optimization#sql#orm
One-click install
npx skills add https://github.com/OmarMira/Coontabilidad --skill database-design-omarmira
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/OmarMira/Coontabilidad/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/OmarMira/Coontabilidad --skill database-design-omarmira

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides guidance and best practices for designing and optimizing database schemas, selecting appropriate database technologies and ORMs, and implementing safe migration strategies.

Core Features & Use Cases

  • Database Selection: Helps choose between PostgreSQL, Neon, Turso, SQLite, and others based on project requirements.
  • ORM Selection: Guides the choice of ORMs like Drizzle, Prisma, or Kysely.
  • Schema Design: Offers principles for normalization, primary keys, and relationships.
  • Optimization: Covers indexing strategies and query optimization techniques like identifying N+1 problems.
  • Migrations: Outlines safe, zero-downtime migration approaches.
  • Use Case: When starting a new project, use this Skill to decide whether to use SQLite for local development and Neon for production, and to select Drizzle ORM for its performance and type safety.

Quick Start

Use the database-design skill to help select an ORM for a new project.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I choose between PostgreSQL, SQLite, and Turso for my database schema?▼

Choosing between PostgreSQL, SQLite, and Turso depends on your deployment environment. This Skill guides database selection based on project requirements, helping you match technologies like Neon or SQLite to edge and serverless contexts.

What is the best way to design a normalized database schema with primary keys?▼

Designing a normalized database schema requires structuring primary keys and relationships correctly. This Skill provides core principles for schema design, normalization, and indexing strategies to ensure data integrity and query efficiency.

How do I run safe, zero-downtime database migrations in a serverless environment?▼

Running safe, zero-downtime database migrations in serverless environments requires specific practices. This Skill outlines safe migration approaches tailored for various deployment targets, preventing downtime during schema updates.

Should I use Drizzle, Prisma, or Kysely for my ORM selection?▼

Selecting Drizzle, Prisma, or Kysely depends on your performance and type safety needs. This Skill guides ORM selection by comparing these options to help you choose the best fit for your project's query optimization.

How do I identify and fix N+1 query problems during database optimization?▼

Identifying N+1 query problems is a core part of database optimization. This Skill covers query optimization techniques and indexing strategies to help you detect and resolve N+1 issues for better performance.

Can I validate a Prisma schema before running database migrations?▼

Validating a Prisma schema before running database migrations is supported by this Skill. It includes a schema validator script to check your Prisma schemas, ensuring structural correctness prior to deployment.

Related Skills

Explore More Software Engineering Skills→
myoshi2891myoshi2891
1

ec-db-migrator

Manage PostgreSQL schema definitions, migrations, and data seeding with Prisma ORM.

Community
Intermediate
paulojalowyjpaulojalowyj
6

database-design

Guide database design, technology selection, and schema optimization.

Community
Advanced
danilomartinellidanilomartinelli
1

database-design

Guide database design decisions across PostgreSQL, Neon, Turso, and SQLite.

Community
Advanced
Fancu1Fancu1

database-design

Design and optimize relational and NoSQL database schemas with migration patterns.

Community
Intermediate