skills.rest
desafin
desafinCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/desafin/Resource-Monitor-pyQT --skill moai-domain-database-desafin
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
andrew-starosciakandrew-starosciak
2

postgres-patterns

Provide PostgreSQL patterns for query optimization, schema design, indexing, and security.

Community
Intermediate
AmidVoshakulAmidVoshakul

database-optimizer

Analyze execution plans and implement indexing strategies to optimize database performance.

Community
Advanced
darblexdarblex

API Gateway & Microservices Builder Skill

Generate API gateways and microservices with Express.js, Hono, tRPC, and GraphQL.

Community
Advanced
johwerjohwer

aws-performance

Optimize AWS infrastructure performance and cost management with CloudWatch, auto-scaling, RDS tuning, S3, and caching.

Community
Advanced