databases

Provide unified guidance for managing MongoDB and PostgreSQL databases.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides unified guidance for designing, querying, and administering both MongoDB (document-oriented) and PostgreSQL (relational) databases, helping teams bridge NoSQL and SQL paradigms, optimize performance, and implement migrations, backups, and user management.

Core Features & Use Cases

  • Unified database guidance for MongoDB and PostgreSQL, including schema design, indexing strategies, and query optimization.
  • Migration, backup, and replication workflows across both database models, with practical examples and best practices for production deployments.
  • Use Case: A data-intensive app stores catalog data in MongoDB and transactional records in PostgreSQL, leveraging each system’s strengths for scale and consistency.

Quick Start

Install and run the included scripts to explore MongoDB and PostgreSQL capabilities; use references to load deeper concepts as needed.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I manage both PostgreSQL and MongoDB schema migrations in a unified workflow?

You manage schema migrations for PostgreSQL and MongoDB by running Python-based tooling in scripts alongside standard CLI tools like mongodump and pg_dump. This unified workflow executes production migrations across relational and document databases.

What is the best way to design indexes for NoSQL and SQL workloads together?

The best way to design indexes for NoSQL and SQL workloads is using unified guidance that applies indexing strategies across both document and relational paradigms. This optimizes query performance for MongoDB and PostgreSQL simultaneously.

Do I need Python and pymongo or psycopg2 to run these database maintenance scripts?

Yes, you need Python with pymongo and psycopg2 dependencies to run the included database maintenance scripts. These libraries drive the unified querying, user management, and maintenance workflows for MongoDB and PostgreSQL.

Can I use mongodump and pg_dump for backups across both database models?

Yes, you can use mongodump and pg_dump for backups across both database models. The Skill relies on these standard CLI tools to implement practical backup and replication workflows for MongoDB and PostgreSQL production deployments.

When should I split catalog data in MongoDB and transactional records in PostgreSQL?

You should split catalog data in MongoDB and transactional records in PostgreSQL when a data-intensive app requires scale for catalog data and consistency for transactions. This leverages each system's strengths for optimized performance.