skills.rest
tonamson
tonamsonCOMMUNITY
Explore all skills by this author →
GitHub

ck:databases

Design and optimize MongoDB and PostgreSQL database schemas for OLTP and OLAP workloads.

Updated Aug 27, 2026
Search Tags:#postgresql#migrations#indexes#mongodb#databases#schema-design#sql-nosql
One-click install
npx skills add https://github.com/tonamson/please-done --skill ck-databases-tonamson
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/tonamson/please-done/tree/main/ck/.opencode/skills/databases
Command: npx skills add https://github.com/tonamson/please-done --skill ck-databases-tonamson

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Design and optimize database schemas and queries across MongoDB and PostgreSQL, enabling robust data models and efficient queries across transactional and analytical workloads.

Core Features & Use Cases

  • Unified guidance for transactional (OLTP) and analytical (OLAP) workloads, including schema design, indexing, migrations, and performance considerations.
  • Step-by-step execution processes and reference materials for both MongoDB and PostgreSQL, plus cross-database best practices.
  • Practical examples and templates that accelerate design reviews, design proposals, and implementation plans.

Quick Start

Ask me to design or review a MongoDB or PostgreSQL schema and I will provide a ready-to-implement guide.

Frequently Asked Questions about ck:databases

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

FAQPage Schema
How do I design a database schema for both PostgreSQL and MongoDB?▼

Designing a database schema for PostgreSQL and MongoDB involves modeling relational data for OLTP workloads and document-based structures for analytical queries. This Skill provides unified guidance, execution processes, and templates to draft robust cross-database models.

What's the best way to handle database migrations and indexing across SQL and NoSQL?▼

Handling database migrations and indexing across SQL and NoSQL requires applying cross-database best practices for schema evolution. This Skill offers tooling scaffolds and reference materials to run migrations and validate indexing strategies for both PostgreSQL and MongoDB.

When do I need different schema designs for OLTP vs OLAP workloads?▼

You need different schema designs for OLTP vs OLAP workloads when optimizing for transactional consistency versus analytical aggregation. This Skill covers specific design patterns to tune performance and structure efficient queries for both workload types.

Can I use pymongo and psycopg2 to validate my database schema designs?▼

Yes, you can use pymongo and psycopg2 to validate database schema designs by running connection scripts and testing queries. This Skill provides executable scripts and scaffolds to interact with MongoDB and PostgreSQL directly.

Why does my MongoDB query perform poorly compared to PostgreSQL?▼

Poor MongoDB query performance compared to PostgreSQL often stems from incorrect document schema design or missing indexes. This Skill helps you review indexing strategies and apply schema optimization patterns to improve cross-database query efficiency.

Related Skills

Explore More Data & Analytics Skills→
VuNguyenVietTienVuNguyenVietTien

databases

Design database schemas, optimize queries, and plan migrations for MongoDB and PostgreSQL.

Community
Intermediate
skinred78skinred78
1

databases

Design schemas, write queries, and administer MongoDB and PostgreSQL databases.

Community
Advanced
Thanh-aperoThanh-apero
1

databases

Guide MongoDB and PostgreSQL schema design, query optimization, and performance tuning.

Community
Advanced
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate