skills.rest
flybirdxx
flybirdxxCOMMUNITY
Explore all skills by this author →
GitHub

database-design

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

Updated Feb 5, 2026
Search Tags:#database design#indexing#schema design#ORM#serverless databases
One-click install
npx skills add https://github.com/flybirdxx/RunningHub --skill database-design-flybirdxx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/flybirdxx/RunningHub/tree/main/.gemini/skills/database-design
Command: npx skills add https://github.com/flybirdxx/RunningHub --skill database-design-flybirdxx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides comprehensive guidance on database design principles, helping users make informed decisions on schema design, indexing, ORM selection, and serverless databases.

Core Features & Use Cases

  • Schema Design: Learn normalization, primary keys, and relationships.
  • Indexing Strategy: Understand when and how to create indexes for performance tuning.
  • ORM Selection: Compare and choose between different ORMs like Prisma, Drizzle, and Kysely.
  • Serverless Databases: Explore options like Neon, Turso, and PlanetScale.
  • Use Case: Imagine you are designing a new database for a web application. Use this Skill to understand the best practices for schema design, indexing, and choosing the right ORM and serverless database.

Quick Start

Use the database-design skill to learn about database design principles and decision-making.

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 with proper normalization and relationships?▼

Database schema design requires understanding normalization, primary keys, and entity relationships. This Skill provides comprehensive guidance on schema design principles to help you structure relational data correctly and avoid common architecture pitfalls.

When should I create indexes for database performance tuning?▼

Indexing strategy is crucial for database performance tuning. This Skill explains when and how to create indexes, helping you optimize query execution paths and improve overall application responsiveness without unnecessary overhead.

How do I choose between Prisma, Drizzle, and Kysely for ORM selection?▼

ORM selection involves comparing Prisma, Drizzle, and Kysely based on your application needs. This Skill provides decision-making guidance to evaluate these ORMs and integrate them effectively into your software engineering workflow.

What are the best serverless databases like Neon, Turso, and PlanetScale for web applications?▼

Serverless databases like Neon, Turso, and PlanetScale offer scalable options for modern web applications. This Skill helps you explore these platforms and make informed decisions for your specific database architecture requirements.

Do I need to know SQL to use this database design guidance?▼

Yes, applying this database design guidance requires existing knowledge of SQL and database management. The Skill focuses on advanced architecture, performance optimization, and ORM integration decisions rather than teaching basic SQL syntax.

What is the best way to approach database architecture for a new web application?▼

Database architecture for new web applications involves integrating schema design, indexing strategies, ORM selection, and serverless database choices. This Skill helps you master these principles and make informed decisions across the entire stack.

Related Skills

Explore More Software Engineering Skills→
Axel-DaMageAxel-DaMage
2

sql-pro

Optimize SQL queries and design database schemas with indexing strategies.

Community
Advanced
GeargrindadminGeargrindadmin

database-design

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

Community
Intermediate
tikazyqtikazyq
5

web-app-thinking

Generate web application architecture blueprints covering frontend, backend, infrastructure, and security.

Community
Intermediate
Archive228Archive228
746

migration-writer

Generate reversible up and down database migrations for schema changes.

Community
Intermediate