backend-database

Guide database selection and schema design for SQL and NoSQL use cases.

Updated Mar 2, 2026

Search Tags:#performance #schema design #database #data modeling #sql #nosql

Ready to run

npx skills add https://github.com/Genuineh/fus --skill backend-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: backend-database
Source: https://github.com/Genuineh/fus/tree/main/skills/backend-database
Command: npx skills add https://github.com/Genuineh/fus --skill backend-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps developers choose the right database for their application and design efficient schemas, preventing costly mistakes and performance issues down the line.

Core Features & Use Cases

Database Selection Guide: Provides a decision matrix and criteria for selecting between SQL and NoSQL databases based on use case (OLTP, OLAP, document, key-value, etc.).
Schema Design Principles: Explains normalization and denormalization concepts with practical examples.
SQL & NoSQL Patterns: Offers best practices for indexing, query optimization, and common data modeling patterns in SQL and NoSQL databases.
Use Case: A startup is building a new social media platform. They need to decide whether to use a relational database for user profiles and relationships or a document store for posts. This skill guides them through the trade-offs.

Quick Start

Use the backend-database skill to get a recommendation for a database suitable for a high-traffic e-commerce website.

Frequently Asked Questions about backend-database

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

FAQPage Schema

How do I choose between SQL and NoSQL databases for my application architecture?▼

Schema design balances normalization for data integrity and denormalization for read performance. Apply schema design principles to structure relational and document data models efficiently, optimizing query patterns and indexing for your specific use case.

What are the best practices for SQL and NoSQL data modeling patterns?▼

Database schema design for high-traffic e-commerce requires careful evaluation of transactional and analytical workloads. Guide your architecture decisions by comparing relational databases for transactions with document stores for flexible product catalogs.

When should I use denormalization in my database schema design?▼

Indexing strategy impacts database performance by determining how quickly queries locate data. Apply indexing best practices in SQL and NoSQL databases to optimize query patterns and prevent costly performance bottlenecks in your application.

Does my social media platform need a relational database or a document store?▼

Database selection for time-series data requires evaluating specialized NoSQL patterns. Choose databases that handle high-volume, time-ordered events efficiently, applying appropriate indexing and schema design to manage analytical and transactional workloads.