skills.rest
danielctc
danielctcCOMMUNITY
Explore all skills by this author →
GitHub

databases

Manage MongoDB and PostgreSQL migrations, backups, and performance analysis.

Updated Jan 13, 2026
Search Tags:#performance#postgresql#migrations#data#mongodb#backups
One-click install
npx skills add https://github.com/danielctc/ReactSpacesMonoRepo --skill databases-danielctc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/danielctc/ReactSpacesMonoRepo/tree/main/.claude/skills/databases
Command: npx skills add https://github.com/danielctc/ReactSpacesMonoRepo --skill databases-danielctc

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

MongoDB and PostgreSQL are both powerful but managing them together, including migrations, backups, and performance tuning, can be error-prone and time-consuming. This skill provides a unified approach to handling both databases with practical, ready-to-run guidance.

Core Features & Use Cases

  • Unified migration, backup, and performance tooling for MongoDB and PostgreSQL.
  • Use cases include schema migrations, data backups, and performance analysis across both databases.
  • Use Case: A data engineer needs to run a MongoDB index migration and a PostgreSQL schema change in a coordinated workflow.

Quick Start

Run a sample migration using the provided scripts and review the results, then generate a performance report across both databases.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I coordinate MongoDB and PostgreSQL schema migrations in a single workflow?▼

Coordinated MongoDB and PostgreSQL schema migrations are executed using provided Python scripts and SQL/NoSQL commands, enabling you to run concurrent index and schema changes across both databases within a unified workflow.

Can I run unified backups for MongoDB and PostgreSQL databases?▼

Yes, unified backups for MongoDB and PostgreSQL databases are supported. The skill provides ready-to-run scripts to automate backup workflows across both relational and NoSQL systems.

How do I perform performance analysis across both PostgreSQL and MongoDB?▼

Performance analysis across PostgreSQL and MongoDB is performed by running provided Python scripts that generate performance reports, evaluating query efficiency and system health across both database environments.

Do I need pymongo and psycopg2 installed to manage database migrations and backups?▼

Yes, pymongo and psycopg2 are required dependencies. These Python libraries are necessary to execute the programmatic migrations, backup workflows, and performance checks for MongoDB and PostgreSQL.

What's the best way to manage data engineering tasks that require both SQL and NoSQL commands?▼

Managing data engineering tasks requiring both SQL and NoSQL commands is best handled through a unified approach. This skill provides practical guidance for programmatic migrations, backups, and performance tuning across MongoDB and PostgreSQL.

Related Skills

Explore More Data & Analytics Skills→
hongbietcodehongbietcode
3

databases

Design, query, migrate, backup, and administer MongoDB and PostgreSQL databases.

Community
Advanced
temple-slopetemple-slope

recipe-backup-sheet-as-csv

Convert Google Sheets spreadsheets to CSV for backup or downstream processing.

Community
Intermediate
dthuy62dthuy62

ck:databases

Design and optimize MongoDB and PostgreSQL schemas, queries, and indexes.

Community
Advanced
nist0nist0

pgadmin

Inspect PostgreSQL schemas, analyze query plans, and validate migrations.

Community
Advanced