skills.rest
samhvw8
samhvw8COMMUNITY
Explore all skills by this author →
GitHub

databases

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

10|Updated Nov 20, 2025
Search Tags:#indexing#SQL#postgresql#migration#backup#mongodb
One-click install
npx skills add https://github.com/samhvw8/dot-claude --skill databases-samhvw8
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/samhvw8/dot-claude/tree/main/skills/databases
Command: npx skills add https://github.com/samhvw8/dot-claude --skill databases-samhvw8

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

Provides unified guidance for MongoDB and PostgreSQL tasks, from schema to performance to migrations.

Core Features & Use Cases

  • Schema Design & SQL/Mongo Queries: Data modeling and querying
  • Migrations & Backups: Safe changes and DR
  • Performance & Indexing: Tuning and optimization tips

Quick Start

Set up a simple MongoDB collection and query with PostgreSQL

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize PostgreSQL and MongoDB queries for better performance?▼

Query optimization involves creating appropriate indexes, analyzing execution plans, and restructuring queries. This Skill covers indexing strategies and query tuning for both PostgreSQL and MongoDB, including real-world deployment scenarios to identify bottlenecks and improve response times.

What's the best approach to schema design for MongoDB and PostgreSQL databases?▼

Schema design differs between MongoDB's document model and PostgreSQL's relational model. This Skill provides guidance on data modeling principles for both systems, including normalization strategies, relationship handling, and design patterns that align with each database's strengths.

How do I safely migrate data between PostgreSQL and MongoDB?▼

Database migrations require planning to avoid data loss and downtime. This Skill covers migration workflows, backup and restore procedures, and strategies for transferring schemas and data between PostgreSQL and MongoDB while maintaining consistency.

What indexing strategies improve performance in PostgreSQL and MongoDB?▼

Indexing is critical for query speed in both databases. This Skill explains index types, creation strategies, and monitoring approaches specific to PostgreSQL and MongoDB, helping you identify which columns or fields benefit most from indexes in production deployments.

How do I set up replication and sharding for database scalability?▼

Replication and sharding enable horizontal scaling and high availability. This Skill covers configuration, trade-offs, and operational considerations for implementing replication and sharding in both PostgreSQL and MongoDB environments.

What backup and disaster recovery practices should I follow?▼

Backup and restore workflows are essential for data protection. This Skill provides backup strategies, recovery procedures, and monitoring prerequisites for both PostgreSQL and MongoDB to ensure business continuity and data durability.

Related Skills

Explore More Software Engineering Skills→
CoriatelCoriatel

Hostinger VPS Operations

Harden and maintain Hostinger VPS instances via SSH and package management.

Community
Intermediate
Karthik8402Karthik8402

eSTAR AI Platform

Coordinate pharmaceutical compliance microservices for audit trails, stability reports, and data validation.

Community
Advanced
HieubkavHieubkav

database-backup

Automate pre-migration database backups with Spatie Laravel Backup.

Community
Basic
NickCrewNickCrew
29

database-design-patterns

Provide scalable database design patterns for relational and NoSQL schemas.

Community
Advanced