skills.rest
jfrometa
jfrometaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Guide schema design, indexing, ORM selection, and serverless database options.

Updated Aug 30, 2024
Search Tags:#design#indexing#database#schema#orm-selection#serverless-databases
One-click install
npx skills add https://github.com/jfrometa/esquizo --skill database-design-jfrometa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/jfrometa/esquizo/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/jfrometa/esquizo --skill database-design-jfrometa

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams choose database foundations by providing principled guidance on schema design, indexing strategies, ORM selection, and serverless database options.

Core Features & Use Cases

  • Schema design best practices including normalization, PKs, timestamps, and relationships.
  • Indexing strategy recommendations to balance read performance and write overhead.
  • ORM selection guidance based on deployment environment and DX.
  • Serverless database considerations (Neon, Turso, etc.) for branching and edge deployments.
  • Use Case: When building a multi-tenant SaaS, apply these principles to design scalable schemas and efficient queries.

Quick Start

Describe your application requirements and I will propose a database design, indexing plan, and ORM recommendations.

Frequently Asked Questions about database-design

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

FAQPage Schema
What is the best way to design a database schema for a multi-tenant SaaS application?▼

Database schema design for multi-tenant SaaS requires principled guidance on normalization, primary keys, timestamps, and relationships to ensure scalable data structures and efficient queries based on workload and deployment scale.

How do I choose an indexing strategy that balances read performance and write overhead?▼

Indexing strategy recommendations balance read performance and write overhead by applying best-practice criteria to your specific workload, ensuring production-ready data stores maintain efficient query speeds without degrading write operations.

How do I select the right ORM for my project's deployment environment and developer experience?▼

ORM selection guidance evaluates your deployment environment and developer experience requirements to provide context-aware recommendations, helping teams choose frameworks that align with their specific application scale and workflow.

When should I consider serverless databases like Neon or Turso for edge deployments?▼

Serverless databases like Neon or Turso are ideal for edge deployments and database branching workflows, offering context-aware recommendations that align with modern deployment strategies and specific workload requirements.

Can I use this database design guidance for both small apps and large multi-tenant systems?▼

Database design guidance applies to projects ranging from small apps to large multi-tenant systems, scaling structured recommendations and best-practice criteria based on your specific deployment environment, workload, and scale requirements.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
12

read-ors-configuration

A concise summary of your roleplay character: name,</name> personality, and/or behavior, formatted as a single string sentence. Typically不超过50字，此处省略

Official
Intermediate
darthlinuxerdarthlinuxer

database-design

Recommend database architectures and schema designs for application requirements.

Community
Intermediate
onmaxonmax

nuxthub

Build full-stack Nuxt apps with Drizzle ORM, KV, blob, and caching.

Community
Advanced
farmountainfarmountain
1

Database Expert

Design PostgreSQL schemas and plan safe database migrations.

Community
Advanced