database-design

Assess database schema, indexing, and ORM design decisions.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/MeoBaka/MeoPanel-Client --skill database-design-meobaka
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/MeoBaka/MeoPanel-Client/tree/main/.claude/skills/database-design
Command: npx skills add https://github.com/MeoBaka/MeoPanel-Client --skill database-design-meobaka

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Database design decisions are critical to long-term performance and maintainability, and this skill provides principled guidelines to help teams craft scalable schemas, indexing plans, and ORM selections.

Core Features & Use Cases

  • Schema design guidance including normalization, primary keys, timestamps, and relationships.
  • Indexing and performance recommendations for typical query patterns and migrations.
  • ORM and serverless database considerations for deployment scenarios such as multi-tenant apps or edge deployments.

Quick Start

Review your current Prisma and drizzle schemas and apply the recommended guidelines to improve structure and performance.

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 multi-tenant applications?

Designing a database schema for multi-tenant applications requires principled guidelines for normalization, primary keys, and relationship structuring to ensure scalable and maintainable data isolation. It covers schema design and ORM choices for multi-tenant systems.

What are the best practices for database indexing and query performance?

Database indexing best practices involve assessing query patterns to apply performance-focused indexing strategies. Proper indexing optimizes typical query patterns and ensures safe migrations without degrading long-term performance.

How do I structure primary keys and timestamps in a database schema?

Structuring primary keys and timestamps in a database schema follows enforced criteria for proper data integrity. It ensures schemas have robust primary keys, accurate timestamps, and correctly defined relationships.

How do I manage safe database migrations with an ORM?

Managing safe database migrations with an ORM involves applying safe migration practices alongside ORM selection guidance. It enforces criteria for safe migrations to prevent data loss during schema changes and deployment.

Does this database design guidance apply to serverless and edge deployments?

Yes, this database design guidance applies to serverless and edge deployments. It provides ORM and serverless database considerations specifically tailored for deployment scenarios like edge deployments and scalable multi-tenant apps.