ck:databases

What problem does it solve?

Managing and designing schemas, queries, migrations, and performance for MongoDB and PostgreSQL is complex and error‑prone, especially across OLTP and OLAP use cases.

Core Features & Use Cases

• Unified Guidance: Provides best‑practice rules for schema design, indexing, and security for both MongoDB and PostgreSQL.
• Operational Scripts: Includes Python utilities for backup/restore, migrations, and performance checks.
• Reference Library: Detailed markdown references covering CRUD, aggregation, indexing, ETL, and platform‑specific rules.
• Use Case Example: Quickly create a fact table for analytics or a transactional user table, generate migrations, and run performance diagnostics with a single command.

Quick Start

Use the databases skill to design a PostgreSQL users table with appropriate indexes and generate the migration script.