AI SummaryUnified guide for working with MongoDB (document-oriented) and PostgreSQL (relational) databases. Choose the right database for your use case and master both systems. Database utility scripts in :
Install
Copy this and paste it into Claude Code, Cursor, or any AI assistant:
I want to install the "databases" skill in my project. Please run this command in my terminal: # Install skill into your project (2 files) mkdir -p .claude/skills/databases-thucpru-fontkit && curl --retry 3 --retry-delay 2 --retry-all-errors -o .claude/skills/databases-thucpru-fontkit/SKILL.md "https://raw.githubusercontent.com/majiayu000/claude-skill-registry/main/skills/data/databases-thucpru-fontkit/SKILL.md" && curl --retry 3 --retry-delay 2 --retry-all-errors -o .claude/skills/databases-thucpru-fontkit/metadata.json "https://raw.githubusercontent.com/majiayu000/claude-skill-registry/main/skills/data/databases-thucpru-fontkit/metadata.json" Then restart Claude Code (or reload the window in Cursor) so the skill is picked up.
Description
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.
Databases Skill
Unified guide for working with MongoDB (document-oriented) and PostgreSQL (relational) databases. Choose the right database for your use case and master both systems.
When to Use This Skill
Use when: • Designing database schemas and data models • Writing queries (SQL or MongoDB query language) • Building aggregation pipelines or complex joins • Optimizing indexes and query performance • Implementing database migrations • Setting up replication, sharding, or clustering • Configuring backups and disaster recovery • Managing database users and permissions • Analyzing slow queries and performance issues • Administering production database deployments
Choose MongoDB When:
• Schema flexibility: frequent structure changes, heterogeneous data • Document-centric: natural JSON/BSON data model • Horizontal scaling: need to shard across multiple servers • High write throughput: IoT, logging, real-time analytics • Nested/hierarchical data: embedded documents preferred • Rapid prototyping: schema evolution without migrations Best for: Content management, catalogs, IoT time series, real-time analytics, mobile apps, user profiles
Choose PostgreSQL When:
• Strong consistency: ACID transactions critical • Complex relationships: many-to-many joins, referential integrity • SQL requirement: team expertise, reporting tools, BI systems • Data integrity: strict schema validation, constraints • Mature ecosystem: extensive tooling, extensions • Complex queries: window functions, CTEs, analytical workloads Best for: Financial systems, e-commerce transactions, ERP, CRM, data warehousing, analytics
Discussion
Health Signals
My Fox Den
Community Rating
Sign in to rate this booster