Can it help with cloud-hosted databases like MongoDB Atlas?

Absolutely. The skill includes specific guidance for MongoDB Atlas setup, cluster management, monitoring, and cloud-specific search features.

Can this skill generate database migration scripts?

Yes, it provides patterns and utility scripts for generating and applying migrations, ensuring safe schema evolution for both SQL and NoSQL environments.

How does the skill handle database performance issues?

It assists in analyzing slow queries, recommending optimal indexing strategies, and using diagnostic commands like EXPLAIN ANALYZE to identify bottlenecks.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive support for both PostgreSQL (relational) and MongoDB (document-oriented), covering the unique advantages and query languages of each.

Database Management & Design

Name: Database Management & Design
Author: Activer007

byActiver007

0•

Database Management

Manages, designs, and optimizes MongoDB and PostgreSQL databases through schema modeling, query generation, and performance tuning.

This skill provides a unified workflow for architecting and maintaining both relational (PostgreSQL) and document-oriented (MongoDB) database systems. It guides developers through the entire database lifecycle, from initial schema design and data modeling to writing complex aggregation pipelines and SQL joins. Beyond basic CRUD operations, it assists with high-level administrative tasks such as implementing migrations, configuring replication and sharding, managing user permissions, and diagnosing performance bottlenecks using advanced profiling tools. Whether you are building a transactional financial system or a flexible IoT data lake, this skill ensures best practices are followed for data integrity and scalability.

Key Features

01Automated migration scripts and backup/restore strategy implementation

02Performance optimization tools for indexing, EXPLAIN plans, and query profiling

03Advanced query generation for SQL, MQL, and complex aggregation pipelines

04Production administration guidance for replication, sharding, and Atlas cloud

05Unified support for MongoDB BSON documents and PostgreSQL relational schemas

060 GitHub stars

Use Cases

01Building flexible content management systems using MongoDB's dynamic document structures

02Refactoring legacy database architectures to improve query speed and horizontal scalability

03Designing a high-performance e-commerce backend with ACID-compliant PostgreSQL transactions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills databases

For use in Claude.ai and ChatGPT

Download Skill