skills.rest
skinred78
skinred78COMMUNITY
Explore all skills by this author →
GitHub

databases

Design schemas, write queries, and administer MongoDB and PostgreSQL databases.

1|Updated Oct 27, 2025
Search Tags:#indexing#postgresql#migrations#mongodb#databases#backups
One-click install
npx skills add https://github.com/skinred78/neuro-db-2 --skill databases-skinred78
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/skinred78/neuro-db-2/tree/main/.claude/skills/databases
Command: npx skills add https://github.com/skinred78/neuro-db-2 --skill databases-skinred78

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a unified guide for MongoDB (document) and PostgreSQL (relational) databases, covering schemas, queries, indexing, migrations, replication, backups, and security.

Core Features & Use Cases

  • Database Selection: Choosing MongoDB vs PostgreSQL based on workload
  • Queries & Indexing: SQL and MongoDB queries, aggregations, and indexing strategies
  • Migrations & Backups: Schema migrations, replication, and disaster recovery
  • Security & Administration: Users, permissions, and access controls

Quick Start

Create a MongoDB Atlas cluster and a PostgreSQL database, then connect to both from your app for hybrid workloads.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I choose between MongoDB and PostgreSQL for my application?▼

MongoDB suits document-oriented, flexible schemas with horizontal scaling; PostgreSQL excels at relational data with ACID guarantees and complex queries. Selection depends on your data structure, consistency requirements, and scaling strategy.

What's the best way to design schemas for MongoDB and PostgreSQL?▼

Schema design differs by database: PostgreSQL requires normalized relational structures with foreign keys; MongoDB uses denormalized, document-based schemas. Model your data to match query patterns and access frequency in each system.

How do I optimize database queries and indexing strategies?▼

Indexing accelerates queries by reducing full-table scans. Create indexes on frequently filtered or sorted columns; monitor query performance to identify bottlenecks. Both MongoDB and PostgreSQL support compound and partial indexes for targeted optimization.

How do I migrate schemas and data between databases?▼

Schema migrations involve altering table structures or document schemas while preserving data integrity. Plan migrations in phases, validate data mapping, test rollback procedures, and minimize downtime through staged deployments and replication.

What's the best approach to backing up and recovering databases?▼

Implement automated backups using native tools—PostgreSQL's pg_dump and MongoDB's mongodump—combined with replication for redundancy. Test recovery procedures regularly to ensure disaster recovery meets your RPO and RTO requirements.

How do I configure replication and sharding for production databases?▼

Replication creates read replicas for failover and load distribution; sharding partitions data across nodes for horizontal scaling. PostgreSQL uses streaming replication; MongoDB uses replica sets and sharded clusters. Configure based on data volume and availability needs.

Related Skills

Explore More Data & Analytics Skills→
outfitter-devoutfitter-dev
28

claude-code-configuration

Manage Claude configuration files for MCP servers and environment variables.

Official
Intermediate
ovachieverovachiever
52

weights-and-biases

Automate ML experiment tracking and model registry management via the wandb API.

Community
Advanced
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate
tranhieutttranhieutt
70

nosql-expert

Design query-first Cassandra and DynamoDB schemas with partition key strategies.

Community
Advanced