skills.rest
Genuineh
GenuinehCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/Genuineh/fus --skill backend-database
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
SSiertsemaSSiertsema

database-technology-selection

Evaluate database classes against consistency, scale, and query patterns.

Community
Advanced
samChang72samChang72
1

database-specialist

Analyze and optimize SQL database queries with EXPLAIN ANALYZE and indexing strategies.

Community
Intermediate
desafindesafin

moai-domain-backend

Design and implement APIs, databases, and microservices architectures.

Community
Advanced
VuNguyenVietTienVuNguyenVietTien

databases

Design database schemas, optimize queries, and plan migrations for MongoDB and PostgreSQL.

Community
Intermediate