Does it support cloud databases like MongoDB Atlas?

Absolutely. It provides specific guidance for connecting to and managing MongoDB Atlas clusters as well as local PostgreSQL installations.

Can this skill help me choose between SQL and NoSQL?

Yes, it includes a detailed selection guide comparing MongoDB and PostgreSQL based on schema flexibility, consistency needs, and scaling requirements.

Does it provide performance tuning advice?

It includes deep dives into indexing strategies, query analysis using EXPLAIN/EXPLAIN ANALYZE, and optimization patterns for document and relational models.

Can I use it for database migrations?

Yes, the skill covers migration strategies, schema evolution, and includes reference utilities for automating database changes across both systems.

Unified Database Management

Name: Unified Database Management
Author: mrgoonie

bymrgoonie

•

1,395

•

Database Management

Master document-oriented and relational databases by designing schemas, writing optimized queries, and managing migrations for MongoDB and PostgreSQL.

This skill empowers Claude to act as an expert database administrator and architect, providing a comprehensive guide for both MongoDB and PostgreSQL. It streamlines the transition between NoSQL and SQL paradigms, offering deep expertise in schema design, complex aggregation pipelines, indexing strategies, and production-level administration. Whether you are building a flexible real-time application with MongoDB or a high-integrity financial system with PostgreSQL, this skill provides the implementation patterns and CLI knowledge needed to build robust, scalable data layers.

Key Features

011,395 GitHub stars

02Database migration and schema versioning support

03Cross-platform expertise in MongoDB and PostgreSQL

04Complex query and aggregation pipeline construction

05Production administration and backup automation

06Performance optimization and indexing strategies

Use Cases

01Optimizing slow-running queries and resolving performance bottlenecks

02Managing database migrations and infrastructure scaling

03Architecting data models for both SQL and NoSQL requirements

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mrgoonie/claudekit-skills databases

For use in Claude.ai and ChatGPT

Download Skill