skills.rest
locnbk2002
locnbk2002COMMUNITY
Explore all skills by this author →
GitHub

databases

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
One-click install
npx skills add https://github.com/locnbk2002/my-copilot --skill databases-locnbk2002
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
dige04dige04

databases

Analyze and optimize MongoDB and PostgreSQL performance across production workloads.

Community
Intermediate
sitharaj88sitharaj88
1

db-mongodb

Generate MongoDB schemas, aggregation pipelines, indexes, and replica set configurations.

Community
Advanced
samhvw8samhvw8
10

databases

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

Community
Advanced