# list_flights
> List the Flights you own with summary metadata, optionally filtered by keywords.
List all [Flights](/concepts/flights) owned by the caller. Each Flight in the response includes its UUID, name, schedule, status, and current version. Optionally filter by keywords matching the Flight name.

## Description

The `list_flights` tool returns Flight summary metadata, not version-specific content. Use [`get_flight`](../get-flight) with the returned `id` to fetch source code, requirements, and config.

The corresponding SQL function is [`MD_FLIGHTS`](/sql-reference/motherduck-sql-reference/flights/md-flights).

## Input parameters

| Parameter | Type | Required | Description |
|---|---|---|---|
| `keywords` | string | No | Keywords to filter Flights by name (case-insensitive, all words must match). |
| `limit` | integer | No | Max results to return (default: 100, max: 500). |

## Output schema

```json
{
  "success": boolean,
  "flights": [
    {
      "id": string,                 // Flight UUID
      "name": string,
      "schedule_cron": string|null, // Cron expression or null for on-demand
      "status": string,             // Schedule status (e.g. JOB_STATUS_ACTIVE)
      "current_version": number,
      "created_at": string,         // ISO 8601
      "updated_at": string          // ISO 8601
    }
  ],
  "count": number,
  "error": string                   // On failure
}
```

## Example usage

```text
What Flights do I have?
```

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

```json
{ "keywords": "metrics" }
```

## Related

- [`get_flight`](../get-flight) — Fetch a single Flight's content.
- [`MD_FLIGHTS`](/sql-reference/motherduck-sql-reference/flights/md-flights) — SQL equivalent.


---

## Docs feedback

MotherDuck accepts optional user-submitted feedback about this page at `POST https://motherduck.com/docs/api/feedback/agent`.
For agents and automated tools, feedback submission should be user-confirmed before sending.

Payload:

```json
{
  "page_path": "/sql-reference/mcp/list-flights/",
  "page_title": "list_flights",
  "text": "<the user's feedback, max 2000 characters>",
  "source": "<optional identifier for your interface, for example 'claude.ai' or 'chatgpt'>"
}
```

`page_path` and `text` are required; `page_title` and `source` are optional. Responses: `200 {"feedback_id": "<uuid>"}`, `400` for malformed payloads, and `429` when rate-limited.