skills.rest
lehuuhau1231
lehuuhau1231COMMUNITY
Explore all skills by this author →
GitHub

database-design

Guide database design decisions covering schema, indexing, and ORM selection.

Updated Aug 5, 2025
Search Tags:#database design#schema design#database optimization#ORM selection#database decision-making
One-click install
npx skills add https://github.com/lehuuhau1231/TechJobs --skill database-design-lehuuhau1231
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/lehuuhau1231/TechJobs/tree/main/tech-job-client/.agent/skills/database-design
Command: npx skills add https://github.com/lehuuhau1231/TechJobs --skill database-design-lehuuhau1231

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a structured approach to database design and decision-making, solving the challenge of selecting the right database, schema, and ORM for various application needs.

Core Features & Use Cases

  • Database Selection: Offers guidance on choosing the right database for different use cases (e.g., PostgreSQL, Neon, Turso, SQLite).
  • Schema Design: Assists with normalization, indexing strategies, and ORM selection.
  • ORM Selection: Provides a decision tree for selecting the appropriate ORM based on deployment and DX needs.
  • Use Case: For a new e-commerce platform, this Skill can help you decide whether to use PostgreSQL or MySQL, design a normalized database schema, and select the best ORM for your application.

Quick Start

Learn how to design a database schema that is optimized for your needs by following the guidelines in this skill unit.

Frequently Asked Questions about database-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 e-commerce platform?▼

Database schema design for e-commerce involves normalizing your data structures and applying indexing strategies to optimize query performance, ensuring efficient data retrieval and maintainability.

What's the best way to choose between PostgreSQL and serverless databases like Neon or Turso?▼

Choosing between PostgreSQL and serverless databases like Neon or Turso depends on your specific deployment needs. Evaluating database selection criteria based on your application scale ensures optimal performance and cost management.

How do I select the right ORM for my database schema?▼

ORM selection depends on your deployment requirements and developer experience needs. Using a decision tree to evaluate ORMs like Prisma, Drizzle, and Kysely ensures you choose the best fit for your application architecture.

Does this database design approach work with SQLite?▼

Yes, this database design approach provides guidance for SQLite alongside PostgreSQL and serverless options. It helps you apply schema design and indexing strategies to ensure your database performs reliably across different platforms.

When should I use serverless databases over traditional PostgreSQL?▼

Serverless databases like Neon and Turso are ideal for applications needing dynamic scaling without infrastructure management. Traditional PostgreSQL is better suited for consistent workloads requiring granular control over database optimization and indexing strategies.

Related Skills

Explore More Software Engineering Skills→
cornmanwtfcornmanwtf

database-schema-generator

Generate ORM models, SQL migrations, and seed scripts for databases.

Community
Intermediate
rodmena-limitedrodmena-limited
3

moai-domain-database

Provide database schema design, query optimization, and indexing strategies.

Official
Advanced
Andrej1601Andrej1601

backend

Automate Supabase backend API design, database schemas, and Next.js server-side logic.

Community
Advanced
koralliskorallis
90

database-design

Design normalized relational and NoSQL database schemas with indexes and migrations.

Community
Advanced