skills.rest
nnkienn
nnkiennCOMMUNITY
Explore all skills by this author →
𝕏@nnkiennGitHub

database-design

Guide database schema design, ORM selection, indexing, and query optimization.

1|Updated May 29, 2026
Search Tags:#database design#query optimization#indexing#schema design#ORM selection
One-click install
npx skills add https://github.com/nnkienn/Nyxara-core --skill database-design-nnkienn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/nnkienn/Nyxara-core/tree/main/.skills/skills/database-design
Command: npx skills add https://github.com/nnkienn/Nyxara-core --skill database-design-nnkienn

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the challenges of designing efficient database schemas, choosing ORMs, and optimizing queries, providing guidelines and decision-making tools for developers.

Core Features & Use Cases

  • Database Selection: Guidance on choosing the right database based on specific requirements, including relational, serverless, edge, AI/search, simple/embedded, and global distribution scenarios.
  • ORM Selection: Decision-making process for selecting the most suitable ORM based on deployment context and developer experience.
  • Schema Design: Principles for normalization, primary key selection, timestamp strategy, and relationship types.
  • Indexing: Strategies for when and how to create indexes effectively, including index type selection and composite index principles.
  • Query Optimization: Techniques for optimizing queries, including addressing the N+1 problem, query analysis, and optimization priorities.
  • Migration Principles: Safe migration strategies for database schema changes with zero downtime.

Quick Start

Analyze the database requirements for your project using the 'database-design' skill to guide your design decisions.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I choose the right ORM for my database schema design?▼

Choosing the right ORM for database schema design depends on your deployment context and developer experience, evaluating options like Prisma or Drizzle to optimize maintainability and performance.

What is the best way to optimize database queries and fix the N+1 problem?▼

The best way to optimize database queries and resolve the N+1 problem involves analyzing query execution priorities and applying targeted indexing or relationship loading strategies to improve performance.

How do I create effective composite indexes for my database?▼

To create effective composite indexes, you must evaluate index type selection and apply composite index principles based on your specific query patterns to enhance database retrieval speed.

How do I perform zero downtime database migrations safely?▼

Performing zero downtime database migrations safely requires following established safe migration strategies to ensure schema changes do not interrupt application availability or cause data loss.

When do I need a serverless or edge database over a relational one?▼

You need a serverless or edge database over a standard relational one when your project requires specific edge deployment capabilities, global distribution, or AI/search functionalities.

What are the core principles for database normalization and primary key selection?▼

Database normalization and primary key selection principles guide how you structure relational schemas, ensuring proper timestamp strategies and relationship types for data integrity.

Related Skills

Explore More Software Engineering Skills→
baekenoughbaekenough
34

supabase-postgres-best-practices

Optimize Supabase PostgreSQL performance with indexing, schema, and query tuning.

Community
Advanced
TimeKastTimeKast

database-design

Guide relational database and schema design with normalization, indexing, and migration planning.

Official
Intermediate
putto11262002putto11262002

Drizzle ORM Skill

Implement type-safe Drizzle ORM schemas, queries, and migrations in Next.js.

Community
Intermediate
samChang72samChang72
1

database-specialist

Analyze and optimize SQL database queries with EXPLAIN ANALYZE and indexing strategies.

Community
Intermediate