Can it help me choose between SQL and NoSQL?

Yes, it includes a detailed selection guide comparing schema flexibility, consistency models, and scaling requirements to help you choose the right database for your use case.

Can I use this for database migrations?

Yes, the skill provides Python utilities and conceptual guides for generating and applying migrations across different database environments.

Does this skill provide help with performance tuning?

Absolutely. It offers patterns for index creation, query analysis using EXPLAIN, and best practices for optimizing slow-running database operations.

Which databases does this skill support?

This skill is specifically optimized for MongoDB (document-oriented) and PostgreSQL (relational), providing specialized guidance for both.

Does it support cloud-managed services like MongoDB Atlas?

Yes, it includes specific references and setup guides for MongoDB Atlas cloud, as well as local installations of PostgreSQL.

Database Schema & Query Expert

Name: Database Schema & Query Expert
Author: Activer007

byActiver007

0•

Database Management

Manages and optimizes MongoDB and PostgreSQL databases through expert schema design, query generation, and administration patterns.

This skill provides a unified framework for working with both document-oriented (MongoDB) and relational (PostgreSQL) databases, enabling developers to architect robust data layers with ease. It offers domain-specific guidance for designing schemas, writing complex aggregation pipelines, optimizing indexes for performance, and managing production environments. Whether you are building real-time analytics with MongoDB or complex transactional systems with PostgreSQL, this skill provides the necessary patterns for migrations, backups, and high-availability configurations to ensure your data remains secure and performant.

Key Features

01Expert schema design for relational and document-based data models

02Optimized SQL and MongoDB Query Language (MQL) generation

03Comprehensive migration, backup, and disaster recovery strategies

040 GitHub stars

05Advanced performance tuning via index optimization and EXPLAIN analysis

06Production administration patterns for sharding, replication, and security

Use Cases

01Implementing strict ACID-compliant relational models for financial transactions

02Optimizing slow-running production queries and complex aggregation pipelines

03Designing flexible NoSQL schemas for rapid prototyping and hierarchical data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills databases

For use in Claude.ai and ChatGPT

Download Skill