Schema Design

This skill provides comprehensive PostgreSQL database design guidance covering data types, indexing strategies, constraints, partitioning, and schema design patterns. It includes detailed recommendations for handling JSONB, time-series data, update-heavy tables, and safe schema evolution practices.

A comprehensive PostgreSQL database design guide that covers data types, indexing strategies, constraints, partitioning, JSONB usage, and performance optimization patterns. Includes AI agent definitions for database architecture and SQL expertise to help design scalable, maintainable database schemas.

This skill should be used when user asks to "query MongoDB", "show database collections", "get collection schema", "list MongoDB databases", "search records in MongoDB", or "check database indexes".