moai-domain-database

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

Updated Nov 28, 2024

Search Tags:#database #postgresql #data modeling #sql #nosql #performance tuning #mongodb

Ready to run

npx skills add https://github.com/desafin/Resource-Monitor-pyQT --skill moai-domain-database-desafin

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: moai-domain-database
Source: https://github.com/desafin/Resource-Monitor-pyQT/tree/main/.claude/skills/moai-domain-database
Command: npx skills add https://github.com/desafin/Resource-Monitor-pyQT --skill moai-domain-database-desafin

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, optimizing, and architecting complex database systems, ensuring data integrity and performance.

Core Features & Use Cases

Database Expertise: Covers PostgreSQL, MongoDB, Redis, and Oracle with advanced patterns.
Performance Tuning: Offers strategies for query optimization, indexing, and scaling.
Data Modeling: Provides guidance on designing robust and efficient data schemas.
Use Case: Optimize a slow PostgreSQL query by implementing appropriate indexes and materialized views, or design a polyglot persistence architecture combining multiple database types for a microservices application.

Quick Start

Use the moai-domain-database skill to design an optimized PostgreSQL schema for a user management 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 with indexing and materialized views?▼

Optimize slow PostgreSQL queries by analyzing execution plans, implementing targeted indexes, and using materialized views to pre-compute complex joins. This Skill provides specific performance tuning strategies for database management.

What is polyglot persistence and when do I need it for microservices?▼

Polyglot persistence combines multiple database types, like PostgreSQL, MongoDB, and Redis, within a single application. You need it for microservices architectures when different services have distinct data modeling and access pattern requirements.

How do I design an efficient data schema for NoSQL databases like MongoDB?▼

Design efficient MongoDB schemas by aligning data structures with application access patterns. This Skill provides data modeling guidance for NoSQL environments, focusing on embedding versus referencing strategies to optimize query performance.

Does this database optimization approach work with both SQL and NoSQL platforms?▼

Yes, this approach covers both SQL and NoSQL platforms, offering expertise across PostgreSQL, MongoDB, Redis, and Oracle. It addresses complex data architecture challenges including schema design and multi-database integration.

What is the best way to scale database performance for high-traffic applications?▼

Scale database performance by applying advanced indexing strategies, query optimization, and polyglot persistence patterns. This Skill offers comprehensive performance tuning guidance to ensure data integrity under high traffic.