carto-query-datawarehouse

Run SQL — spatial or otherwise — against any connection CARTO has registered. The CLI exposes two surfaces:

• carto sql query — SELECT queries that return rows. Has a 1-minute timeout. Optional client-side caching.
• carto sql job — DDL/DML jobs (CREATE TABLE AS SELECT, UPDATE, INSERT). No timeout; polls until done; returns no rows.

Plus a sibling for usage analytics:

• carto activity query — DuckDB-backed SQL over downloaded CARTO activity data. Local execution, separate from warehouse SQL.

When to use this skill

• The user wants to count rows, run an exploratory SELECT, or build a transformation.
• The user is debugging slow / failing SQL.
• The agent needs to materialize an intermediate table before authoring a map.
• The user wants to run an ad-hoc spatial join, buffer, or H3 aggregation.

Quick reference