skills.rest
flosrn
flosrnCOMMUNITY
Explore all skills by this author →
𝕏@flo_srnGitHub

databases

Guide PostgreSQL and MongoDB schema design, query optimization, and performance tuning.

Updated Aug 6, 2025
Search Tags:#performance#database#migration#sql#query#mongodb#postgres
One-click install
npx skills add https://github.com/flosrn/.claude --skill databases-flosrn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/flosrn/.claude/tree/main/skills/databases
Command: npx skills add https://github.com/flosrn/.claude --skill databases-flosrn

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies working with both relational (PostgreSQL) and document (MongoDB) databases, helping you choose the right tool and optimize performance.

Core Features & Use Cases

  • Database Selection: Guides you on when to use MongoDB vs. PostgreSQL based on project needs.
  • Querying & Operations: Provides examples for common CRUD operations, indexing, and aggregation.
  • Performance Tuning: Offers insights into optimizing queries and schema design.
  • Use Case: You need to decide whether to use a relational or document database for a new project, or you need to write an efficient query for either PostgreSQL or MongoDB.

Quick Start

Use the databases skill to get started with connecting to PostgreSQL.

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 a new project?▼

Choose MongoDB for flexible document schemas or PostgreSQL when you need relational data integrity. This database selection guidance helps you match your project requirements to the right database architecture.

How do I optimize slow PostgreSQL queries?▼

Optimize slow PostgreSQL queries by applying indexing strategies and schema design best practices. This Skill provides performance tuning guidance to improve query execution plans and database response times.

What are the best indexing strategies for MongoDB?▼

MongoDB indexing strategies involve creating targeted indexes to support common query patterns and aggregations. This Skill covers indexing operations that reduce document scan overhead and improve read performance.

How do I perform common CRUD operations in PostgreSQL and MongoDB?▼

Common CRUD operations in PostgreSQL and MongoDB require specific syntax for each database system. This Skill provides query examples for creating, reading, updating, and deleting records in both relational and document stores.

Does this database Skill cover schema design for both relational and document databases?▼

Yes, schema design guidance covers both relational PostgreSQL tables and MongoDB document structures. You receive best practices for structuring data models that support efficient queries and application scaling requirements.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
sigmadigitalzasigmadigitalza
1

database-review

Review database schemas, migration files, and query performance.

Official
Advanced
CJ-1981CJ-1981

moai-domain-database

Design and optimize PostgreSQL, MongoDB, Redis, and Oracle database schemas and queries.

Community
Advanced
rnavarychrnavarych
14

role-database:relational-databases

Configure, tune, and troubleshoot 20 relational SQL database engines.

Community
Advanced