skills.rest
locdinh209
locdinh209COMMUNITY
Explore all skills by this author →
WebsiteGitHub

databases

Guide MongoDB and PostgreSQL database management and query optimization.

Updated Mar 26, 2026
Search Tags:#postgresql#database management#performance optimization#sql#mongodb
One-click install
npx skills add https://github.com/locdinh209/curation-skills --skill databases-locdinh209
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/locdinh209/curation-skills/tree/main/databases
Command: npx skills add https://github.com/locdinh209/curation-skills --skill databases-locdinh209

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill Unit helps you master the essential operations and configurations for both MongoDB and PostgreSQL databases. It provides a unified guide for database management, query optimization, and performance tuning.

Core Features & Use Cases

  • Database Schema Design: Learn how to design and optimize database schemas for both MongoDB and PostgreSQL.
  • Query Writing: Write efficient SQL and MongoDB queries, including aggregation pipelines and complex joins.
  • Performance Optimization: Understand indexing strategies, query optimization, and database performance analysis.
  • Database Management: Set up replication, sharding, and clustering for high availability and scalability.
  • Use Case: Whether you are building a content management system or an e-commerce platform, this Skill Unit will help you efficiently manage your databases.

Quick Start

To get started, open the 'databases' skill directory and navigate to the 'scripts/' folder. Run the script 'db_migrate.py --db mongodb' to generate migrations for your MongoDB database.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize slow PostgreSQL queries and improve database performance?▼

PostgreSQL performance optimization involves analyzing query execution plans and applying indexing strategies to improve database performance. This Skill provides guidance on query optimization techniques and database performance analysis for efficient SQL operations.

What's the best way to design database schemas for MongoDB and PostgreSQL?▼

Designing database schemas for MongoDB and PostgreSQL requires understanding structural differences between relational and NoSQL models. This Skill provides comprehensive schema design guidance to optimize data storage for both document-based and relational architectures.

How do I set up replication and sharding for high availability databases?▼

Setting up replication and sharding configures database clustering for high availability and scalability. This Skill covers database management configurations for both MongoDB and PostgreSQL to ensure distributed data availability.

How do I write efficient MongoDB aggregation pipelines and complex SQL joins?▼

Writing efficient MongoDB aggregation pipelines and complex SQL joins requires mastering query syntax for both NoSQL and relational databases. This Skill guides query writing for MongoDB and PostgreSQL to extract and manipulate data effectively.

Do I need prior experience with psql and mongosh to use this database management skill?▼

Yes, using this database management Skill requires existing knowledge of MongoDB and PostgreSQL, including command-line tools like psql and mongosh. It is designed for developers, DBAs, and system administrators managing relational and NoSQL databases.

Related Skills

Explore More Software Engineering Skills→
olasunkanmi-SEolasunkanmi-SE
139

mongodb

Manage MongoDB databases via mongosh using MONGODB_URI connections.

Community
Intermediate
samhvw8samhvw8
10

databases

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

Community
Advanced
VuNguyenVietTienVuNguyenVietTien

databases

Design database schemas, optimize queries, and plan migrations for MongoDB and PostgreSQL.

Community
Intermediate
Fantasia1999Fantasia1999

database-designer

Analyzes SQL DDL schemas and generates zero-downtime migration scripts.

Community
Advanced