ck:databases

Database design for OLTP and OLAP workloads involves applying normalization, denormalization, and data modeling best practices. This Skill provides unified guidance and practical workflows to structure schemas across PostgreSQL and MongoDB for mixed operational and analytical requirements.

Automating database migrations and backups for multi-tenant environments requires a Python tooling suite to scaffold and validate maintenance tasks. This Skill automates these processes, applying canonical patterns to ensure robust data lifecycle management across deployments.

PostgreSQL and MongoDB indexing optimization requires comprehensive patterns for query tuning and performance checks. This Skill automates indexing strategies and validation, applying canonical documentation to improve query performance in complex database ecosystems.

Yes, this database optimization guide supports multi-database ecosystems by providing unified guidance for both PostgreSQL and MongoDB. It addresses diverse data modeling needs, including schema design, indexing, and performance tuning across different database architectures.

Yes, you can use the included Python scripts to scaffold migrations, backups, and performance checks. The tooling suite validates database designs and implementation against canonical documentation for both PostgreSQL and MongoDB environments.