Does it support advanced features like sharding and replication?

Absolutely. This skill provides guidance on configuring horizontal scaling via sharding in MongoDB and setting up high-availability replication in PostgreSQL.

Can this skill help me choose between MongoDB and PostgreSQL?

Yes, it includes a detailed selection guide comparing schema flexibility, consistency requirements, and scaling needs to help you pick the right database for your use case.

How does it handle database performance issues?

It provides tools and patterns for analyzing query performance, interpreting EXPLAIN outputs, and implementing optimal indexing strategies to reduce latency.

Are there automated scripts included for migrations?

Yes, the skill references Python-based utilities for generating and applying migrations, performing backups, and conducting automated performance checks.

Unified Database Management

Name: Unified Database Management
Author: piotroq

bypiotroq

0•

データベース管理

Streamlines database architecture, query optimization, and management for both MongoDB and PostgreSQL environments.

The Databases skill provides a comprehensive framework for working with both document-oriented (MongoDB) and relational (PostgreSQL) database systems. It empowers developers to design robust schemas, write complex aggregation pipelines, and perform advanced SQL operations while ensuring data integrity and performance. Whether you are navigating the flexibility of BSON documents or the strict consistency of ACID transactions, this skill offers specific guidance on indexing, migrations, replication, and production-grade administration to ensure your data layer is scalable and efficient.

主な機能

01Advanced query optimization and index management strategies

02Comprehensive performance analysis using EXPLAIN and profiling tools

03Automated migration and backup configuration patterns

040 GitHub stars

05Expert schema design and data modeling for SQL and NoSQL

06Cross-platform support for MongoDB and PostgreSQL ecosystems

ユースケース

01Architecting high-availability data layers for web and mobile applications

02Refactoring legacy SQL queries into high-performance MongoDB aggregation pipelines

03Implementing complex relational schemas with strict referential integrity in PostgreSQL

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add piotroq/adwokat-trzebnica-html-to-php-com databases

For use in Claude.ai and ChatGPT

Download Skill