skills.rest
skeeper75
skeeper75COMMUNITY
Explore all skills by this author →
GitHub

moai-domain-database

Provide database expertise for PostgreSQL, MongoDB, Redis, and Oracle.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

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

Core Features & Use Cases

  • Multi-Database Expertise: Covers PostgreSQL, MongoDB, Redis, Oracle, and hybrid architectures.
  • Performance Tuning: Offers strategies for query optimization, indexing, and connection management.
  • Data Modeling & Design: Provides patterns for schema design, migrations, and advanced data structures.
  • Use Case: Optimize a slow PostgreSQL query by implementing appropriate indexing and partitioning, or design a robust caching strategy using Redis for a high-traffic web application.

Quick Start

Use the moai-domain-database skill to design an optimized PostgreSQL schema for a user authentication system.

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 indexing and partitioning?▼

PostgreSQL query optimization involves analyzing execution plans and applying targeted indexing and partitioning strategies. This Skill provides specific patterns for identifying bottlenecks, creating efficient indexes, and partitioning large tables to improve query response times.

What's the best way to design a scalable hybrid database architecture with MongoDB and Redis?▼

Designing a hybrid architecture with MongoDB and Redis requires balancing persistent document storage with in-memory caching layers. This Skill offers data modeling patterns and caching strategies to ensure high availability and low-latency data access across mixed database environments.

How does schema migration work for complex data modeling in Oracle databases?▼

Schema migration for Oracle data modeling involves structured transitions of database schemas without downtime. This Skill provides implementation patterns for executing migrations, maintaining data integrity, and configuring ORMs to support evolving data structures.

When do I need Redis caching for a high-traffic web application?▼

Redis caching is needed for high-traffic web applications experiencing database read bottlenecks or requiring sub-millisecond data retrieval. This Skill helps you determine optimal caching boundaries, connection management, and data structures for your specific traffic patterns.

Can I use this guidance for performance tuning on both SQL and NoSQL platforms?▼

Yes, performance tuning guidance covers both SQL and NoSQL platforms. This Skill addresses query optimization, indexing strategies, and connection management comprehensively across PostgreSQL, Oracle, MongoDB, and Redis to handle diverse database technologies.

Related Skills

Explore More Software Engineering Skills→
aws-samplesaws-samples
18

workload-assessment

Analyze legacy workload dependencies, schemas, and constraints for modernization readiness.

Official
Advanced
jonathanbelolojonathanbelolo

composable-rust-production

Codify deployment, migrations, backups, tuning, monitoring, and recovery for Composable Rust applications.

Community
Advanced
yuhle-qugyuhle-qug

database-expert

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

Community
Advanced
desafindesafin

moai-domain-database

Optimize PostgreSQL, MongoDB, Redis, and Oracle databases with indexing and query tuning.

Community
Advanced