Can I use this for production database performance tuning?

Absolutely. It includes specific patterns for analyzing slow queries using EXPLAIN ANALYZE for Postgres and profiling for MongoDB to recommend index optimizations.

Does it help with database migrations?

Yes, the skill includes Python utilities and best practices for generating, applying, and managing schema evolutions and data migrations for both platforms.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive tools, syntax guides, and best practices for both PostgreSQL (Relational/SQL) and MongoDB (Document/NoSQL).

How do I know which database to choose for my project?

The skill includes a built-in selection guide that compares MongoDB and PostgreSQL across features like scaling, consistency, and data structure to help you make an informed decision.

Database Architect & Management

Name: Database Architect & Management
Author: Microck

byMicrock

•

データベース管理

Manage and optimize both MongoDB and PostgreSQL environments, from schema design and complex querying to performance tuning and production administration.

概要

This skill provides a unified workflow for handling the world's most popular document and relational databases within Claude. Whether you are building a flexible NoSQL backend with MongoDB Atlas or a robust ACID-compliant system with PostgreSQL, this skill offers specialized guidance on data modeling, migration strategies, and performance optimization. It bridges the gap between different database paradigms, helping developers select the right tool for their use case and execute production-grade operations like sharding, replication, and complex query analysis.

主な機能

Performance tuning with EXPLAIN ANALYZE and index optimization
81 GitHub stars
Advanced aggregation pipeline and complex join optimization
Cross-platform support for MongoDB (BSON) and PostgreSQL (SQL)
Production-ready administration including backups and sharding
Automated database migration and schema evolution strategies

ユースケース

Designing and implementing scalable multi-tenant database schemas
Optimizing slow-running queries and implementing indexing strategies
Migrating data and managing infrastructure for production clusters

概要

主な機能

Performance tuning with EXPLAIN ANALYZE and index optimization
81 GitHub stars
Advanced aggregation pipeline and complex join optimization
Cross-platform support for MongoDB (BSON) and PostgreSQL (SQL)
Production-ready administration including backups and sharding
Automated database migration and schema evolution strategies

ユースケース

Designing and implementing scalable multi-tenant database schemas
Optimizing slow-running queries and implementing indexing strategies
Migrating data and managing infrastructure for production clusters