skills.rest
besync-labs
besync-labsCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design normalized database schemas with 3NF/BCNF for Prisma and SQL workflows.

7|1|Updated Feb 5, 2026
Search Tags:#design#database#schema#sql#indexes#normalization#prisma
One-click install
npx skills add https://github.com/besync-labs/antigravity-ai-kit --skill database-design-besync-labs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/besync-labs/antigravity-ai-kit/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/besync-labs/antigravity-ai-kit --skill database-design-besync-labs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Normalize and optimize database schemas to reduce redundancy, improve data integrity, and support scalable applications.

Core Features & Use Cases

  • Normalization guidance (3NF, 2NF) with practical table designs
  • Naming conventions and consistency across models
  • Indexing and query optimization patterns for common access paths
  • Use Case: Design a user, orders, and products schema for an e-commerce app with clear relations

Quick Start

Draft a normalized schema for a simple e-commerce app including users, products, orders, and order_items.

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 normalized database schema for an e-commerce app?▼

Design a normalized database schema by modeling users, products, orders, and order_items with clear relations to reduce redundancy and improve data integrity. Apply 3NF and BCNF normalization to ensure consistency across web application models.

What is database normalization and when do I need 3NF for my SQL schema?▼

Database normalization is the process of organizing relational data to reduce redundancy and improve integrity. You need 3NF or BCNF for SQL schemas when eliminating update anomalies and ensuring consistent access paths across web and analytics workloads.

Can I use this database schema design approach with Prisma workflows?▼

Yes, this database schema design approach supports Prisma and SQL-based workflows by providing practical relationship modeling and conventional naming schemes. It generates normalized table designs suitable for direct Prisma model integration.

What's the best way to structure indexes and query optimization for a relational schema?▼

Structure indexes by analyzing common access paths in your relational schema and applying indexing patterns that support query optimization. This approach ensures scalable performance for web applications and analytics workloads.

How do I apply naming conventions consistently across my database models?▼

Apply naming conventions across database models by following conventional naming schemes during the schema design process. This ensures consistency across relational tables and supports clear relationship modeling for SQL and Prisma workflows.

Why does my database schema have redundant data and how do I fix it?▼

Your database schema has redundant data because it lacks normalization. Fix it by applying 2NF and 3NF normalization principles to split tables and define clear relations, reducing redundancy and improving overall data integrity.

Related Skills

Explore More Software Engineering Skills→
Prorise-coolProrise-cool
24

data-modeling

Create conceptual, logical, and physical data models with ERDs and data dictionaries.

Community
Intermediate
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
Harmeet10000Harmeet10000
7

sql-optimization-patterns

Analyzes SQL slow queries and recommends indexing and rewrite strategies.

Community
Advanced
ArieGoldkinArieGoldkin
10

database-schema-designer

Design normalized SQL and NoSQL database schemas with indexing and migration planning.

Community
Basic