databases

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

Updated Feb 8, 2026
One-click install
npx skills add https://github.com/brixtonpham/claude-setup --skill databases-brixtonpham
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/brixtonpham/claude-setup/tree/main/hub/skills/databases
Command: npx skills add https://github.com/brixtonpham/claude-setup --skill databases-brixtonpham

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill unifies database tooling for MongoDB and PostgreSQL, enabling centralized backups, migrations, and performance analysis to streamline data workflows and reduce maintenance toil.

Core Features & Use Cases

  • Backup & Restore Automation: schedule and execute backups and restores for MongoDB and PostgreSQL from a single interface.
  • Schema Migrations: generate and apply migrations across both databases with rollback support.
  • Performance & Optimization: analyze slow queries, identify missing indexes, and provide actionable recommendations.

Quick Start

To get started, install Python 3.x, ensure MongoDB and PostgreSQL CLIs are accessible, and run the included scripts to back up a database, create migrations, or generate performance reports. For example, back up a MongoDB database with the included script, then list backups.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I automate backups for both MongoDB and PostgreSQL from a single tool?

You can automate MongoDB and PostgreSQL backups from a single interface by running the included Python scripts, which require pymongo and psycopg2 drivers plus access to mongodump and pg_dump CLIs.

Can I generate schema migrations that support rollback for PostgreSQL and MongoDB?

Yes, you can generate and apply schema migrations across both PostgreSQL and MongoDB databases with rollback support by executing the provided migration scripts in your Python runtime environment.

How do I analyze slow queries and find missing indexes in MongoDB and PostgreSQL?

You can analyze slow queries, identify missing indexes, and receive optimization recommendations by running the performance analysis scripts included for both MongoDB and PostgreSQL databases.

Do I need Python drivers installed to run database migrations and performance checks?

Yes, you need Python 3.x with pymongo and psycopg2 drivers installed, plus accessible MongoDB and PostgreSQL CLIs like mongodump and pg_dump to execute migrations, backups, and performance checks.

What is the best way to manage database administration tasks across development and production environments?

The best way is using a unified tooling approach that centralizes backups, migrations, and performance analysis for MongoDB and PostgreSQL, applying to development, staging, and production environments for data-heavy applications.

Are there limitations when using mongodump and pg_dump for automated database restores?

Limitations include requiring direct access to mongodump and pg_dump CLI tools alongside a Python runtime, meaning restores depend on CLI availability and proper driver configuration for both database platforms.