Design, query, and optimize MongoDB and PostgreSQL databases for scalable schemas.
npx skills add https://github.com/jackspace/ClaudeSkillz --skill databases-jackspace
Please help me install this Agent Skill. Skill: databases Source: https://github.com/jackspace/ClaudeSkillz/tree/main/skills/databases_mrgoonie Command: npx skills add https://github.com/jackspace/ClaudeSkillz --skill databases-jackspace
This Skill provides a unified guide to MongoDB (document model) and PostgreSQL (SQL) with practical CRUD examples, indexing strategies, and migration tips.
Run sample Mongo/SQL commands to create a users table/collection and perform basic CRUD.
High-intent search queries and answers about installing and using this skill.
MongoDB suits document-based, flexible schemas with horizontal scaling; PostgreSQL excels at relational data with ACID transactions and complex queries. Choose MongoDB for unstructured or rapidly evolving data, PostgreSQL for structured data requiring strict consistency and complex joins.
Indexing strategies differ by database: MongoDB uses field-level indexes and compound indexes for aggregation pipelines; PostgreSQL uses B-tree, hash, and specialized indexes for query optimization. Both require analyzing query patterns and avoiding over-indexing to balance read speed against write overhead.
Migration involves schema mapping, data transformation, and validation. MongoDB's document structure maps to PostgreSQL tables through denormalization or normalization depending on relational requirements. Use migration tooling to handle BSON serialization, handle type conversions, and verify data integrity post-transfer.
MongoDB aggregation pipelines chain stages ($match, $group, $project) to transform documents; PostgreSQL uses SQL with GROUP BY, joins, and window functions. Both support filtering, grouping, and computed fields; choose based on your data model and query complexity.
No. MongoDB uses replica sets and Atlas backup; PostgreSQL uses WAL-based replication and pg_dump. Backup frequency, retention, and failover mechanisms differ. Plan database-specific recovery procedures aligned with your RPO and RTO requirements.
Both require authentication (SCRAM, certificates), encryption in transit and at rest, role-based access control, and audit logging. MongoDB Atlas and PostgreSQL pgAdmin provide native security features; configure least-privilege roles and monitor for unauthorized access.
ariesanhthuAnalyze EXPLAIN plans and optimize queries for PostgreSQL, MySQL, MongoDB, and SQLite.
constellizeMonitor databases, caches, APIs, and file systems with parallel health checks.
pingqLINGuide MongoDB 7.x+ cluster management, backup, performance tuning, and security.
roanbrasilSelect NoSQL databases and design schemas for access patterns.
