Can I use this for production database performance tuning?

Absolutely. It includes specific patterns for analyzing slow queries using EXPLAIN ANALYZE for Postgres and profiling for MongoDB to recommend index optimizations.

Does it help with database migrations?

Yes, the skill includes Python utilities and best practices for generating, applying, and managing schema evolutions and data migrations for both platforms.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive tools, syntax guides, and best practices for both PostgreSQL (Relational/SQL) and MongoDB (Document/NoSQL).

How do I know which database to choose for my project?

The skill includes a built-in selection guide that compares MongoDB and PostgreSQL across features like scaling, consistency, and data structure to help you make an informed decision.

Database Architect & Management

Name: Database Architect & Management
Author: Microck

byMicrock

•

Database Management

Manage and optimize both MongoDB and PostgreSQL environments, from schema design and complex querying to performance tuning and production administration.

This skill provides a unified workflow for handling the world's most popular document and relational databases within Claude. Whether you are building a flexible NoSQL backend with MongoDB Atlas or a robust ACID-compliant system with PostgreSQL, this skill offers specialized guidance on data modeling, migration strategies, and performance optimization. It bridges the gap between different database paradigms, helping developers select the right tool for their use case and execute production-grade operations like sharding, replication, and complex query analysis.

Key Features

01Performance tuning with EXPLAIN ANALYZE and index optimization

0281 GitHub stars

03Advanced aggregation pipeline and complex join optimization

04Cross-platform support for MongoDB (BSON) and PostgreSQL (SQL)

05Production-ready administration including backups and sharding

06Automated database migration and schema evolution strategies

Use Cases

01Designing and implementing scalable multi-tenant database schemas

02Optimizing slow-running queries and implementing indexing strategies

03Migrating data and managing infrastructure for production 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