skills.rest
DaytimeBlues
DaytimeBluesCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Guide database selection, schema design, indexing, and ORM choices.

Updated Jan 31, 2026
Search Tags:#design#indexing#database#migrations#schema#orm
One-click install
npx skills add https://github.com/DaytimeBlues/ADHD-CADDI --skill database-design-daytimeblues
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/DaytimeBlues/ADHD-CADDI/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/DaytimeBlues/ADHD-CADDI --skill database-design-daytimeblues

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps users make informed decisions about database selection, schema design, indexing, and ORM choices, preventing common pitfalls and ensuring efficient data management.

Core Features & Use Cases

  • Database Selection: Guides users through choosing the right database (PostgreSQL, Neon, Turso, SQLite, etc.) based on project requirements.
  • Schema Design: Provides principles for normalization, primary keys, timestamps, and relationships.
  • Indexing Strategy: Offers guidance on when and how to create effective indexes.
  • ORM Selection: Helps in selecting the appropriate ORM (Drizzle, Prisma, Kysely) based on deployment and developer experience needs.
  • Migration Best Practices: Outlines safe migration strategies for zero-downtime changes.

Quick Start

Use the database-design skill to help choose between PostgreSQL and Turso for a new web application.

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 and SQLite for my application schema?▼

Choosing between PostgreSQL and SQLite depends on your project context, using a decision tree that evaluates deployment needs and specific database requirements to guide selection. It supports choosing between PostgreSQL, Neon, Turso, and SQLite.

What are the best practices for database schema design and normalization?▼

Database schema design best practices include applying principles for normalization, primary keys, timestamps, and defining relationships. Following these principles prevents common anti-patterns and ensures efficient data management.

How do I select the right ORM like Prisma or Drizzle for my project?▼

Selecting the right ORM like Prisma or Drizzle depends on your deployment and developer experience needs. This Skill helps you select between Drizzle, Prisma, and Kysely by evaluating these specific project requirements.

When should I create indexes in my database and what strategy should I use?▼

You should create indexes based on a defined indexing strategy that offers guidance on when and how to construct them effectively. Proper indexing prevents common anti-patterns and ensures efficient data retrieval.

How do I perform zero-downtime database migrations safely?▼

Performing zero-downtime database migrations safely requires following outlined migration best practices. These strategies ensure safe schema changes without disrupting application availability.

Related Skills

Explore More Software Engineering Skills→
DhumitechDhumitech

database-design

Design relational database schemas and select ORMs with migration planning.

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
hendrax5hendrax5

phase-6-ui-integration

Implement frontend UI and integrate it with backend APIs.

Community
Intermediate
rodmena-limitedrodmena-limited
3

moai-domain-database

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

Official
Advanced