databases

Analyze and optimize MongoDB and PostgreSQL performance across production workloads.

Updated Dec 23, 2025
One-click install
npx skills add https://github.com/dige04/hieu-ccsetup --skill databases-dige04
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/dige04/hieu-ccsetup/tree/main/config/skills/databases
Command: npx skills add https://github.com/dige04/hieu-ccsetup --skill databases-dige04

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

MongoDB and PostgreSQL often require different design patterns and tooling; this skill helps engineers design, optimize, and maintain dual-database systems with coherent best practices.

Core Features & Use Cases

  • Unified database design guidance for MongoDB (document store) and PostgreSQL (relational) to help choose the right model for a given problem.
  • Best-practice patterns for indexing, migrations, backups, replication, auditing, and performance monitoring.
  • Real-world scenarios include migrating schemas, optimizing queries, implementing cross-database reporting, and designing hybrid architectures.

Quick Start

Run a unified health-check for MongoDB and PostgreSQL deployments to surface schema improvements, indexing opportunities, and backup strategies.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize PostgreSQL and MongoDB query performance in a mixed database environment?

Optimizing PostgreSQL and MongoDB query performance requires analyzing production workloads to surface indexing opportunities and schema improvements. This skill provides reference-driven instructions for implementing unified indexing strategies and performance monitoring across both databases.

What is the best way to design schemas for a hybrid PostgreSQL and MongoDB architecture?

Designing schemas for hybrid PostgreSQL and MongoDB architectures involves choosing the right model for each problem, applying relational patterns to PostgreSQL and document patterns to MongoDB. This skill offers unified database design guidance to ensure coherent best practices across dual-database systems.

How do I run a health check for MongoDB and PostgreSQL deployments?

Running a health check for MongoDB and PostgreSQL deployments surfaces schema improvements, indexing opportunities, and backup strategies. This skill enables a unified health-check to evaluate production workloads and identify performance optimization actions.

Can I use this skill for database migrations and backups across both PostgreSQL and MongoDB?

Yes, this skill supports database migrations and backups across PostgreSQL and MongoDB by providing best-practice patterns for migration workflows and backup strategies. It ensures coherent guidance for maintaining dual-database systems throughout the migration process.

Does this skill handle cross-database reporting and replication setup?

This skill handles cross-database reporting and replication setup by applying best-practice patterns for replication and auditing in mixed MongoDB-NoSQL and PostgreSQL environments. It delivers reference-driven instructions for implementing hybrid architectures and cross-database reporting workflows.

When should I choose MongoDB over PostgreSQL for a specific database design problem?

Choosing MongoDB over PostgreSQL depends on whether your database design problem fits a document store or relational model. This skill provides unified guidance to help engineers select the appropriate database model for a given problem in dual-database systems.