CloudBeaverInstall

Summary

Delete rows from a table, truncate all rows, or drop the entire table in a CloudBeaver-managed shared project database connection.

Inputs

• connectionId (required) — The database connection ID in CloudBeaver, obtained by right-clicking the database in Database Navigator and selecting Open to see the ID.
• defaultDatabase — Optional database or catalog to use when executing SQL. Leave empty to use the connection's default database.
• dbType — Type of database (PostgreSQL, MySQL, or SQL Server) which affects identifier quoting style. Defaults to PostgreSQL.
• schema — Optional database schema containing the table. Leave empty to omit schema prefix.
• table (required) — Name of the table to delete rows from, truncate, or drop.
• deleteCommand (required) — The command to perform: delete rows matching an optional WHERE clause, truncate the table, or drop the table.
• deleteWhere — Condition to identify which rows to delete when using the Delete Rows command. If empty, deletes all rows. Ignored for truncate and drop commands.
• deleteOptions.queryTimeout — Maximum number of seconds to wait for the query to complete; defaults to 60 seconds.

Output shape

a list of JSON objects indicating success or error for each input item

Returns an array where each item corresponds to an input item. On success: { json: { success: true } }. On failure: { json: { error: error message } }, with error handling controlled by the node's continueOnFail setting.

Links

• n8n community nodes installation guide