Building a Data Stack Live with AI AgentsLivestream August 18

Skip to main content

list_flights

Preview
This feature is in preview and is subject to change.

List Flights the caller can see: Users can see Flights they have created. Admins can see Flights they own as well as any Flight in the organization. Each Flight in the response includes its UUID, name, schedule, status, current version, and owner. Optionally filter by keywords matching the Flight name.

Description​

The list_flights tool returns Flight summary metadata, not version-specific content. Use get_flight with the returned flight_id to fetch source code, requirements, and config.

The corresponding SQL function is MD_LIST_FLIGHTS.

Input parameters​

ParameterTypeRequiredDescription
keywordsstringNoKeywords to filter Flights by name (case-insensitive, all words must match).
owner_onlybooleanNoRestrict the listing to Flights you own. Meaningful for Admins, who see the whole organization's Flights by default; ignored for other users.
limitintegerNoMax results to return (default: 50, max: 50).
offsetintegerNoNumber of Flights to skip, for paging through results.

Output schema​

{
  "success": boolean,
  "flights": [
    {
      "flight_id": string,             // Flight UUID
      "flight_name": string,
      "created_at": string,            // ISO 8601
      "updated_at": string,            // ISO 8601
      "schedule_cron": string|null,    // Cron expression or null for on-demand
      "status": string,                // Flight status, for example ACTIVE
      "schedule_status": string|null,  // Schedule status, for example ACTIVE
      "current_version": number,
      "owner_name": string|null        // The user who owns the Flight
    }
  ],
  "count": number,
  "totalCount": number,
  "truncated": boolean,                // Present when results were capped
  "message": string,                   // Present when results were capped
  "error": string                      // On failure
}

Example usage​

What Flights do I have?

The assistant calls the tool with no arguments. To filter:

{ "keywords": "metrics" }

An Admin sees the whole organization's Flights by default, with owner_name identifying whose each one is. To view your own Flights, use the following to filter results:

{ "owner_only": true }