skills.rest
rafaelcalleja
rafaelcallejaCOMMUNITY
Explore all skills by this author →
GitHub

databases

Manage PostgreSQL and MongoDB schema design, queries, and administration.

2|1|Updated Oct 11, 2025
Search Tags:#SQL#performance optimization#PostgreSQL#MongoDB#data migration#databases#database administration
One-click install
npx skills add https://github.com/rafaelcalleja/claude-market-place --skill databases-rafaelcalleja
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/rafaelcalleja/claude-market-place/tree/main/plugins/claudekit-skills/skills/databases
Command: npx skills add https://github.com/rafaelcalleja/claude-market-place --skill databases-rafaelcalleja

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2-binary, pymongo, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Managing and optimizing database systems like PostgreSQL and MongoDB requires specialized knowledge and tools, which can be complex to master. This skill provides comprehensive support, simplifying database operations.

Core Features & Use Cases

  • PostgreSQL Management: Tools for administration, query optimization, and CLI interaction.
  • MongoDB Operations: Support for CRUD, aggregation, indexing, and Atlas integration.
  • Database Backup & Migration: Automate backup, restore, and schema migration processes, ensuring data safety.
  • Performance Monitoring: Scripts to check and optimize database performance, identifying bottlenecks.
  • Use Case: Migrate a PostgreSQL database schema to a new version, then perform a performance check to ensure query efficiency is maintained.

Quick Start

Use the databases skill to back up my PostgreSQL database named 'production_db'.

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize PostgreSQL query performance?▼

Query performance optimization in PostgreSQL involves analyzing execution plans, creating appropriate indexes, and tuning configuration parameters. This skill provides scripts and strategies to identify bottlenecks, benchmark queries, and apply indexing strategies that reduce execution time and resource consumption.

Can I migrate a PostgreSQL database schema to a new version?▼

Yes, schema migration automates the process of updating PostgreSQL database structures between versions. This skill automates migration scripts, handles data transformation, validates schema consistency, and ensures query efficiency is maintained throughout the transition.

What's the best way to back up and restore PostgreSQL and MongoDB databases?▼

Automated backup and restore processes protect data across both PostgreSQL and MongoDB by scheduling regular exports, storing snapshots securely, and enabling rapid recovery. This skill provides CLI tools and scripts to automate these workflows and ensure data safety.

How do I build MongoDB aggregation pipelines and optimize indexing?▼

MongoDB aggregation pipelines transform and analyze documents through stages like match, group, and sort. Indexing strategies accelerate these operations by organizing data efficiently. This skill covers pipeline construction, index design, and performance tuning for complex MongoDB queries.

Does this skill support MongoDB Atlas integration?▼

Yes, this skill includes support for MongoDB Atlas integration, enabling cloud-based database management, monitoring, and operations alongside local MongoDB instances and PostgreSQL environments.

What database replication and sharding strategies does this cover?▼

Replication and sharding distribute data across multiple servers for high availability and scalability. This skill addresses replication setup, shard key selection, failover handling, and production monitoring across PostgreSQL and MongoDB clusters.

Related Skills

Explore More Data & Analytics Skills→
zircotezircote
26

databases

Design and manage MongoDB and PostgreSQL databases with schema modeling, queries, and migrations.

Community
Advanced
saeed-vayghansaeed-vayghan
30

database-administrator

Administer PostgreSQL, MySQL, MongoDB, and Redis for high availability and performance.

Community
Advanced
HieubkavHieubkav

database-backup

Automate pre-migration database backups with Spatie Laravel Backup.

Community
Basic
besoeasybesoeasy
128

database-query-and-export

Query SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.

Community
Intermediate