skills.rest
chef0111
chef0111COMMUNITY
Explore all skills by this author →
WebsiteGitHub

databases

Manage MongoDB and PostgreSQL databases with schema design, CRUD, indexing, and migrations.

1|Updated Feb 17, 2026
Search Tags:#database#postgresql#data management#sql#nosql#mongodb#querying
One-click install
npx skills add https://github.com/chef0111/physthink --skill databases-chef0111
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/chef0111/physthink/tree/main/.agents/skills/databases
Command: npx skills add https://github.com/chef0111/physthink --skill databases-chef0111

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a unified approach to working with both MongoDB (NoSQL document database) and PostgreSQL (SQL relational database), enabling users to choose the right tool for the job and perform essential database operations efficiently.

Core Features & Use Cases

  • Database Selection Guidance: Helps choose between MongoDB and PostgreSQL based on project needs (flexibility vs. consistency, scaling needs, data structure).
  • CRUD Operations: Demonstrates common Create, Read, Update, Delete operations for both databases.
  • Schema Design & Indexing: Provides guidance on designing schemas and optimizing performance with indexes.
  • Migration & Administration: Covers database migrations, user management, and backup strategies.
  • Use Case: A developer needs to decide whether to use MongoDB for a flexible user profile system or PostgreSQL for a transactional e-commerce order system, and then needs to know how to perform basic data operations in the chosen database.

Quick Start

Use the databases skill to connect to your PostgreSQL database and insert a new user record.

Frequently Asked Questions about databases

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
When should I use MongoDB vs PostgreSQL for my application data?▼

Choose MongoDB for flexible schemas and horizontal scaling, or PostgreSQL when you need strong data consistency and complex relational queries. This skill provides database selection guidance based on your project's specific data structure and scaling requirements.

How do I optimize SQL queries and create indexes in PostgreSQL?▼

You can optimize PostgreSQL queries by designing proper schemas and implementing indexing strategies. This skill provides guidance on query optimization and indexing techniques specifically for relational data models to improve database performance.

How do I perform CRUD operations and manage schemas in MongoDB?▼

You can perform Create, Read, Update, and Delete operations in MongoDB using the provided scripts. This skill covers document schema design and aggregation pipelines to help manage flexible NoSQL data structures effectively.

Can I manage database migrations and backups for both SQL and NoSQL databases?▼

Yes, you can handle database migrations, user management, and backup strategies for both PostgreSQL and MongoDB. This skill provides administration guidance covering both relational and document database maintenance tasks.

Does this database skill require any specific database drivers or dependencies to work?▼

No specific dependencies are required to use this skill. It provides comprehensive guidance, scripts, and references for managing both PostgreSQL and MongoDB databases directly without needing external drivers or plugins.

Related Skills

Explore More Software Engineering Skills→
etendosoftwareetendosoftware
1

/etendo:install

Install Etendo ERP by executing Gradle setup, database, and build tasks.

Official
Advanced
taishan1994taishan1994
30

query-writing

Write and run read-only SQL queries for relational data analysis.

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
AratKruglikAratKruglik
150

postgres-best-practices

Optimize PostgreSQL queries, schemas, and database configuration.

Community
Advanced