skills.rest
vuminhieu
vuminhieuCOMMUNITY
Explore all skills by this author →
GitHub

databases

Design, query, and optimize MongoDB and PostgreSQL databases with standard CLI tools.

Updated Feb 2, 2026
Search Tags:#performance#indexing#database#migrations#PostgreSQL#MongoDB#backups
One-click install
npx skills add https://github.com/vuminhieu/spexor-client --skill databases-vuminhieu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/vuminhieu/spexor-client/tree/main/.agent/skills/skills/databases
Command: npx skills add https://github.com/vuminhieu/spexor-client --skill databases-vuminhieu

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill provides a unified, practical guide for working with MongoDB and PostgreSQL, helping teams design schemas, write efficient queries, optimize indexes, perform migrations, and manage backups and production administration.

Core Features & Use Cases

  • Design and optimize database schemas for both document-based and relational models.
  • Write and optimize queries, aggregations, and joins across MongoDB and PostgreSQL.
  • Plan migrations, backups, replication, and sharding for resilient, production deployments.
  • Analyze performance and tune indexes to meet SLA targets in real-world workloads.
  • Use cases include multi-tenant data stores, analytics dashboards, and reliable backup/restore workflows.

Quick Start

Use this skill to prototype a small MongoDB collection and a PostgreSQL table, then run a basic query and index check to validate setup.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize PostgreSQL indexes and analyze query performance for slow workloads?▼

To optimize PostgreSQL indexes and analyze query performance, this skill provides scripts to tune indexes and run performance analysis using standard CLI tools like psql, targeting real-world workload SLAs.

What's the best way to plan MongoDB migrations and backups for production deployments?▼

The best way to plan MongoDB migrations and backups involves using standard CLI tools like mongosh and mongodump to establish resilient replication and reliable restore workflows for production deployments.

How do I design database schemas for both relational and document-based models?▼

Designing database schemas for relational and document-based models requires structuring PostgreSQL tables and MongoDB collections to support scalable, multi-tenant data stores and analytics dashboards.

Can I manage both PostgreSQL and MongoDB administration using standard CLI tools?▼

Yes, you can manage both PostgreSQL and MongoDB administration using standard CLI tools including psql, pg_dump, mongosh, and mongodump to execute queries, perform backups, and maintain production environments.

Do I need pymongo and psycopg2 to run database queries and aggregations?▼

You need pymongo and psycopg2 dependencies to programmatically connect, execute queries, and run aggregations or joins across MongoDB and PostgreSQL databases from your development scripts.

Related Skills

Explore More Data & Analytics Skills→
qhkmqhkm
4

postgres

Automate PostgreSQL queries, schema changes, backups, and diagnostics via psql tools.

Community
Advanced
PrepLabsAIPrepLabsAI
94

sql-optimization-interviewer

Diagnose, optimize, and validate SQL queries for scalable data workloads.

Official
Advanced
reckerswartzreckerswartz

query

Encapsulate complex database queries into reusable query objects for Rails apps.

Community
Advanced
rafaelcallejarafaelcalleja
2

databases

Manage PostgreSQL and MongoDB schema design, queries, and administration.

Community
Advanced