ck:databases

Name: ck:databases
Availability: InStock
Author: mafvietnam

Design and optimize MongoDB and PostgreSQL schemas and queries.

Updated Mar 30, 2026

Search Tags:#design #postgresql #migrations #queries #indexes #mongodb #databases

Ready to run

npx skills add https://github.com/mafvietnam/mafapp --skill ck-databases-mafvietnam

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps engineers and data teams design robust database schemas and write efficient queries for both MongoDB (NoSQL) and PostgreSQL (SQL), reducing design ambiguity and speeding up implementation.

Core Features & Use Cases

Schema design guidance for transactional (OLTP) and analytical (OLAP) workloads across MongoDB and PostgreSQL.
SQL and NoSQL querying patterns, including joins, aggregations, and index strategies, plus migration considerations.
Real-world examples and best practices for performance tuning, replication, and data modeling.

Quick Start

Describe your data domain and I will generate a starter schema and example queries for both MongoDB and PostgreSQL.

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 MongoDB and PostgreSQL?▼

To design database schemas for MongoDB and PostgreSQL, you define your data domain to generate starter schemas, applying modeling best practices for transactional and analytical workloads. This ensures reliable, scalable data models across both SQL and NoSQL environments.

What's the best way to optimize slow MongoDB and PostgreSQL queries?▼

The best way to optimize slow MongoDB and PostgreSQL queries is to apply targeted index selection strategies and query performance tuning. You can analyze SQL and NoSQL querying patterns, including aggregations and joins, to resolve bottlenecks.

How do I write MongoDB aggregation pipelines for analytical workloads?▼

You write MongoDB aggregation pipelines for analytical workloads by applying NoSQL querying patterns and best practices provided for performance tuning. The Skill offers guidance on constructing these pipelines alongside SQL aggregations for OLAP use cases.

Can I get migration guidance for scaling PostgreSQL and MongoDB data models?▼

Yes, you get migration guidance for scaling PostgreSQL and MongoDB data models. The Skill covers migration patterns and replication strategies, providing real-world examples to ensure reliable schema transitions and scalable data modeling.

When should I use PostgreSQL indexes versus MongoDB index strategies?▼

You choose between PostgreSQL indexes and MongoDB index strategies based on your specific OLTP or OLAP workload requirements. The Skill provides index selection guidance and querying patterns to determine the optimal approach for each database system.

Do I need to provide my data domain to generate database schemas?▼

Yes, you need to provide your data domain so the Skill can generate a starter schema and example queries for both MongoDB and PostgreSQL. This input drives the tailored schema design, SQL and NoSQL querying patterns, and index recommendations.