skills.rest
Jongsix
JongsixCOMMUNITY
Explore all skills by this author →
GitHub

moai-domain-database

Design and tune database schemas, queries, indexes, and caching across PostgreSQL, MongoDB, Redis, and Oracle.

Updated Feb 24, 2026
Search Tags:#query optimization#schema design#database#postgresql#redis#oracle#mongodb
One-click install
npx skills add https://github.com/Jongsix/remote-claudecode --skill moai-domain-database-jongsix
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: moai-domain-database
Source: https://github.com/Jongsix/remote-claudecode/tree/main/.claude/skills/moai-domain-database
Command: npx skills add https://github.com/Jongsix/remote-claudecode --skill moai-domain-database-jongsix

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you design, optimize, and operate databases when you need reliable schemas, faster queries, and better data architecture across relational, document, in-memory, and enterprise systems.

Core Features & Use Cases

  • Schema Design: Build PostgreSQL schemas, MongoDB document models, Redis key structures, and Oracle table layouts.
  • Performance Tuning: Improve query plans, indexing, caching, partitioning, and connection pooling for production workloads.
  • Multi-Database Patterns: Apply polyglot persistence, synchronization, migrations, and hybrid data-routing strategies.
  • Use Case: A developer can use this Skill to troubleshoot a slow analytics query, choose the right storage pattern for user profiles, and define a scalable cache invalidation strategy.

Quick Start

Ask for a database design or performance review for your specific stack, data shape, and workload so the Skill can propose schemas, indexes, and tuning steps.

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 in production?▼

PostgreSQL query optimization involves analyzing query plans, applying proper indexing strategies, tuning caching mechanisms, and configuring connection pooling to significantly reduce execution latency for production workloads.

What is the best way to design schemas across multiple databases like MongoDB and Redis?▼

Designing schemas across multiple databases requires applying polyglot persistence patterns. You build MongoDB document models and Redis key structures while implementing hybrid data-routing and synchronization strategies to match your data shape and workload.

Can I use this for Oracle database performance troubleshooting?▼

Yes, you can use this for Oracle database performance troubleshooting. It supports enterprise database patterns by providing operational guidance for query tuning, indexing, and table layout optimization tailored to Oracle workflows.

How do I set up a scalable cache invalidation strategy?▼

Setting up a scalable cache invalidation strategy involves designing efficient Redis key structures and applying multi-database synchronization patterns to ensure data consistency across your in-memory and persistent storage layers.

When do I need polyglot persistence for my data architecture?▼

You need polyglot persistence when managing multi-database architectures that require combining relational, document, in-memory, and enterprise systems. It allows you to apply hybrid data-routing strategies and choose the right storage pattern for varying workload profiles.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
Globaly-IncGlobaly-Inc

gh-database-design

Design and optimize relational database schemas for high-scale SQL production environments.

Official
Advanced
MovchanetsMovchanets

cc-skill-backend-patterns

Design scalable backend architectures and API layers for Node.js, Express, and Next.js.

Community
Intermediate
claudcherejiclaudchereji

database-optimizer

Analyze query execution plans and design index strategies across multiple database systems.

Community
Advanced