All integrationsDatabases

DuckDB

Run SQL on DuckDB in the cloud (MotherDuck): query and change data, explore databases, schemas and tables, and create or drop tables.

actions
14

Actions

Steps a workflow can run in DuckDB.

  • Run SQL queryRun one read-only SQL statement (SELECT, WITH, SHOW, DESCRIBE, SUMMARIZE or EXPLAIN) and return its rows.
  • Run SQL statementRun one statement that changes data or tables: INSERT, UPDATE, DELETE, MERGE, CREATE, DROP or ALTER.
  • List databasesList the databases in the MotherDuck account.
  • List schemasList the schemas in a database.
  • List tablesList the tables and views in a database, or in one of its schemas.
  • Describe tableRead a table's or view's columns: names, types, whether they can be empty, defaults and the primary key.
  • Count rowsCount a table's rows, or only the rows that match column and value pairs.
  • Find rowsRead rows from a table, optionally only those matching column and value pairs, sorted and paged.
  • Insert rowsAdd up to 1000 rows to a table. Each row is an object of column names and values; a column a row leaves out is set to empty.
  • Update rowsSet column values on every row that matches the column and value pairs.
  • Delete rowsDelete every row that matches the column and value pairs.
  • Create schemaCreate a schema in a database.
  • Create tableCreate a table from column names and types, with an optional primary key.
  • Drop tableDelete a table and every row in it, for good.

Automate DuckDB with Lodol.

Connect DuckDB, then hand Lodol the job in Slack, Claude or ChatGPT.

Free plan, no credit card