skills.rest
Devattom
DevattomCOMMUNITY
Explore all skills by this author →
GitHub

databases

Guide PostgreSQL and MongoDB database management, schema design, and query optimization.

1|Updated Feb 26, 2026
Search Tags:#performance#database#postgresql#migration#sql#query#mongodb
One-click install
npx skills add https://github.com/Devattom/.claude --skill databases-devattom
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/Devattom/.claude/tree/main/skills/databases
Command: npx skills add https://github.com/Devattom/.claude --skill databases-devattom

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a unified guide for working with both PostgreSQL (relational) and MongoDB (document-oriented) databases, helping you choose the right tool and optimize your data management.

Core Features & Use Cases

  • Database Selection: Guides you on when to use MongoDB (flexibility, scaling) vs. PostgreSQL (consistency, complex queries).
  • CRUD Operations: Demonstrates common Create, Read, Update, Delete patterns for both databases.
  • Indexing & Optimization: Offers strategies for improving query performance in both systems.
  • Use Case: You need to decide whether to use a relational or document database for a new project, or you need to optimize a slow-running SQL query.

Quick Start

Use the databases skill to get a quick start guide for setting up PostgreSQL.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize a slow-running PostgreSQL query?▼

To optimize slow-running PostgreSQL queries, apply indexing strategies and query performance tuning techniques. This Skill provides best practices for schema design and query optimization to improve relational database retrieval speed.

When should I use MongoDB vs PostgreSQL for a new project?▼

Choose MongoDB for flexibility and scaling with document-oriented data models, or PostgreSQL for consistency and complex queries. This guidance helps you select the right database based on your specific data structure and operational requirements.

What is the best way to structure a MongoDB aggregation pipeline?▼

Structuring a MongoDB aggregation pipeline requires understanding advanced document-oriented patterns. This Skill covers practical examples for common operations, demonstrating how to build pipelines for complex data transformations and queries.

How do I use window functions in PostgreSQL for complex queries?▼

Using PostgreSQL window functions allows advanced relational data analysis across result sets. This Skill provides comprehensive guidance on advanced patterns like window functions, offering practical examples for complex SQL query operations.

Can I perform database migration between relational and document-oriented models?▼

Database migration between relational and document-oriented models requires understanding both PostgreSQL and MongoDB structures. This Skill covers schema design and CRUD operations for both systems, guiding practical migration patterns.

Related Skills

Explore More Software Engineering Skills→
dige04dige04

databases

Analyze and optimize MongoDB and PostgreSQL performance across production workloads.

Community
Intermediate
Thiago-Cruz-engThiago-Cruz-eng

mongodb-aggregation-pipeline

Build optimized MongoDB aggregation pipelines with $match, $group, $lookup, and $facet.

Community
Advanced
takayatomosetakayatomose

database

Design migration-driven data persistence layers for PostgreSQL, MongoDB, and Redis.

Community
Advanced
Arupbiswas09Arupbiswas09

data-storage

Evaluate data shapes and access patterns to recommend database types and scaling strategies.

Community
Advanced