skills.rest
congthang12312
congthang12312COMMUNITY
Explore all skills by this author →
GitHub

databases

Design and optimize MongoDB and PostgreSQL database schemas.

Updated Mar 19, 2026
Search Tags:#indexing#database#sql#data-modeling#mongodb#schema-design
One-click install
npx skills add https://github.com/congthang12312/Sentinel-AI-test --skill databases-congthang12312
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/congthang12312/Sentinel-AI-test/tree/main/.agent/skills/databases
Command: npx skills add https://github.com/congthang12312/Sentinel-AI-test --skill databases-congthang12312

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill helps engineers design robust database schemas and write performant queries for both MongoDB and PostgreSQL, reducing data modeling guesswork and operational risk.

Core Features & Use Cases

  • Database design guidance for OLTP and OLAP, including normalization, data modeling, indexing, and migration strategies.
  • Cross-database guidance for SQL and NoSQL patterns, including writing common queries, aggregation, and performance optimization.
  • Practical workflows and references across transactional, analytics, and ETL scenarios.

Quick Start

Provide a starter schema for a simple e-commerce app and walk through the recommended OLTP/OLAP setup.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I design a database schema for both SQL and NoSQL?▼

Database schema design for OLTP and OLAP requires structuring data for specific workloads: normalized models for transactional Postgres and denormalized patterns for analytics. This skill provides execution steps and best practices for both contexts.

What's the best way to optimize MongoDB and PostgreSQL indexing?▼

Optimizing MongoDB and PostgreSQL indexing requires matching index structures to query patterns and workload types. This skill provides best practices and references for indexing strategies to ensure scalable data retrieval.

Can I use this for database migrations and replication?▼

Yes, you can use this for database migrations and replication. It covers schema design and operational strategies for both MongoDB and PostgreSQL, ensuring maintainable data models across transactional and ETL scenarios.

How do I model data for OLTP and OLAP systems?▼

Modeling data for OLTP and OLAP involves applying normalization for transactional integrity and denormalized structures for analytics. This skill provides cross-database guidance and schema design references for both systems.

Does this skill require psycopg2 and pymongo to work?▼

Yes, this skill requires psycopg2 and pymongo as dependencies to interact with PostgreSQL and MongoDB. These libraries enable the execution steps and query optimization workflows provided by the scripts.

Related Skills

Explore More Software Engineering Skills→
hongbietcodehongbietcode
3

databases

Design, query, migrate, backup, and administer MongoDB and PostgreSQL databases.

Community
Advanced
jackspacejackspace
16

databases

Design, query, and optimize MongoDB and PostgreSQL databases for scalable schemas.

Community
Advanced
Zack2626-okZack2626-ok

databricks-lakebase-provisioned

Create managed PostgreSQL instances within Databricks Lakebase for OLTP workloads.

Community
Advanced
Fancu1Fancu1

database-design

Design and optimize relational and NoSQL database schemas with migration patterns.

Community
Intermediate