How does it help with query performance?

The skill offers detailed instructions on analyzing slow queries using tools like EXPLAIN ANALYZE and recommends optimal indexing strategies to improve speed.

Does this skill support both SQL and NoSQL?

Yes, it provides specialized guidance and implementation patterns for both MongoDB (document-oriented) and PostgreSQL (relational) databases.

Is it suitable for production administration?

Yes, it covers production-critical tasks including backup and restore strategies, user permission management, and high-availability configurations like sharding.

Can this skill help with database migrations?

Absolutely. It includes best practices for implementing migrations and provides Python utilities for generating and applying changes to your schema.

Unified Database Management

Name: Unified Database Management
Author: GGPrompts

byGGPrompts

•

데이터베이스 관리

Manages both MongoDB and PostgreSQL environments, from schema design and query optimization to production administration and migrations.

This skill provides a comprehensive toolkit for working with document-oriented MongoDB and relational PostgreSQL databases within the Claude Code environment. It guides users through critical tasks such as data modeling, writing complex aggregation pipelines, optimizing SQL queries, and managing database migrations. Whether you are choosing between NoSQL and SQL architectures or troubleshooting performance bottlenecks in a production environment, this skill offers the specific patterns, scripts, and best practices needed to build and maintain robust, high-performance data layers.

주요 기능

01Schema design and data modeling for both SQL and NoSQL systems

02Comprehensive aggregation pipeline and complex SQL join management

03Configuration for replication, sharding, and clustering high-availability

04Advanced query optimization and performance analysis using EXPLAIN

05Automated migration scripts and backup/restore strategies

061 GitHub stars

사용 사례

01Evaluating and selecting the optimal database type for a new project architecture

02Refactoring slow queries and implementing effective indexing strategies for scale

03Managing database users, permissions, and migrations across environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ggprompts/my-plugins databases

For use in Claude.ai and ChatGPT

Download Skill