Skip to main content

Database Toolkit

The Database Toolkit allows your workflows to interact with a SQL database — listing tables, retrieving schema information, executing queries, and validating SQL before running it.

Authentication​

All Database tools require a SQL database connection. Each tool includes a Connection selector. If no connection is configured, go to Settings → Connectors to create one.

Tools​

List Tables​

Retrieves a list of all tables in the connected database.

FieldRequiredDescription
ConnectionYesSelect a configured database connection.

Table Info​

Retrieves schema information for one or more tables in the connected database.

FieldRequiredDescription
ConnectionYesSelect a configured database connection.
Table NamesYesComma-separated list of table names to retrieve schema info for (e.g. users, orders). Type @ to select a variable.

SQL Db Query​

Executes a SQL query against the connected database.

FieldRequiredDescription
ConnectionYesSelect a configured database connection.
SQL QueryYesThe SQL query to execute. Supports SELECT (read), INSERT, UPDATE, DELETE (data modification), and CREATE, ALTER, DROP (schema changes). Type @ to use variables in the query. SELECT queries without a LIMIT clause are automatically limited to 100 rows.

Query Checker​

Validates a SQL query against the connected database without executing it.

FieldRequiredDescription
ConnectionYesSelect a configured database connection.
QueryYesThe SQL query to validate. Type @ to select a variable.