databases

Guide MongoDB and PostgreSQL schema design, querying, and administration.

3|1|Updated Dec 21, 2025
One-click install
npx skills add https://github.com/vibery-studio/templates --skill databases-vibery-studio
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/vibery-studio/templates/tree/main/skills/databases
Command: npx skills add https://github.com/vibery-studio/templates --skill databases-vibery-studio

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Unified guidance for using both MongoDB (document-oriented) and PostgreSQL (relational) to help teams design schemas, write efficient queries, optimize performance, and manage migrations, backups, and administration across both systems.

Core Features & Use Cases

  • Cross-database guidance for selecting the right data model and query approach depending on workload.
  • Operational playbooks for migrations, replication, backups, and security across MongoDB and PostgreSQL.
  • Reference-rich learning with practical examples, best practices, and maintenance tasks that span both databases.

Quick Start

Start by reviewing the MongoDB and PostgreSQL sections to begin applying unified data-modeling, querying, and performance optimization in real-world projects.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I choose between MongoDB and PostgreSQL for my database schema design?

MongoDB and PostgreSQL schema design selection depends on workload; this guide provides unified criteria for choosing document-oriented or relational data models to optimize data modeling and querying across both systems.

How do I tune indexes and run explain plans for PostgreSQL and MongoDB queries?

Tune indexes and run explain plans by applying the included performance optimization playbooks, which provide practical command examples for profiling queries and analyzing execution plans across both PostgreSQL and MongoDB.

What is the best way to handle database migrations and backups in production?

Handle migrations and backups using the operational playbooks included here, which cover maintenance, replication, and security tasks for managing MongoDB and PostgreSQL in production scenarios.

Does this guide support cross-database workflows for both PostgreSQL and MongoDB?

Yes, it satisfies cross-database workflow requirements by providing unified reference material and practical command examples for operating both PostgreSQL and MongoDB simultaneously.

Can I use pymongo and psycopg2 for database administration and security?

Use pymongo and psycopg2 as dependencies to execute the administration, security, and maintenance scripts provided, enabling programmatic database management and performance monitoring across both platforms.

When should I not use a document-oriented database for my workload?

Avoid document-oriented databases like MongoDB when workloads require complex relational joins and strict schema constraints, making a relational system like PostgreSQL better for that data modeling.