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.

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

01Schema design and data modeling best practices

02Database administration, migration, and backup strategies

03Performance optimization and slow query analysis

04Advanced query and aggregation pipeline generation

05Cross-platform support for MongoDB and PostgreSQL

061 GitHub stars

Use Cases

01Migrating a legacy SQL database to a flexible MongoDB document model

02Optimizing PostgreSQL query performance using EXPLAIN and strategic indexing

03Designing highly available database clusters with replication and sharding

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add congdon1207/agents.md databases

For use in Claude.ai and ChatGPT

Download Skill