skills.rest
mchien15
mchien15COMMUNITY
Explore all skills by this author →
GitHub

databases

Design database schemas and write cross-DB queries for MongoDB and PostgreSQL.

Updated Mar 29, 2026
Search Tags:#postgresql#sql#nosql#data-modeling#mongodb#databases#schema-design
One-click install
npx skills add https://github.com/mchien15/wrenai --skill databases-mchien15
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/mchien15/wrenai/tree/main/.claude/skills/databases
Command: npx skills add https://github.com/mchien15/wrenai --skill databases-mchien15

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill provides unified guidance for designing schemas and writing cross-database queries across MongoDB and PostgreSQL, helping teams avoid fragmentation and inconsistencies.

Core Features & Use Cases

  • OLTP/OLAP design guidance for document and relational databases.
  • SQL and NoSQL query examples, migration patterns, and performance optimization checklists.
  • Real-world scenario: a data platform team consolidates schema standards to support transactional workloads and analytics dashboards.

Quick Start

Run a quick cross-database schema review by loading the included references and scripts to implement best practices.

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 is unified here through step-by-step execution guides and reference materials, enforcing best-practice normalization, naming, and indexing across both relational and document data models.

What's the best way to optimize SQL queries for transactional and analytical workloads?▼

Optimizing SQL queries for transactional and analytical workloads requires applying the included performance tuning checklists, which cover indexing strategies, normalization rules, and schema adjustments to support both OLTP and OLAP demands.

Does this provide migration patterns between NoSQL and relational databases?▼

Migration patterns between NoSQL and relational databases are provided, offering cross-database query examples and structural transition guidance to help teams consolidate schema standards and avoid data fragmentation inconsistencies.

Can I use pymongo and psycopg2 to execute cross-DB queries?▼

You can use pymongo and psycopg2 dependencies to execute cross-database queries, leveraging the included scripts to implement practical tooling guidance and connect to both MongoDB and PostgreSQL environments.

When do I need schema design standards for a data platform team?▼

Schema design standards are needed when a data platform team consolidates database architectures to support transactional workloads and analytics dashboards, ensuring robust cross-DB schema reviews and preventing fragmented implementations.

Related Skills

Explore More Data & Analytics Skills→
samhvw8samhvw8
10

databases

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

Community
Advanced
cin12211cin12211
218

database-expert

Optimize database performance and design schemas across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
JNZader-VaultJNZader-Vault

powerbi

Develop Power BI solutions with DAX measures, Power Query transformations, and dashboard designs.

Official
Advanced
0xkynz0xkynz

database-expert

Analyze database queries and propose index and schema improvements.

Community
Advanced