skills.rest
seo-jinseok
seo-jinseokCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

moai-domain-database

Provide expert guidance on PostgreSQL, Oracle, MongoDB, and Redis database management.

Updated Dec 14, 2025
Search Tags:#database#postgresql#redis#data modeling#oracle#performance tuning#mongodb
One-click install
npx skills add https://github.com/seo-jinseok/regulation_manager --skill moai-domain-database-seo-jinseok
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: moai-domain-database
Source: https://github.com/seo-jinseok/regulation_manager/tree/main/.claude/skills/moai-domain-database
Command: npx skills add https://github.com/seo-jinseok/regulation_manager --skill moai-domain-database-seo-jinseok

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the complexity of managing diverse database systems and advanced data patterns, ensuring efficient, scalable, and performant data storage and retrieval for modern applications.

Core Features & Use Cases

  • Multi-Database Support: Expertise in PostgreSQL, MongoDB, Redis, and Oracle.
  • Advanced Data Patterns: Covers schema design, query optimization, indexing, migrations, and ORM configurations.
  • Performance Tuning: Optimizes database performance for speed and scalability.
  • Use Case: When designing a new application architecture that requires both relational (PostgreSQL) and NoSQL (MongoDB) databases, this Skill can provide guidance on schema design, data modeling, and inter-database communication strategies.

Quick Start

Configure a PostgreSQL database connection with a pool size of 20 and enable query logging.

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 PostgreSQL query performance for slow response times?▼

PostgreSQL query performance tuning involves advanced indexing strategies, schema design adjustments, and query optimization techniques to ensure efficient, scalable data retrieval for modern applications.

What is the best way to design schemas when using both PostgreSQL and MongoDB?▼

Schema design for mixed PostgreSQL and MongoDB environments requires advanced data modeling strategies that define relational constraints and inter-database communication patterns for scalable application architectures.

Does this database management guidance cover Redis caching configurations?▼

Redis caching configurations are covered alongside PostgreSQL, Oracle, and MongoDB, providing expert-level NoSQL database management guidance for schema design, data modeling, and performance tuning.

How do I configure an ORM for database migrations without losing data?▼

Configuring an ORM for database migrations requires careful schema design and data modeling strategies to manage structural changes efficiently while maintaining data integrity across relational and NoSQL systems.

When should I use Oracle over PostgreSQL for enterprise database management?▼

Oracle and PostgreSQL serve different enterprise database management needs, requiring comparative analysis of schema design, performance tuning, and data modeling constraints to determine the optimal relational system.

Related Skills

Explore More Software Engineering Skills→
MovchanetsMovchanets

database

Design SQL and NoSQL database schemas, migrations, and operational workflows.

Community
Advanced
pascallammerspascallammers
1

postgresql

Optimize PostgreSQL queries with EXPLAIN ANALYZE and indexing strategies.

Community
Advanced
CJ-1981CJ-1981

moai-domain-database

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

Community
Advanced
Fancu1Fancu1

database-design

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

Community
Intermediate