Is there a guide for choosing between MongoDB and PostgreSQL?

Yes, the skill includes a comparison guide to help you select the right database based on schema flexibility, consistency, and scaling needs.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive support and best practices for both PostgreSQL (Relational) and MongoDB (Document) systems.

Can this skill help with database performance tuning?

Absolutely, it includes detailed guidance on query analysis using EXPLAIN, indexing strategies, and performance-checking scripts.

Does it include automation scripts for maintenance?

Yes, it features Python utilities for generating migrations, performing backups, and analyzing slow queries.

Database Architect & Manager

Name: Database Architect & Manager
Author: Microck

byMicrock

•

데이터베이스 관리

Streamlines database design, query optimization, and administrative tasks for both MongoDB and PostgreSQL environments.

소개

This skill empowers Claude to act as a database specialist for both relational (PostgreSQL) and document-oriented (MongoDB) systems. It provides a unified framework for architecting schemas, writing complex SQL or aggregation pipelines, and performing critical DevOps tasks like migrations, backups, and performance tuning. Whether you are choosing the right data model for a new project or optimizing slow queries in a production environment, this skill provides domain-specific best practices and implementation patterns needed for robust data management.

주요 기능

Comprehensive administration guides for users, permissions, and sharding
Automated migration and backup utilities via integrated Python scripts
81 GitHub stars
Dual-support for PostgreSQL relational modeling and MongoDB document design
Advanced query construction including SQL JOINs and MongoDB aggregation pipelines
Performance optimization through query analysis and indexing strategies

사용 사례

Troubleshooting and optimizing slow-running production queries
Architecting scalable data models for new applications
Executing secure database migrations and backup strategies

소개

주요 기능

Comprehensive administration guides for users, permissions, and sharding
Automated migration and backup utilities via integrated Python scripts
81 GitHub stars
Dual-support for PostgreSQL relational modeling and MongoDB document design
Advanced query construction including SQL JOINs and MongoDB aggregation pipelines
Performance optimization through query analysis and indexing strategies

사용 사례

Troubleshooting and optimizing slow-running production queries
Architecting scalable data models for new applications
Executing secure database migrations and backup strategies