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.