skills.rest
hongbietcode
hongbietcodeCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

databases

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

3|Updated Dec 28, 2025
Search Tags:#indexing#postgresql#migrations#query-optimization#mongodb#backups#database-design
One-click install
npx skills add https://github.com/hongbietcode/synthetic-claude --skill databases-hongbietcode
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/hongbietcode/synthetic-claude/tree/main/plugins/basic-workflow/skills/databases
Command: npx skills add https://github.com/hongbietcode/synthetic-claude --skill databases-hongbietcode

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

The Databases Skill provides a unified, practical guide for working with both MongoDB (document-based) and PostgreSQL (relational) databases, enabling teams to design schemas, write queries, optimize performance, and coordinate migrations and backups across systems.

Core Features & Use Cases

  • Unified database guidance: design schemas, indexes, and migrations for MongoDB and PostgreSQL.
  • Operational workflows: backup/restore, migrations, and performance analysis across both engines.
  • Use Case: A team consolidates data workloads by modeling a MongoDB collection and a PostgreSQL table, then generates a synchronized migration plan and performance checks.

Quick Start

Use this skill to outline a plan for migrating a sample MongoDB collection to PostgreSQL, including basic index recommendations and a test backup workflow.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I migrate data from MongoDB to PostgreSQL?▼

Migrating MongoDB to PostgreSQL involves generating a synchronized migration plan that maps document collections to relational tables. This skill provides Python-based tooling and scripts to model schemas and coordinate cross-database workflows.

What is the best way to optimize PostgreSQL and MongoDB queries together?▼

Query optimization across PostgreSQL and MongoDB requires unified performance analysis and proper indexing strategies. This skill enables you to design indexes and run performance checks to analyze and improve query execution across both database engines.

Can I use pymongo and psycopg2 for cross-database backups?▼

Yes, you can use pymongo and psycopg2 libraries for API access alongside common CLI utilities like mongodump and pg_dump. This skill outlines operational workflows to execute synchronized backup and restore processes across both systems.

Do I need Python to handle database schema design for MongoDB and PostgreSQL?▼

Python is required to run the included scripts and tooling for unified schema design. This skill relies on Python-based tooling and optional pymongo and psycopg2 libraries to coordinate database design, migrations, and administration tasks.

How does cross-database replication work between MongoDB and PostgreSQL?▼

Cross-database replication coordinates data synchronization between MongoDB collections and PostgreSQL tables. This skill provides reference guides and scripts to configure replication workflows and maintain data consistency across mixed database environments.

When should I not use a unified tooling approach for database administration?▼

Avoid unified tooling if your environment exclusively uses a single database engine without cross-database workflows. This skill is designed for teams managing mixed PostgreSQL and MongoDB environments requiring synchronized migrations and backups.

Related Skills

Explore More Software Engineering Skills→
samhvw8samhvw8
10

databases

Guide MongoDB and PostgreSQL schema design, query optimization, migrations, and backups.

Community
Advanced
jackspacejackspace
16

databases

Design, query, and optimize MongoDB and PostgreSQL databases for scalable schemas.

Community
Advanced
jholhewresjholhewres
3

backup

Manage file, database, and system backups with rsync, tar, and database dump tools.

Community
Intermediate
noartemnoartem

laravel-strategy-pattern

Select Laravel strategy implementations at runtime by key.

Community
Intermediate