ck:databases

Automate MongoDB and PostgreSQL schema design, optimization, and maintenance.

Updated Feb 27, 2026

Search Tags:#performance #analytics #indexing #postgresql #migrations #mongodb #database-design

Ready to run

npx skills add https://github.com/haidonglethqb/CloudSchool --skill ck-databases-haidonglethqb

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/haidonglethqb/CloudSchool/tree/main/.qwen/skills/databases
Command: npx skills add https://github.com/haidonglethqb/CloudSchool --skill ck-databases-haidonglethqb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Design and maintain robust database schemas and performance strategies across MongoDB and PostgreSQL, reducing time-to-value for data-driven projects.

Core Features & Use Cases

Unified guidance for OLTP and OLAP schema design, including best practices for normalization, denormalization, and data modeling.
Comprehensive indexing, query optimization, and maintenance patterns, including migrations, backups, and performance tuning.
Practical examples and workflows for multi-tenant deployments, multi-database ecosystems, and data lifecycle management.

Quick Start

Run the included tooling to scaffold migrations, backups, and performance checks for your MongoDB and PostgreSQL deployments.

Frequently Asked Questions about ck:databases

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

FAQPage Schema

How do I design database schemas for both OLTP and OLAP workloads in PostgreSQL and MongoDB?▼

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.

What's the best way to automate database migrations and backups for multi-tenant environments?▼

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.

How do I optimize PostgreSQL and MongoDB indexing for query performance tuning?▼

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.

Does this database optimization guide support multi-database ecosystems with different data modeling needs?▼

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.

Can I use Python scripts to scaffold performance checks and validate database designs?▼

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.