skills.rest
JoseMas68
JoseMas68COMMUNITY
Explore all skills by this author →
GitHub

ck:databases

Design and manage MongoDB and PostgreSQL database schemas with Python utilities.

Updated Aug 23, 2026
Search Tags:#performance#database#postgresql#schema#migration#backup#mongodb
One-click install
npx skills add https://github.com/JoseMas68/CRMDev --skill ck-databases
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:databases
Source: https://github.com/JoseMas68/CRMDev/tree/main/.claude/skills/databases
Command: npx skills add https://github.com/JoseMas68/CRMDev --skill ck-databases

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Managing and designing schemas, queries, migrations, and performance for MongoDB and PostgreSQL is complex and error‑prone, especially across OLTP and OLAP use cases.

Core Features & Use Cases

  • Unified Guidance: Provides best‑practice rules for schema design, indexing, and security for both MongoDB and PostgreSQL.
  • Operational Scripts: Includes Python utilities for backup/restore, migrations, and performance checks.
  • Reference Library: Detailed markdown references covering CRUD, aggregation, indexing, ETL, and platform‑specific rules.
  • Use Case Example: Quickly create a fact table for analytics or a transactional user table, generate migrations, and run performance diagnostics with a single command.

Quick Start

Use the databases skill to design a PostgreSQL users table with appropriate indexes and generate the migration script.

Frequently Asked Questions about ck:databases

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

FAQPage Schema
How do I design and optimize PostgreSQL schemas for OLTP and OLAP use cases?▼

To design and optimize PostgreSQL schemas, you apply best-practice rules for indexing and structure. This skill provides reference files and Python utilities to generate transactional user tables or analytics fact tables, along with migration scripts.

What is the best way to manage MongoDB schema migrations and performance?▼

Managing MongoDB schema migrations and performance involves using targeted Python utilities for backups and checks. This skill provides operational scripts and detailed markdown references covering aggregation, indexing, and CRUD operations to streamline database management.

Can I use Python to automate database backups and performance checks for MongoDB and PostgreSQL?▼

Yes, you can use Python to automate database backups and performance checks for MongoDB and PostgreSQL. This skill includes Python utilities built on pymongo and psycopg2 to execute backup, restore, migration, and performance diagnostics.

Does this database optimization approach support both transactional and analytics structures?▼

Yes, this approach supports both transactional and analytics structures. It provides unified guidance and reference materials to help developers, data engineers, and analysts design appropriate schemas for both OLTP and OLAP environments.

How do I generate a migration script for a new PostgreSQL table with appropriate indexes?▼

To generate a migration script for a new PostgreSQL table with appropriate indexes, you use the skill's Python utilities. It allows you to quickly define a transactional table, apply indexing rules, and output the migration script in a single command.

Related Skills

Explore More Software Engineering Skills→
VuNguyenVietTienVuNguyenVietTien

databases

Design database schemas, optimize queries, and plan migrations for MongoDB and PostgreSQL.

Community
Intermediate
claudcherejiclaudchereji

data-engineer

Design and implement scalable ETL/ELT pipelines for batch and streaming data.

Community
Advanced
evanfang0054evanfang0054

requesting-code-review

Automate code review requests with detailed context for reviewers.

Community
Advanced
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced