skills.rest
gonzoblasco
gonzoblascoCOMMUNITY
Explore all skills by this author →
𝕏@gonzoblascoGitHub

database-design

Design scalable database schemas with normalization, indexing, and ORM decisions.

Updated Aug 23, 2026
Search Tags:#indexing#serverless#PostgreSQL#orm#schema-design#database-design
One-click install
npx skills add https://github.com/gonzoblasco/antigravity-developer-stack --skill database-design-gonzoblasco
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/gonzoblasco/antigravity-developer-stack/tree/main/backend-infra/database-design
Command: npx skills add https://github.com/gonzoblasco/antigravity-developer-stack --skill database-design-gonzoblasco

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps engineers design scalable and well-structured database schemas by guiding normalization decisions, indexing strategies, and ORM/serverless choices.

Core Features & Use Cases

  • Normalization Guidance: Decide when to normalize vs denormalize for data integrity and performance.
  • Indexing & Performance: Recommend index strategies and query patterns to optimize common access paths.
  • ORM & Deployment Choices: Suggest suitable ORMs and database options (including serverless) based on context and constraints.
  • Use Case: When starting a new SaaS product, analyze the data model and produce a recommended schema outline, index plan, and ORM setup.

Quick Start

Provide a sample data model snippet (tables and fields) and I will return a normalization plan, index strategy, and ORM recommendations.

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 scalable database schema for a new web application?▼

Schema design for microservices involves normalizing data for integrity while optimizing indexing for performance across distributed services. This Skill guides normalization, index strategies, and ORM choices tailored to microservice architectures and data-intensive workloads.

When should I normalize vs denormalize my PostgreSQL database?▼

Normalize your PostgreSQL schema for data integrity and denormalize when read performance requires optimized access paths. Submit your tables and fields to get a normalization plan balancing integrity with performance.

What indexing strategy should I use for data-intensive workloads?▼

Indexing strategies for data-intensive workloads target common query patterns and access paths to optimize performance. Provide your schema fields to receive a recommended index plan tailored to your specific access paths.

Can I use serverless databases with an ORM for my SaaS product?▼

Serverless databases work with ORMs for SaaS products when selected based on context and constraints. This Skill suggests suitable ORMs and serverless database options tailored to your application's deployment choices.

What are the limitations of using an ORM for schema design?▼

ORM limitations in schema design include performance trade-offs from bypassing optimized indexing and normalization. This Skill enforces precise ORM and database selection requirements to maintain scalability across relational and serverless environments.

Related Skills

Explore More Software Engineering Skills→
opsrobot-aiopsrobot-ai
135

数据模型文档生成

Generate Doris data model Markdown documentation from table metadata and sampled rows.

Official
Intermediate
gajjalaashok75-UIgajjalaashok75-UI
2

database-design

Design and evaluate database schemas, indexes, ORMs, and migration plans.

Community
Intermediate
underPressueunderPressue

senior-backend

Scaffold APIs, migrate databases, and load test via Python CLI scripts.

Community
Intermediate
devCharuzudevCharuzu

database-designer

Design database schemas with normalization checks and ERD generation.

Community
Advanced