skills.rest
CJ-1981
CJ-1981COMMUNITY
Explore all skills by this author →
GitHub

moai-domain-database

Design and optimize PostgreSQL, MongoDB, Redis, and Oracle database schemas and queries.

Updated Feb 2, 2026
Search Tags:#database#postgresql#data modeling#sql#nosql#performance tuning#mongodb
One-click install
npx skills add https://github.com/CJ-1981/excel-processor --skill moai-domain-database-cj-1981
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: moai-domain-database
Source: https://github.com/CJ-1981/excel-processor/tree/main/.claude/skills/moai-domain-database
Command: npx skills add https://github.com/CJ-1981/excel-processor --skill moai-domain-database-cj-1981

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides expert guidance and implementation patterns for designing, optimizing, and managing complex database systems, ensuring data integrity, performance, and scalability.

Core Features & Use Cases

  • Database Design & Modeling: Create robust schemas for relational (PostgreSQL, Oracle) and NoSQL (MongoDB) databases.
  • Performance Tuning: Optimize queries, implement indexing strategies, and tune database configurations for maximum efficiency.
  • Data Management: Handle migrations, replication, sharding, and advanced data patterns like polyglot persistence.
  • Use Case: You need to design a scalable database architecture for a new e-commerce platform, choosing between SQL and NoSQL for different data types, and ensuring high availability.

Quick Start

Use the moai-domain-database skill to design a PostgreSQL schema for a user management system with email and username uniqueness constraints.

Frequently Asked Questions about moai-domain-database

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

FAQPage Schema
How do I design a scalable database schema for an e-commerce platform using PostgreSQL and MongoDB?▼

Database schema design for e-commerce uses polyglot persistence to map transactional data to PostgreSQL and flexible catalog data to MongoDB, ensuring high availability. This approach applies schema design patterns to maintain data integrity across multiple database systems.

What's the best way to optimize slow PostgreSQL queries and implement indexing strategies?▼

PostgreSQL query optimization involves analyzing execution plans and implementing targeted indexing strategies to reduce latency. Performance tuning configurations and query restructuring maximize database efficiency for modern application data patterns.

When do I need NoSQL data modeling with MongoDB instead of a relational database?▼

NoSQL data modeling with MongoDB is needed when handling modern application data patterns requiring flexible schemas, horizontal scaling, or polyglot persistence. It complements relational databases by managing unstructured data types while maintaining overall system performance.

How do I handle database migrations and configure ORM for PostgreSQL and MongoDB?▼

Database migrations and ORM configuration for PostgreSQL and MongoDB require structured schema design and data modeling expertise to ensure data integrity. Proper migration handling prevents data loss during structural transitions across relational and NoSQL databases.

Does this database optimization approach work with Redis and Oracle for performance tuning?▼

Database performance tuning and optimization apply to Redis and Oracle alongside PostgreSQL and MongoDB. The approach covers indexing, query optimization, and configuration tuning to maximize efficiency across diverse database systems and data patterns.

Related Skills

Explore More Software Engineering Skills→
willdadywilldady
63

database-schema-changes

Manage database schema modifications and synchronization for Platypus backend using Drizzle ORM and CLI toolsets.

Community
Intermediate
samhvw8samhvw8
10

databases

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

Community
Advanced
nicholasgriffintnnicholasgriffintn
2

performance-optimisation

Identify and fix performance bottlenecks across frontend, backend, and database layers.

Community
Basic
wojonswojons
4

testing-database

Test database schemas, migrations, and data integrity with automated scripts.

Community
Intermediate