Skip to main content

Dives Functions

SQL table functions for managing Dives, the interactive React data apps that query live MotherDuck data. These functions let you create, read, update, and delete Dives directly from SQL. Dives use the useSQLQuery hook to query data from within their React components and the useDiveState hook to sync shareable UI state to the URL.

note

These functions are executed server-side on MotherDuck. They are not available on local-only DuckDB connections.

Create your first Dive assisted by your AI-tool of choice using our MCP server. Or try out a minimal working example using only SQL.

SELECT * FROM MD_CREATE_DIVE(
  title = 'PokeDuck',
  content = '
    import { useSQLQuery } from "@motherduck/react-sql-query";
    export default function Dive() {
        const { data } = useSQLQuery(
            `SELECT PROMPT(''Suggest a duck type or pokemon and tell a fun fact about them'')`,
            { select: (rows) => Object.values(rows[0])[0] }
            );
        return <div><p>FUN FACT:</p><p>{JSON.stringify(data)}</p></div>;
    }'
);

Available functions​