cleanCarto

Delete CARTO Data Warehouse INV and MAN tables with user confirmation.

Updated Aug 27, 2026

Search Tags:#database management #cleanup #etl #data warehouse #caro #table deletion

Ready to run

npx skills add https://github.com/danielprats/01_03_VIMEP --skill cleancarto

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: cleanCarto
Source: https://github.com/danielprats/01_03_VIMEP/tree/main/AssistentIA/_skills/cleanCarto
Command: npx skills add https://github.com/danielprats/01_03_VIMEP --skill cleancarto

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, python-dotenv, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill provides a secure and controlled way to remove inventory (INV) and maintenance (MAN) tables from the CARTO Data Warehouse, preventing accidental data loss.

Core Features & Use Cases

Selective Deletion: Choose to delete only INV tables, only MAN tables, or both.
Interactive Confirmation: Requires user confirmation before deletion, unless the --force flag is used for automation.
Use Case: Before uploading new monthly maintenance data, use this Skill to clear out the old *_MAN tables in CARTO, ensuring a clean slate for the updated information.

Quick Start

Use the cleanCarto skill to delete all inventory tables from CARTO.

Frequently Asked Questions about cleanCarto

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

FAQPage Schema

How do I safely delete inventory and maintenance tables from a CARTO Data Warehouse?▼

To safely delete inventory and maintenance tables from a CARTO Data Warehouse, use a controlled deletion process that targets specific INV or MAN tables. This requires explicit user confirmation before removing data, preventing accidental loss during warehouse cleanup.

Can I selectively delete only CARTO maintenance tables without removing inventory data?▼

Yes, you can selectively delete only CARTO maintenance tables. The deletion process supports filtering by table type, allowing you to remove MAN tables independently while keeping INV inventory tables completely untouched.

Do I need a CARTO SQL API key to automate table deletion?▼

Yes, you need a CARTO_SQL_API_KEY to automate table deletion. This key authorizes the SQL operations required to remove INV and MAN tables, and when combined with a force mode flag, bypasses interactive confirmation for automated workflows.

What is the best way to clear old CARTO tables before uploading new monthly data?▼

The best way to clear old CARTO tables before uploading new monthly data is to selectively delete the outdated MAN or INV tables. This ensures a clean slate in the data warehouse for updated information without risking existing unrelated datasets.

Does deleting CARTO tables require manual confirmation every time?▼

Deleting CARTO tables requires manual confirmation by default to prevent accidental data loss, but you can bypass this using a force mode flag. Force mode is designed for automation workflows where interactive confirmation is not possible.