Is there a guide for choosing between MongoDB and PostgreSQL?

Yes, the skill includes a comparison guide to help you select the right database based on schema flexibility, consistency, and scaling needs.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive support and best practices for both PostgreSQL (Relational) and MongoDB (Document) systems.

Can this skill help with database performance tuning?

Absolutely, it includes detailed guidance on query analysis using EXPLAIN, indexing strategies, and performance-checking scripts.

Does it include automation scripts for maintenance?

Yes, it features Python utilities for generating migrations, performing backups, and analyzing slow queries.

Database Architect & Manager

Name: Database Architect & Manager
Author: Microck

byMicrock

•

Database Management

Streamlines database design, query optimization, and administrative tasks for both MongoDB and PostgreSQL environments.

This skill empowers Claude to act as a database specialist for both relational (PostgreSQL) and document-oriented (MongoDB) systems. It provides a unified framework for architecting schemas, writing complex SQL or aggregation pipelines, and performing critical DevOps tasks like migrations, backups, and performance tuning. Whether you are choosing the right data model for a new project or optimizing slow queries in a production environment, this skill provides domain-specific best practices and implementation patterns needed for robust data management.

Key Features

01Comprehensive administration guides for users, permissions, and sharding

02Automated migration and backup utilities via integrated Python scripts

0381 GitHub stars

04Dual-support for PostgreSQL relational modeling and MongoDB document design

05Advanced query construction including SQL JOINs and MongoDB aggregation pipelines

06Performance optimization through query analysis and indexing strategies

Use Cases

01Troubleshooting and optimizing slow-running production queries

02Architecting scalable data models for new applications

03Executing secure database migrations and backup strategies

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