CARTO2Prod_man
CommunityLoad CARTO maintenance data to production
Authordanielprats
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automates the process of loading maintenance data from temporary CARTO tables into a unified production table, ensuring data consistency and reducing manual data handling.
Core Features & Use Cases
- Data Loading: Transfers maintenance records from CARTO to a central production database.
- Data Transformation: Applies SQL mapping to standardize data from various asset types into a single schema.
- Incremental Updates: Handles data updates by deleting existing records for a given period and inserting new ones.
- Use Case: Regularly update the
vimep_all_mantable with the latest maintenance records for traffic lights (SEM) from CARTO, ensuring the production database always reflects current information.
Quick Start
Use the CARTO2Prod_man skill to load SEM maintenance data for the 2510 period.
Dependency Matrix
Required Modules
requestspython-dotenv
Components
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: CARTO2Prod_man Download link: https://github.com/danielprats/01_03_VIMEP/archive/main.zip#carto2prod-man Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.