Optimizes database performance and schema design for both PostgreSQL and MongoDB environments.
This skill provides a comprehensive toolkit for managing database lifecycles, specializing in both PostgreSQL and MongoDB. It guides developers through selecting the right database architecture, designing robust schemas, writing efficient queries, and optimizing performance through indexing and aggregation pipelines. Whether you are performing complex SQL joins, building MongoDB aggregation stages, or managing database migrations via Python scripts, this skill ensures best practices are followed for data integrity, consistency, and horizontal scalability.
Key Features
01Automated migration and backup utility scripts in Python
02Comprehensive schema design and data modeling guidance for scalability
03Unified patterns for PostgreSQL (relational) and MongoDB (document) systems
04Detailed indexing strategies including B-tree, GIN, and compound indexes
05Advanced query optimization and performance analysis using EXPLAIN
060 GitHub stars
Use Cases
01Optimizing slow-performing SQL queries or complex MongoDB aggregation pipelines
02Designing scalable data models for e-commerce, IoT, or financial applications
03Managing database migrations and disaster recovery workflows across dev and prod
