Marcopolo MCP Integration for AI Agents

Run a shell command in the persistent /workspace runtime. Use for all agent-side work: query authoring, analytics, DuckDB joins, workspace files, scripts, git, diagnostics, and cron. The `connection` and `cron` CLIs exist only inside this runtime and must be invoked through this tool.

List visible Marcopolo connections and their provider authorization state. Use only entries with `queryable: true` for `data_query`. Entries with `authorization_state: "authorization_required"` need user authorization from Connections in Marcopolo; follow `next_actions`. Capabilities and workspace paths describe supported commands for authorized connections.

Run a bounded governed query against a visible connection. Use this tool in generated code that re-queries live data at view or load time: Remote Artifacts, external web apps, scheduled scripts, and any other programmatic interface that fetches fresh data on each run. Do NOT use it for agent-side analytics or one-off snapshot visualizations — use the `workspace_shell` tool with the connection query CLI instead. Pass the full workspace-relative `query_file` path including the connection prefix, e.g. `connections/<name>/queries/<file>`. Paths resolve from `/workspace`, not from any current directory. Author new query files through `workspace_shell` before calling this tool so query text is durable and reusable. Returns `rows` as a parsed list of record dicts and `row_count` as the total — no JSON parsing needed. Results are capped by `max_rows` (1–5000).

Create a browser setup URL for a credentialed connection. Use a canonical `type` when known; otherwise pass `intent_text`. For hosted demo data with no credentials, use `install_demo_connection`.

Install hosted demo data with no user credentials. Pass a demo id or natural-language request. Use `connection_setup` for real user-owned connections.