skills.rest
BoneTheDeveloper
BoneTheDeveloperCOMMUNITY
Explore all skills by this author →
GitHub

databases

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

Updated Aug 23, 2026
Search Tags:#postgresql#sql#nosql#mongodb#databases#data-architecture
One-click install
npx skills add https://github.com/BoneTheDeveloper/Electronic-Contact-Contact-Book --skill databases-bonethedeveloper
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/BoneTheDeveloper/Electronic-Contact-Contact-Book/tree/main/.claude/skills/databases
Command: npx skills add https://github.com/BoneTheDeveloper/Electronic-Contact-Contact-Book --skill databases-bonethedeveloper

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Streamlines cross-database design by offering a unified guide for MongoDB (document) and PostgreSQL (relational) schemas, queries, and optimization techniques.

Core Features & Use Cases

  • OLTP and OLAP guidance for transactional and analytics modeling, indexing, migrations, and performance patterns across MongoDB and PostgreSQL.
  • Reference materials including db-design.md, analytics.md, and transactional.md to help you design, review, and implement robust data models.
  • Automation-ready tooling with Python scripts for migrations, backups, and performance checks to accelerate implementation.

Quick Start

Review the MongoDB and PostgreSQL design resources to start building consistent schemas and efficient queries.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I design scalable database schemas for both PostgreSQL and MongoDB?▼

To design scalable database schemas for PostgreSQL and MongoDB, use unified guidance on relational and document data models to structure schemas, optimize queries, and apply indexing patterns for both transactional and analytics workloads.

What is the best way to optimize OLTP and OLAP workloads across PostgreSQL and MongoDB?▼

Optimize OLTP and OLAP workloads across PostgreSQL and MongoDB by applying targeted indexing strategies, query optimization techniques, and data architecture patterns tailored for transactional processing and analytics modeling.

How do I migrate data between PostgreSQL and MongoDB using Python?▼

Migrate data between PostgreSQL and MongoDB using Python scripts with psycopg2 and pymongo dependencies to automate migrations, execute backups, and perform performance checks.

When should I use a NoSQL document model versus a relational schema for my data architecture?▼

Choose a NoSQL document model for flexible, scalable data structures, and a relational schema for structured data integrity, using cross-database design references to implement the correct data architecture.

Can I use Python to automate database backups and performance checks for PostgreSQL and MongoDB?▼

Yes, you can use Python scripts to automate database backups and performance checks for PostgreSQL and MongoDB, leveraging psycopg2 and pymongo to execute maintenance tasks and validate query optimization.

Does this database design guidance support both transactional and analytics processing?▼

Yes, the database design guidance supports both transactional and analytics processing by providing reference materials for OLTP and OLAP workloads, covering schema design, indexing, and performance patterns.

Related Skills

Explore More Data & Analytics Skills→
hongbietcodehongbietcode
3

databases

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

Community
Advanced
NammDevNammDev
2

databases

Design and optimize database schemas for OLTP and OLAP workloads.

Community
Advanced
chef0111chef0111
1

databases

Manage MongoDB and PostgreSQL databases with schema design, CRUD, indexing, and migrations.

Community
Advanced
Khoatran1999Khoatran1999

databases

Design schemas, optimize queries, and manage maintenance for MongoDB and PostgreSQL.

Community
Advanced