skills.rest
HsnSaboor
HsnSaboorCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

databases

Manage MongoDB and PostgreSQL databases with schema design and query optimization.

Updated Jan 21, 2026
Search Tags:#database#postgresql#optimization#sql#nosql#administration#mongodb
One-click install
npx skills add https://github.com/HsnSaboor/open-engineer --skill databases-hsnsaboor
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/HsnSaboor/open-engineer/tree/main/src/skills/bundled/samhvw8-databases
Command: npx skills add https://github.com/HsnSaboor/open-engineer --skill databases-hsnsaboor

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a unified approach to managing and interacting with both MongoDB (NoSQL document database) and PostgreSQL (SQL relational database), simplifying complex database operations.

Core Features & Use Cases

  • Database Administration: Covers schema design, query optimization, indexing, migrations, replication, sharding, and backup/restore for both MongoDB and PostgreSQL.
  • Cross-Database Operations: Offers guidance on selecting the appropriate database for specific use cases and provides common operation examples (CRUD, indexing) for both.
  • Use Case: You need to design a new data model for a web application. This Skill helps you decide whether to use MongoDB for its flexibility or PostgreSQL for its relational integrity, and then guides you through creating tables/collections, indexes, and writing initial queries.

Quick Start

Use the databases skill to create a new user index on the 'email' field in PostgreSQL.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize SQL queries and create indexes in PostgreSQL?▼

PostgreSQL query optimization involves creating targeted indexes and refining SQL statements to accelerate data retrieval. This skill guides you through schema design, indexing, and SQL query optimization to improve relational database performance.

When should I use MongoDB vs PostgreSQL for my application schema?▼

Choose MongoDB for flexible document-oriented data models, or PostgreSQL when relational integrity is required. This skill helps you select the appropriate database based on your use case and guides you through designing the corresponding schema and queries.

How do I configure replication and sharding for MongoDB?▼

Configuring MongoDB replication and sharding involves distributing data across multiple nodes to ensure high availability and scale. This skill manages these advanced administration operations, including backup and restore procedures for NoSQL environments.

Can I handle database migrations and backup/restore for both SQL and NoSQL databases?▼

Yes, you can handle database migrations, backup, and restore operations for both PostgreSQL and MongoDB. This skill provides unified database administration support covering schema migrations and backup/restore for both relational and document data models.

What is the best way to build aggregation pipelines in MongoDB?▼

Building MongoDB aggregation pipelines involves chaining data processing stages to transform and filter documents. This skill supports advanced NoSQL features like aggregation pipelines to help you process complex document-oriented data workflows.

Related Skills

Explore More Software Engineering Skills→
googlegoogle
17.1k

cloud-sql-basics

Manage Cloud SQL instances and databases using gcloud CLI and Terraform.

Official
Advanced
InfinityBowmanInfinityBowman
3

Data Safety Analysis

Audit data safety risks across database migrations and backups with structured reporting output.

Community
Basic
0xRayAI0xRayAI

performance-engineer

Profile system baselines and identify latency bottlenecks across application layers.

Official
Advanced
ryukyagamilightryukyagamilight
1

cloud-backup

Manage data backups and synchronization to AWS S3, Alibaba OSS, and Azure Blob Storage.

Community
Advanced