skills.rest
danielprats
danielpratsCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/danielprats/01_03_VIMEP --skill cleancarto
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
matheusz-niedmatheusz-nied

database

Create and manage PostgreSQL databases with safe SQL queries across environments.

Community
Advanced
agentuityagentuity
1

agentuity-cli-cloud-storage-upload

Upload local files to cloud storage buckets with custom keys and content types.

Official
Intermediate
AradotsoAradotso
5

harvard-artifacts-data-pipeline

Automate Harvard Art Museums data pipelines with ETL, SQL, and visualizations.

Official
Advanced
thbehthbeh

databricks-genie

Create and query Databricks Genie Spaces for natural language SQL exploration.

Community
Advanced