skills.rest
MinhQuyen274
MinhQuyen274COMMUNITY
Explore all skills by this author →
GitHub

ck:databases

Design database schemas and query strategies for MongoDB and PostgreSQL.

Updated Aug 23, 2026
Search Tags:#query optimization#postgresql#migrations#backup and restore#database schema design#mongo db#etl incremental loading
One-click install
npx skills add https://github.com/MinhQuyen274/smartify --skill ck-databases-minhquyen274
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/MinhQuyen274/smartify/tree/main/Frontend_PROJECT_Figma/.opencode/skills/databases
Command: npx skills add https://github.com/MinhQuyen274/smartify --skill ck-databases-minhquyen274

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Databases skill helps you design reliable data schemas and write correct, performant MongoDB and PostgreSQL queries while managing indexes, migrations, backups, and production operations.

Core Features & Use Cases

  • Database schema design (OLTP + OLAP): Create and extend transactional models, and design analytics schemas (star schema, fact/dimension tables).
  • Query building and performance optimization: Author SQL and MongoDB queries, aggregation pipelines, indexes, and tune slow queries using EXPLAIN and profiling concepts.
  • Operational tooling: Plan and manage migrations, backups/restores, incremental ETL logs, and replication/administration guidance for production.

Quick Start

Use the ck:databases skill to design database tables for an analytics dashboard that needs daily sales metrics by store and channel.

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 OLTP and OLAP workloads?▼

To optimize slow PostgreSQL and MongoDB queries, you analyze execution plans using EXPLAIN and profiling concepts, then build targeted indexes and rewrite aggregation pipelines. This reduces query latency by addressing full collection scans and inefficient join operations.

How do I manage database migrations and backups for production databases?▼

Managing database migrations and backups requires loading operational scripts to execute deterministic tasks like schema changes and data restores. This ensures production database reliability during version updates and disaster recovery scenarios.

How does incremental loading work for ETL pipelines?▼

Incremental loading for ETL pipelines extracts only newly modified data since the last run using operational logs and timestamps. This minimizes database query overhead and reduces pipeline execution time for analytics workflows.

What is the best way to model MongoDB aggregation pipelines for analytics?▼

Modeling MongoDB aggregation pipelines for analytics requires chaining stages like match, group, and project to transform raw documents into metrics. This approach leverages MongoDB indexes to compute daily sales metrics efficiently.

Related Skills

Explore More Software Engineering Skills→
hung-phanhung-phan

oltp-vs-olap

Analyze workload characteristics to select between OLTP and OLAP databases.

Community
Advanced
saolalabsaolalab
37

Data Pipeline Engineering

Design ETL pipelines for batch and incremental data ingestion.

Official
Intermediate
tchawla827tchawla827
1

postgres-pro

Analyze PostgreSQL queries with EXPLAIN ANALYZE and recommend indexes.

Community
Advanced
devsepninedevsepnine
1

clickhouse-io

Analyze and optimize ClickHouse analytics workflows for OLAP solutions.

Community
Advanced