Does this skill support both SQL and NoSQL databases?

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

Is it suitable for production environment management?

Yes, the skill covers advanced administrative topics like replication, sharding, backup strategies, and user permission management.

Can this skill help with database migrations?

Absolutely. It includes guidance and Python utilities for generating and applying migrations for both platforms to ensure smooth data transitions.

Can it help me decide between MongoDB and PostgreSQL?

Yes, it includes a detailed selection guide comparing the strengths of each database based on schema flexibility, consistency requirements, and scaling needs.

How does it help with query performance?

It provides patterns for indexing, explains how to use tools like EXPLAIN ANALYZE in PostgreSQL, and offers scripts to identify and resolve slow queries.

Database Architect & Administrator

Name: Database Architect & Administrator
Author: CongDon1207

byCongDon1207

•

Database Management

Simplifies database management by providing expert guidance for MongoDB and PostgreSQL schema design, query optimization, and production administration.

About

The Databases skill equips Claude with specialized knowledge for working across both document-oriented (MongoDB) and relational (PostgreSQL) database systems. It serves as an intelligent assistant for choosing the right data model, writing complex aggregation pipelines or SQL joins, and optimizing query performance through strategic indexing. Whether you are performing database migrations, setting up replication, or managing production-level security and backups, this skill provides the implementation patterns and best practices needed to ensure data integrity and system scalability.

Key Features

Schema design and data modeling best practices
Database administration, migration, and backup strategies
Performance optimization and slow query analysis
Advanced query and aggregation pipeline generation
Cross-platform support for MongoDB and PostgreSQL
1 GitHub stars

Use Cases

Migrating a legacy SQL database to a flexible MongoDB document model
Optimizing PostgreSQL query performance using EXPLAIN and strategic indexing
Designing highly available database clusters with replication and sharding

About

Key Features

Schema design and data modeling best practices
Database administration, migration, and backup strategies
Performance optimization and slow query analysis
Advanced query and aggregation pipeline generation
Cross-platform support for MongoDB and PostgreSQL
1 GitHub stars

Use Cases

Migrating a legacy SQL database to a flexible MongoDB document model
Optimizing PostgreSQL query performance using EXPLAIN and strategic indexing
Designing highly available database clusters with replication and sharding