skills.rest
B4rz99
B4rz99COMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-schema-design

Design and optimize SQL and NoSQL database schemas.

Updated Aug 23, 2026
Search Tags:#SQL#NoSQL#migration#PostgreSQL#MySQL#MongoDB#database schema
One-click install
npx skills add https://github.com/B4rz99/fidy --skill database-schema-design-b4rz99
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-design
Source: https://github.com/B4rz99/fidy/tree/main/.agents/skills/database-schema-design
Command: npx skills add https://github.com/B4rz99/fidy --skill database-schema-design-b4rz99

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the complex task of designing and optimizing database schemas for both SQL and NoSQL databases, ensuring efficient data storage and retrieval with tailored guidance.

Core Features & Use Cases

  • Tailored Schema Design: Offers specific advice for SQL and NoSQL databases, including SQL (PostgreSQL, MySQL) and NoSQL (MongoDB).
  • Task Scenarios: Useful for creating new databases, table design, defining relationships, indexing, and migrations.
  • Use Case: For a new project, you can use this Skill to define entities, relationships, and indexing strategies, ensuring a robust database foundation.

Quick Start

Design a database schema for a social media platform by specifying the database type (MySQL), key entities (User, Post, Comment), and relationships between them.

Frequently Asked Questions about database-schema-design

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

FAQPage Schema
How do I design a database schema for a new project?▼

To design a database schema, you specify the database type, key entities, and their relationships. This Skill provides tailored guidance for defining entities, relationships, and indexing strategies for both SQL and NoSQL databases to ensure a robust foundation.

What is the best way to refactor an existing PostgreSQL schema for performance optimization?▼

Refactoring a PostgreSQL schema for performance optimization involves restructuring tables and defining indexing strategies. This Skill handles schema refactoring and offers specific advice to normalize and optimize your SQL database structure efficiently.

Does this database schema design approach work with both MySQL and MongoDB?▼

Yes, this database schema design approach works with both MySQL and MongoDB. It provides tailored schema design and optimization specifically supporting SQL databases like PostgreSQL and MySQL, as well as NoSQL databases like MongoDB.

How do I handle database migration when changing table relationships?▼

Handling database migration when changing table relationships requires structured schema refactoring. This Skill manages database migration scenarios and provides guidance on defining and implementing relationships correctly during the transition.

When do I need normalization in my SQL database schema?▼

Normalization in your SQL database schema is needed to ensure efficient data storage and reduce redundancy. This Skill supports normalization processes, offering specific advice for PostgreSQL and MySQL to optimize your relational data structure.

Related Skills

Explore More Software Engineering Skills→
bbolek-apbbolek-ap

create-data-model

Generate Mermaid ERDs and JSON Schema from project architecture documents.

Community
Advanced
jcteaguejcteague

database-schema-design

Design scalable SQL and NoSQL database schemas with normalization and indexing.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate