MotherDuck Flights is a serverless Python runtime for building AI-native data pipelines without writing Python. Using the MotherDuck Remote MCP Server, AI agents can script full pipelines covering ingestion, transformation, and data activation. Flight Plans are pre-built templates for common operations like ingesting from Postgres (using DuckDB's Postgres extension with streaming and atomic loads), syncing data with Google Sheets via a DuckDB community extension, and sending Slack alerts based on SQL query thresholds. Flights support any PyPI package, any DuckDB extension, and can run Linux commands, making them highly flexible. The serverless sandbox model means you only pay for runtime seconds used, and agents can operate freely within an isolated environment.
