Can I use this skill to optimize slow queries?

Absolutely. It includes guidance on using EXPLAIN ANALYZE for PostgreSQL and performance check scripts for MongoDB to identify and fix bottlenecks.

How do I choose between MongoDB and PostgreSQL using this skill?

The skill includes a detailed Database Selection Guide that compares factors like schema flexibility, ACID compliance, and scaling requirements to help you make the right architectural choice.

Does it include tools for database maintenance?

Yes, the skill features Python utility scripts for generating migrations, performing backups, and analyzing query performance thresholds.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive support for both PostgreSQL (relational/SQL) and MongoDB (document-oriented/NoSQL), including syntax for both systems.

Database Management & Operations

Name: Database Management & Operations
Author: hongbietcode

byhongbietcode

•

데이터베이스 관리

Streamlines database schema design, query optimization, and administration for both MongoDB and PostgreSQL environments.

This skill provides a unified framework for mastering both document-oriented and relational databases, specifically MongoDB and PostgreSQL. It empowers developers to design efficient data models, write complex SQL queries or aggregation pipelines, and manage production-level tasks like migrations, backups, and performance tuning. By offering side-by-side comparisons and specialized Python utilities, it helps users choose the right architecture for their specific use case while ensuring best practices in security, indexing, and scalability are always followed.

주요 기능

01Performance diagnostics and index optimization guidance

02Automated migration and backup scripts via Python utilities

03Production-ready administration for replication and sharding

04Comprehensive aggregation pipeline and complex join construction

052 GitHub stars

06Dual support for MongoDB (NoSQL) and PostgreSQL (Relational) systems

사용 사례

01Optimizing slow-running production queries and improving indexing strategies

02Designing and implementing scalable schemas for new application backends

03Managing cross-database migrations and automated disaster recovery workflows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hongbietcode/synthetic-claude databases

For use in Claude.ai and ChatGPT

Download Skill