Does this skill support both SQL and NoSQL databases?

Yes, it provides dedicated support and best practices for both PostgreSQL (relational) and MongoDB (document-oriented) database systems.

Is there support for cloud-hosted databases?

Yes, it specifically covers MongoDB Atlas setup and provides general guidance for cloud-managed PostgreSQL instances and deployments.

Can it help with database migrations?

Absolutely, it includes implementation patterns for schema evolution and dedicated scripts for generating and applying migrations.

How does it help with performance issues?

The skill offers guidance on using EXPLAIN plans, optimizing B-tree and compound indexes, and analyzing slow queries to improve application response times.

Can I use it for database administration tasks?

Yes, it includes references for user permission management, backup/restore strategies, and replication setup for production environments.

Databases (MongoDB & PostgreSQL)

Name: Databases (MongoDB & PostgreSQL)
Author: Microck

byMicrock

•

Database Management

Manages both relational and document-oriented databases with expert guidance on schema design, query optimization, and production administration.

The Databases skill provides a comprehensive toolkit for working with PostgreSQL and MongoDB, bridging the gap between relational and document-based architectures. It assists in everything from initial schema modeling and complex query construction to high-level production tasks like sharding, replication, and performance tuning. Whether you are building ACID-compliant financial systems or flexible IoT data stores, this skill provides the patterns, scripts, and best practices needed to ensure data integrity and scalability across diverse database environments.

Key Features

01Production administration guides for backups, replication, and security

0281 GitHub stars

03Performance optimization including index management and query analysis

04Database migration and schema evolution strategies

05Unified support for MongoDB (BSON) and PostgreSQL (SQL)

06Advanced query generation for aggregation pipelines and complex joins

Use Cases

01Designing multi-tenant SaaS databases with strict referential integrity

02Implementing automated backup and recovery workflows for production environments

03Optimizing slow-running queries in high-traffic MongoDB Atlas clusters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills databases

For use in Claude.ai and ChatGPT

Download Skill