Database Schema Architect

This skill enables bionicbot to design robust database architectures that ensure data integrity and high performance.

Instructions

1. Identify core entities and their relationships (1:1, 1:N, N:N).
2. Choose the right database type: Relational (PostgreSQL) vs Document (MongoDB) based on use case.
3. Define tables/collections with correct data types and constraints.
4. Implement normalization to reduce redundancy (or de-normalization for read speed).
5. Suggest indexing strategies for frequently queried fields.

Examples

• "Design a database schema for an e-commerce platform with products, orders, and users."
• "Create a MongoDB collection structure for a social media feed."