Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

Fabi.ai

Fabi.ai is an AI-native notebook and BI workspace for Python, SQL, dashboards, and workflows. It integrates with MotherDuck for exploration and analysis.

How it works with MotherDuck​

Fabi.ai connects to MotherDuck as a database source for notebooks, BI workflows, dashboards, and AI-assisted analysis.

Prerequisites​

  • A Fabi.ai workspace.
  • A MotherDuck service token.
  • Network allowlisting if your security policy restricts inbound connections.

Setup​

  1. In MotherDuck, create a service token for Fabi.ai.
  2. In Fabi.ai, start the data source connection flow and choose MotherDuck.
  3. Paste the service token into the MotherDuck connection.
  4. Save the data source and validate it from a notebook or workflow.

Authentication and configuration​

  • Use a dedicated service token for the Fabi.ai workspace.
  • Fabi.ai documents the IP addresses to allowlist for MotherDuck connections. Add them if your environment enforces firewall rules.
  • Keep the token in Fabi.ai's connection settings or secret manager.

Important notes​

  • Fabi.ai's MotherDuck setup is token-based; no local DuckDB file path is needed.
  • If a connection fails, verify both the token and any IP allowlist configuration.

Use cases​

  • Analyze MotherDuck data in Fabi.ai notebooks.
  • Build dashboards and data apps backed by MotherDuck.
  • Use Fabi.ai AI workflows against curated MotherDuck datasets.

Related content​