Data Wisp

Data Wisp is an AI data assistant for answering business questions in natural language. It integrates with MotherDuck for conversational analytics workflows.

How it works with MotherDuck

Data Wisp connects to a MotherDuck database as a read-only data source for conversational analytics and lightweight data apps.

Prerequisites

• A MotherDuck database to query from Data Wisp.
• A MotherDuck Read Scaling Token or another read-only token for the Data Wisp connection.
• Access to create or import data sources in Data Wisp.

Setup

1. In MotherDuck, create a token for Data Wisp. Choose a read-only token type because Data Wisp does not write to the database.
2. In Data Wisp, open Data Sources and select Import.
3. Choose Database, then set Connection type to MotherDuck.
4. Enter a title, paste the MotherDuck token, and enter the database name.
5. Select Connect and confirm that Data Wisp reports a successful connection.

Authentication and configuration

• Store the MotherDuck token in Data Wisp's connection settings.
• Enter the database name without the md: prefix unless Data Wisp's UI specifically asks for a full connection string.
• If your environment uses network restrictions, allowlist the Data Wisp IP address shown in the connection form.

Important notes

• Prefer a dedicated token for Data Wisp so you can rotate or revoke access without affecting other tools.
• Use a read-only token unless you have a clear reason for Data Wisp to use broader permissions.

Use cases

• Let business users ask natural-language questions over curated MotherDuck datasets.
• Build lightweight internal dashboards and data apps from existing MotherDuck tables.
• Connect a specific MotherDuck database to a Data Wisp workspace.

Related content

• View the full Data Wisp MotherDuck setup guide
• MotherDuck Read Scaling tokens
• MotherDuck authentication