SQL Assistant

Built-in SQL functions that use AI to help you work with SQL. Generate SQL queries, execute read-only questions directly, fix errors, explain queries, and more.

These functions can be useful building blocks for AI-driven analytics solutions or used stand-alone on all MotherDuck surfaces (including the CLI).

To use external tools like Claude Desktop or Cursor with MotherDuck, see Connecting AI Tools to MotherDuck.

Available Functions

📄️ PROMPT_QUERY

Answer questions about your data

📄️ PROMPT_SQL

Overview

📄️ PROMPT_EXPLAIN

Explain a query

📄️ PROMPT_FIX_LINE

Fix your query line-by-line

📄️ PROMPT_FIXUP

Fix up your query

📄️ PROMPT_SCHEMA

Describe contents of a database

Notes

SQL assistant functions operate on your current database by evaluating the schemas and contents of the database. You can specify which tables and columns should be considered using the optional include_tables parameter. By default, all tables in the current database are considered.

To point the SQL assistant functions at a specific database, execute the USE database command (learn more about switching databases).

These capabilities are provided by MotherDuck's integration with Azure OpenAI.

For availability and pricing, see MotherDuck's Pricing Model.

If you have further questions or specific requirements, please see our support page.

Regional Processing

Requests are processed based on the region of the MotherDuck organization according to the table below. Functions that are not available within the region (no checkmark) will be processed with global compute resources.

Function	Global	Europe
SQL Assistant Functions	✓	✓