Can this skill help with database performance tuning?

Absolutely. It includes detailed guidance on using EXPLAIN ANALYZE, creating compound indexes, and utilizing slow query thresholds to optimize performance.

How does it help in choosing the right database?

It includes a detailed selection guide comparing schema flexibility, consistency requirements, and scaling needs to help you choose between MongoDB and PostgreSQL.

Does it include automation scripts for maintenance?

Yes, the skill provides Python-based utility scripts for handling database migrations, automated backups, and performance health checks.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive support and specific implementation patterns for both PostgreSQL (relational) and MongoDB (document-oriented).

Database Management & Architecture

Name: Database Management & Architecture
Author: xiaxingxiaowei1983

byxiaxingxiaowei1983

0•

Database Management

Streamlines database schema design, query optimization, and production administration for MongoDB and PostgreSQL systems.

This comprehensive skill serves as a unified guide for mastering both relational (PostgreSQL) and document-oriented (MongoDB) database systems within the Claude Code environment. It empowers developers to navigate complex data modeling challenges, offering deep expertise in SQL and BSON query languages, aggregation pipelines, and performance tuning through advanced indexing. Beyond development, it provides robust patterns for critical administrative tasks including schema migrations, backup strategies, replication, and sharding, ensuring your data infrastructure is scalable, secure, and highly available.

Key Features

01Dual-system expertise for MongoDB Atlas and PostgreSQL environments

02Strategic data modeling guidance for flexible vs. relational schemas

03Advanced query optimization using EXPLAIN plans and indexing strategies

040 GitHub stars

05Comprehensive aggregation pipeline and complex SQL join patterns

06Automated Python utilities for migrations, backups, and health checks

Use Cases

01Diagnosing and resolving performance bottlenecks in production queries

02Architecting scalable data models for new high-traffic applications

03Implementing secure database migration and disaster recovery workflows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xiaxingxiaowei1983/ai databases

For use in Claude.ai and ChatGPT