moai-domain-database

Optimize PostgreSQL, MongoDB, Redis, and Oracle database schemas and queries.

Updated Mar 11, 2026

Search Tags:#database #postgresql #redis #data modeling #oracle #performance tuning #mongodb

Ready to run

npx skills add https://github.com/thkim2015/pdf-tool --skill moai-domain-database-thkim2015

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: moai-domain-database
Source: https://github.com/thkim2015/pdf-tool/tree/main/.claude/skills/moai-domain-database
Command: npx skills add https://github.com/thkim2015/pdf-tool --skill moai-domain-database-thkim2015

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses complex challenges in designing, optimizing, and managing diverse database systems, ensuring data integrity, performance, and scalability for modern applications.

Core Features & Use Cases

Database Design & Optimization: Expert guidance on schema design, query tuning, and indexing for PostgreSQL, MongoDB, Redis, and Oracle.
Multi-Database Architectures: Strategies for integrating and managing data across different database types (polyglot persistence).
Use Case: Optimize a slow-running PostgreSQL query by implementing advanced indexing and partitioning, or design a robust data model for a new microservice using MongoDB.

Quick Start

Consult the PostgreSQL module for advanced indexing strategies to improve query performance.

Frequently Asked Questions about moai-domain-database

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

FAQPage Schema

How do I optimize slow PostgreSQL queries using advanced indexing and partitioning?▼

To optimize slow PostgreSQL queries, you can apply advanced indexing strategies and table partitioning to reduce scan times and improve query performance. This Skill provides expert guidance on schema design and query tuning to resolve data bottlenecks.

What is polyglot persistence and how does it work for multi-database architectures?▼

Polyglot persistence is an architectural pattern for multi-database architectures that integrates different database types like PostgreSQL, MongoDB, and Redis. This Skill provides strategies for managing data across diverse systems to ensure scalability and data integrity.

Can I use this for schema design and data modeling in MongoDB microservices?▼

Yes, you can use this Skill for MongoDB schema design and data modeling. It offers expert guidance to design robust data models specifically tailored for new microservices, ensuring optimal document structures and application performance.

Does this Skill cover performance tuning for both Oracle and Redis configurations?▼

This Skill covers performance tuning and ORM configuration for both Oracle and Redis. It provides specialized optimization techniques across these diverse database systems to ensure data integrity and high scalability for modern applications.

What are the limitations of using polyglot persistence for modern applications?▼

While polyglot persistence enables multi-database architectures, its limitations include increased complexity in managing data integrity and migrations across diverse systems. This Skill addresses these challenges by providing strategies for integrating and managing data across different database types.