Does it support cloud databases like MongoDB Atlas?

Absolutely. It provides specific guidance for connecting to and managing MongoDB Atlas clusters as well as local PostgreSQL installations.

Can this skill help me choose between SQL and NoSQL?

Yes, it includes a detailed selection guide comparing MongoDB and PostgreSQL based on schema flexibility, consistency needs, and scaling requirements.

Does it provide performance tuning advice?

It includes deep dives into indexing strategies, query analysis using EXPLAIN/EXPLAIN ANALYZE, and optimization patterns for document and relational models.

Can I use it for database migrations?

Yes, the skill covers migration strategies, schema evolution, and includes reference utilities for automating database changes across both systems.

Unified Database Management

Name: Unified Database Management
Author: mrgoonie

bymrgoonie

•

1,395

데이터베이스 관리

Master document-oriented and relational databases by designing schemas, writing optimized queries, and managing migrations for MongoDB and PostgreSQL.

소개

This skill empowers Claude to act as an expert database administrator and architect, providing a comprehensive guide for both MongoDB and PostgreSQL. It streamlines the transition between NoSQL and SQL paradigms, offering deep expertise in schema design, complex aggregation pipelines, indexing strategies, and production-level administration. Whether you are building a flexible real-time application with MongoDB or a high-integrity financial system with PostgreSQL, this skill provides the implementation patterns and CLI knowledge needed to build robust, scalable data layers.

주요 기능

1,395 GitHub stars
Database migration and schema versioning support
Cross-platform expertise in MongoDB and PostgreSQL
Complex query and aggregation pipeline construction
Production administration and backup automation
Performance optimization and indexing strategies

사용 사례

Optimizing slow-running queries and resolving performance bottlenecks
Managing database migrations and infrastructure scaling
Architecting data models for both SQL and NoSQL requirements

소개

주요 기능

1,395 GitHub stars
Database migration and schema versioning support
Cross-platform expertise in MongoDB and PostgreSQL
Complex query and aggregation pipeline construction
Production administration and backup automation
Performance optimization and indexing strategies

사용 사례

Optimizing slow-running queries and resolving performance bottlenecks
Managing database migrations and infrastructure scaling
Architecting data models for both SQL and NoSQL requirements