skills.rest
yunaamelia
yunaameliaCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Guide database design with schema, indexing, ORM, and migration strategies.

Updated Jan 20, 2026
Search Tags:#design#performance#database#schema#migration#sql#orm
One-click install
npx skills add https://github.com/yunaamelia/mcp-agent-memory-pro --skill database-design-yunaamelia
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/yunaamelia/mcp-agent-memory-pro/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/yunaamelia/mcp-agent-memory-pro --skill database-design-yunaamelia

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill guides users through the complex process of database design, ensuring optimal performance, scalability, and maintainability by covering principles of schema design, indexing, ORM selection, and migration strategies.

Core Features & Use Cases

  • Database Selection: Provides decision trees and comparisons for choosing between PostgreSQL, Neon, Turso, SQLite, and others based on project requirements.
  • ORM Selection: Helps in selecting the right Object-Relational Mapper (ORM) like Drizzle, Prisma, or Kysely based on deployment needs and developer experience.
  • Schema Design: Offers principles for normalization, primary key selection, timestamp strategies, and relationship types.
  • Indexing & Optimization: Details on when and how to create indexes, and strategies for query optimization like avoiding N+1 problems.
  • Migration Strategies: Outlines safe methods for database schema changes to ensure zero downtime.

Quick Start

Use the database-design skill to help choose between PostgreSQL and SQLite 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 and SQLite for a new project?▼

Database selection depends on your project context, using decision trees to compare PostgreSQL, SQLite, Turso, and Neon based on deployment needs and relational complexity to ensure optimal performance.

What is the best way to design a database schema for scalability?▼

Database schema design uses principles like normalization, primary key selection, and timestamp strategies to build robust relationships, ensuring your database maintains scalability and maintainability.

How do I create indexes for database query optimization?▼

Database indexing details when and how to create indexes, alongside strategies for query optimization like avoiding N+1 problems, to enforce performance best practices.

What are safe migration strategies for zero downtime schema changes?▼

Database migration strategies outline safe methods for executing schema changes, enforcing best practices to ensure zero downtime and maintain data integrity during complex updates.

Does Prisma work well for edge deployments?▼

Prisma is evaluated for ORM selection against Drizzle and Kysely based on deployment needs, providing informed decision making for edge deployments and complex relational requirements through structured checklists.

Related Skills

Explore More Software Engineering Skills→
DhumitechDhumitech

database-design

Design relational database schemas and select ORMs with migration planning.

Community
Intermediate
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced
cbemistercbemister

performance-check

Analyze code paths for N+1 queries, missing indexes, and transaction boundaries.

Community
Advanced
devCharuzudevCharuzu

database-designer

Design database schemas with normalization checks and ERD generation.

Community
Advanced