skills.rest
rahlplx
rahlplxCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Guide schema design, indexing strategies, and ORM selection for databases.

Updated Feb 6, 2026
Search Tags:#design#indexing#database#schema#ORM#normalization
One-click install
npx skills add https://github.com/rahlplx/elite-astro-workforce-template --skill database-design-rahlplx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/rahlplx/elite-astro-workforce-template/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/rahlplx/elite-astro-workforce-template --skill database-design-rahlplx

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps teams design robust, scalable databases by guiding schema design, indexing strategies, ORM choices, and serverless database options.

Core Features & Use Cases

  • Guidance on normalization vs denormalization and when to apply each.
  • ORM selection and schema-first design guidance (Drizzle, Prisma, Kysely) with practical trade-offs.
  • Indexing and migration best practices to support scalable queries.

Quick Start

Review the database-design skill folder to apply decision trees and checklists to a new project: start by identifying data access patterns, then choose a relational database, an indexing strategy, and an ORM based on your deployment and DX needs.

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 scalable cloud-native microservice?▼

Database schema design for scalable systems starts by identifying data access patterns, then selecting a relational database structure, indexing strategy, and ORM based on deployment needs. This skill provides decision trees and checklists to guide this structured process.

When should I use normalization vs denormalization in my database architecture?▼

Normalization vs denormalization in database architecture depends on your specific data access patterns and scale. This skill provides structured guidance with checklists to determine when to apply each approach for maintainable data layers.

How do I choose the best ORM for schema-first design with Drizzle, Prisma, or Kysely?▼

Choosing the best ORM for schema-first design involves evaluating practical trade-offs between Drizzle, Prisma, and Kysely based on your developer experience needs. This skill provides comparative guidance to support scalable query migrations.

What indexing strategy should I use to support scalable database queries?▼

An indexing strategy for scalable database queries must align with your identified data access patterns. This skill provides indexing best practices and example configurations to ensure maintainable data layers across monoliths and microservices.

Does this database design guidance work for serverless database choices?▼

Yes, this database design guidance explicitly applies to serverless database choices across cloud-native microservices. It provides structured patterns and example configurations to ensure scalable data layers in serverless environments.

Related Skills

Explore More Software Engineering Skills→
lexicalninjalexicalninja
2

database-implementer

Design database schemas, migrations, and data access layers for applications.

Community
Advanced
zircotezircote
26

backend-development

Provides backend development guidance across REST, GraphQL, gRPC APIs and DevOps pipelines for Node.js, Python, Go, Rust.

Community
Advanced
danilomartinellidanilomartinelli
1

database-design

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

Community
Advanced
darthlinuxerdarthlinuxer

database-design

Recommend database architectures and schema designs for application requirements.

Community
Intermediate