MD_LIST_FLIGHTS

Preview

This feature is in preview and is subject to change.

Returns the summary metadata for every Flight 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. Use the optional LIMIT and OFFSET parameters to page through large result sets.

Syntax

SELECT * FROM MD_LIST_FLIGHTS(
    "LIMIT" := <n>,
    "OFFSET" := <n>,
    owner_only := <boolean>
);

Parameters

Parameter	Type	Required	Default	Description
LIMIT	UINTEGER	No	50	Maximum number of Flights to return.
OFFSET	UINTEGER	No	0	Skip this many Flights before returning.
owner_only	BOOLEAN	No	false	Return only the Flights you own. Meaningful for Admins, who otherwise see the whole organization; for other users the result is the same either way.

LIMIT and OFFSET collide with SQL keywords and must be quoted with double quotes when passed as named arguments.

Return columns

Column	Type	Description
flight_id	UUID	Flight identifier.
flight_name	VARCHAR	The Flight name.
schedule_cron	VARCHAR	Cron expression, or NULL for on-demand.
schedule_status	VARCHAR	Schedule state (for example, SCHEDULE_STATUS_ACTIVE or SCHEDULE_STATUS_DISABLED), or NULL when the Flight has no schedule.
status	VARCHAR	Flight status (for example, JOB_STATUS_ACTIVE). Not the schedule state — see schedule_status.
current_version	UINTEGER	Latest version number.
created_at	TIMESTAMP WITH TIME ZONE	Creation timestamp.
updated_at	TIMESTAMP WITH TIME ZONE	Last update timestamp.
owner_name	VARCHAR	The user who owns the Flight.

Version-specific content (source_code, requirements_txt, config) is not on this row; query MD_GET_FLIGHT_VERSION when you need it.

note

The name column is flight_name, not name. Filter and project with flight_name (for example, WHERE flight_name = 'hourly_metrics').

Examples

List all Flights:

SELECT flight_id, flight_name, schedule_cron, current_version
FROM MD_LIST_FLIGHTS();

Page through results:

SELECT flight_name
FROM MD_LIST_FLIGHTS("LIMIT" := 50, "OFFSET" := 100);

Find Flights with active schedules:

SELECT flight_name, schedule_cron
FROM MD_LIST_FLIGHTS()
WHERE schedule_cron IS NOT NULL;

As an Admin, group the organization's Flights by owner:

SELECT owner_name, count(*) AS flights
FROM MD_LIST_FLIGHTS()
GROUP BY owner_name
ORDER BY flights DESC;

Narrow the listing back to the Flights you own:

SELECT flight_name
FROM MD_LIST_FLIGHTS(owner_only := true);

Related

• MD_GET_FLIGHT — Fetch a single Flight's summary.
• MD_LIST_FLIGHT_RUNS — List a Flight's runs.
• list_flights MCP tool — AI-agent equivalent (supports a keywords filter).