CloudBeaver icon

CloudBeaver

Interact with databases via CloudBeaver: execute SQL queries, select, insert, update, and delete rows

Actions5

Select Rows

AI-generated

Summary

Select rows from a specified database table within a CloudBeaver shared project connection, applying optional filters, ordering, and pagination to retrieve query results.

Inputs

  • Connection ID (required) — ID of the database connection in CloudBeaver, obtained by right-clicking the database in Database Navigator and selecting Open.
  • Default Database — Optional database/catalog to use for the query; defaults to the connection's default if empty.
  • Database Type — Type of database (PostgreSQL, MySQL, SQL Server) affecting identifier quoting style.
  • Schema — Database schema containing the target table; omit to exclude schema prefix.
  • Table (required) — Name of the table to select rows from.
  • WHERE Clause — SQL condition to filter returned rows; leave empty to select all rows.
  • Order By — Column(s) to sort results by, e.g. 'name ASC, created_at DESC'.
  • Limit — Maximum number of rows to return; defaults to 50.
  • Offset — Number of rows to skip before starting to return results; defaults to 0.
  • Options — Additional options including query timeout in seconds (default 60) and whether to replace empty strings with NULL in results.

Output shape

a list of rows as JSON objects representing the selected table records

Results include columns as keys and row values; supports pagination via Limit and Offset; errors can be handled with continueOnFail option; uses shared CloudBeaver project connections only.

Examples

Example 1: Select all active users older than 18 from the users table, limited to 50 rows, ordered by name ascending.

Set Connection ID, optionally Database Type to match target database, Schema if needed, Table to 'users', WHERE Clause to "age > 18 AND status = 'active'", Order By to 'name ASC', Limit to 50, and Offset to 0.

Links

Discussion