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.
No actions match that.
Automate DuckDB with Lodol.
Connect DuckDB, then hand Lodol the job in Slack, Claude or ChatGPT.
Free plan, no credit card