carto-explore-datawarehouse

Before writing SQL or building maps, an agent usually needs to know what's in the warehouse. This skill covers discovery, matched across MCP and CLI:

Task	MCP (primary)	CLI (fallback)
List / inspect connections	`explore_data` (`list_connections`, `get_connection`)	`carto connections list` / `get`
Walk the hierarchy (project → dataset → table)	`explore_data` (`list_resources`)	`carto connections browse`
Full-text find a resource	`explore_data` (`search`)	—
Columns + types for a table	`explore_data` (`describe`)	`carto connections describe`
Find / inspect a named source	`manage_named_sources` (`list`, `get`)	`carto named-sources list` / `get`

Access-path routing. explore_data works on any attached MCP session, but not all its methods do on a token: list_connections, list_resources, and search need only the MCP Server scope, while describe additionally needs the Maps API on a token session (it's always available over OAuth). manage_named_sources is an authoring tool, so it needs an OAuth session (it's hidden on token sessions). Use the carto connections / carto named-sources CLI when the server isn't attached, when a token lacks the scope for describe, or when the exploration is scripted/headless. Detection signals and the full routing table: carto-basics/references/access-paths.md.

When to use this skill

You don't know which tables / schemas exist in a connection.
You need a column list and types before writing SQL or authoring a map.
The user references "the named source for X" and you need to find it.