Dot

AI data analyst that answers questions and provides insights through conversational analytics. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows.

How it works with MotherDuck

Dot connects to MotherDuck with an md: connection string and uses that connection for AI-assisted analysis, including Slack workflows.

Prerequisites

• A MotherDuck access token.
• The name of the MotherDuck database Dot should query.
• DuckDB 0.10.2 or later for the MotherDuck connector used by Dot.

Setup

1. In MotherDuck, create or copy an access token.

2. Build a connection string for the target database:

   md:<database_name>?motherduck_token=<your_token>

3. In Dot, add a MotherDuck database integration and paste the connection string.

4. Save the connection, then validate it with a small question or query.

Authentication and configuration

• Use a dedicated token for the Dot workspace.
• Scope the token to the database access Dot needs for analysis.
• Treat the connection string as a secret because it includes the MotherDuck token.

Important notes

• Dot's setup guide includes local DuckDB options. For MotherDuck, use the md: connection string.
• Store the token in Dot's secret handling rather than sharing the connection string in chat.

Use cases

• Ask questions about MotherDuck data from Slack.
• Give a team an AI analyst experience over curated MotherDuck schemas.
• Connect a specific MotherDuck database to a Dot workspace.

Related content

• View the full Dot MotherDuck setup guide
• MotherDuck authentication