databases

Name: databases
Availability: InStock
Author: locnbk2002

Design schemas, write queries, and administer MongoDB and PostgreSQL databases.

1|Updated Feb 28, 2026

Search Tags:#query optimization #schema design #database #postgresql #sql #nosql #mongodb

Ready to run

npx skills add https://github.com/locnbk2002/my-copilot --skill databases-locnbk2002

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/locnbk2002/my-copilot/tree/main/my-copilot-backend/skills/databases
Command: npx skills add https://github.com/locnbk2002/my-copilot --skill databases-locnbk2002

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a unified approach to designing schemas, writing queries, and managing both MongoDB and PostgreSQL databases, simplifying complex data operations.

Core Features & Use Cases

Schema Design: Create and optimize database schemas for both relational and document models.
Querying: Write efficient SQL and MongoDB queries, aggregation pipelines, and understand indexing strategies.
Administration: Manage database users, perform migrations, and optimize performance for both systems.
Use Case: You need to design a new schema for user profiles that will be stored in PostgreSQL, and then write a MongoDB aggregation pipeline to analyze user activity logs.

Quick Start

Use the databases skill to design a PostgreSQL schema for an e-commerce product catalog.

Frequently Asked Questions about databases

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

FAQPage Schema

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

Database schema design for PostgreSQL and MongoDB requires modeling relational tables and document structures. This Skill provides comprehensive guidance to create and optimize schemas for both relational and document models within a unified workflow.

What is the best way to write a MongoDB aggregation pipeline for user activity logs?▼

Writing a MongoDB aggregation pipeline involves structuring multi-stage data transformations. This Skill guides you through writing efficient MongoDB queries and aggregation pipelines to analyze document datasets like user activity logs.

How do I optimize SQL queries and indexing strategies in PostgreSQL?▼

Optimizing SQL queries and indexing strategies in PostgreSQL improves database performance. This Skill covers query optimization and indexing strategies to help you write efficient SQL and manage database performance effectively.

Can I manage database migrations and replication for PostgreSQL and MongoDB using one approach?▼

Managing database migrations and replication for PostgreSQL and MongoDB is supported here. This Skill provides administration guidance covering user management, migrations, and replication setup for both relational and document databases.

Do I need to understand both relational and document database concepts to use this approach?▼

Understanding both relational and document database concepts is required. This Skill simplifies complex data operations but requires foundational knowledge of SQL and NoSQL paradigms to design schemas and write queries effectively.