ck:databases

Design schemas and write queries for MongoDB and PostgreSQL.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/dungnt97/wallet-portal --skill ck-databases-dungnt97
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/dungnt97/wallet-portal/tree/main/claude/skills/databases
Command: npx skills add https://github.com/dungnt97/wallet-portal --skill ck-databases-dungnt97

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pymongo, psycopg2, and includes references (resource) components.

What problem does it solve?

Design schemas and write queries for MongoDB and PostgreSQL. Use for database design, SQL/NoSQL queries, aggregation pipelines, indexes, migrations, replication, performance optimization, psql CLI.

Core Features & Use Cases

  • Comprehensive database design guidance for MongoDB (document) and PostgreSQL (relational)
  • SQL and NoSQL querying patterns, including aggregations, joins, and migrations
  • Best-practices for indexing, normalization, backups, replication, and performance tuning

Quick Start

Design a scalable schema for a new multi-tenant application and generate example DDL and queries for 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 schemas for a multi-tenant application using both PostgreSQL and MongoDB?

To design schemas for both PostgreSQL and MongoDB, you need to enforce robust schema design, normalization, and cross-database best practices with a cohesive workflow. It covers OLTP and OLAP design alongside SQL and NoSQL querying patterns.

What's the best way to handle database migrations across multi-database environments?

Database migrations across multi-database environments require a cohesive workflow that enforces robust schema design and cross-database best practices. This skill guides SQL and NoSQL migrations while maintaining normalization and data integrity.

How do I optimize indexing and performance for PostgreSQL and MongoDB queries?

Indexing and performance optimization for PostgreSQL and MongoDB queries involve applying cross-database best practices to your schema design. This skill covers indexing strategies and performance tuning for SQL and NoSQL querying patterns, including aggregations and joins.

Can I use psycopg2 and pymongo for both OLTP and OLAP database design?

You can use psycopg2 and pymongo for OLTP and OLAP database design in PostgreSQL and MongoDB. This skill utilizes these dependencies to enforce robust schema design, normalization, and cross-database best practices across multi-database environments.

When should I use MongoDB document design versus PostgreSQL relational schema design?

MongoDB document design suits flexible NoSQL querying patterns, while PostgreSQL relational schema design enforces normalization for structured data. This skill provides cohesive workflows and cross-database best practices to guide your schema design and querying approach.