Table

User-defined data tables

Tables allow you to create and manage custom data tables directly within SteelEngine. Store, query, and manipulate structured data within your workflows without needing external database integrations.

Why Use Tables?

  • No external setup: Create tables instantly without configuring external databases
  • Workflow-native: Data persists across workflow executions and is accessible from any workflow in your workspace
  • Organized into databases: Every table lives in a database — a flat container that groups your workspace's tables
  • Flexible schema: Define columns with types (string, number, boolean, date, json) and constraints (required, unique)
  • Powerful querying: Filter, sort, and paginate data using MongoDB-style operators
  • Agent-friendly: Tables can be used as tools by AI agents for dynamic data storage and retrieval

Key Features:

  • Create tables with custom schemas
  • Insert, update, upsert, and delete rows
  • Query with filters and sorting
  • Batch operations for bulk inserts and upserts
  • Bulk updates, deletes, and replacements by filter
  • Tables per workspace and rows per table are plan-based — see Limits

Creating Tables

Tables are created from the Databases section in the sidebar: open (or create) a database, then click New table. Workflows can also create tables with the Create Table operation (table_create). Each table requires:

  • Name: Alphanumeric with underscores (e.g., customer_leads), unique within its database
  • Description: Optional description of the table's purpose
  • Schema: Define columns with name, type, and optional constraints

Column Types

TypeDescriptionExample Values
stringText data"John Doe", "active"
numberNumeric data42, 99.99
booleanTrue/false valuestrue, false
dateDate/time values"2024-01-15T10:30:00Z"
jsonComplex nested data{"address": {"city": "NYC"}}

Column Constraints

  • Required: Column must have a value (cannot be null)
  • Unique: Values must be unique across all rows (enables upsert matching)

Filter Operators

Filters use MongoDB-style operators for flexible querying:

OperatorDescriptionExample
$eqEquals{"status": {"$eq": "active"}} or {"status": "active"}
$neNot equals{"status": {"$ne": "deleted"}}
$gtGreater than{"age": {"$gt": 18}}
$gteGreater than or equal{"score": {"$gte": 80}}
$ltLess than{"price": {"$lt": 100}}
$lteLess than or equal{"quantity": {"$lte": 10}}
$inIn array{"status": {"$in": ["active", "pending"]}}
$ninNot in array{"type": {"$nin": ["spam", "blocked"]}}
$containsString contains{"email": {"$contains": "@gmail.com"}}

Combining Filters

Multiple field conditions are combined with AND logic:

{
  "status": "active",
  "age": {"$gte": 18}
}

Use $or for OR logic:

{
  "$or": [
    {"status": "active"},
    {"status": "pending"}
  ]
}

Sort Specification

Specify sort order with column names and direction:

{
  "createdAt": "desc"
}

Multi-column sorting:

{
  "priority": "desc",
  "name": "asc"
}

Built-in Columns

Every row automatically includes:

ColumnTypeDescription
idstringUnique row identifier
createdAtdateWhen the row was created
updatedAtdateWhen the row was last modified

These can be used in filters and sorting.

Limits

ResourceLimit
Databases per workspace50
Tables per workspacePlan-based — 3 (Free), 25 (Pro), 100 (Team), 10,000 (Enterprise)
Rows per tablePlan-based — 100,000 (Free, Pro, Team) or 1,000,000 (Enterprise); see Tables limits
Columns per table1,000
Max row size100 KB
String value length100 KB (the row size is the binding limit)
Query limit1,000 rows (default 100)
Batch insert / upsert size1,000 rows
Bulk update / delete / replace1,000 rows

Notes

  • Every table lives in a database within your workspace and is accessible from any workflow in that workspace
  • Use the Database block to list databases, create databases, list tables, and run read-only queries
  • Data persists across workflow executions
  • Use unique constraints to enable upsert functionality
  • The visual filter/sort builder provides an easy way to construct queries without writing JSON

Usage Instructions

Create and manage custom data tables. Store, query, and manipulate structured data within workflows.

Tools

table_insert_row

Insert a new row into a table. IMPORTANT: You must use the "data" parameter (not "values", "row", "fields", or other variations) to specify the row contents.

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
dataobjectYesRow data as JSON object

Output

ParameterTypeDescription
successbooleanWhether row was inserted
rowjsonInserted row data
messagestringStatus message

table_batch_insert_rows

Insert multiple rows into a table at once (up to rows)

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
rowsarrayYesArray of row data objects (max ${TABLE_LIMITS.MAX_BATCH_INSERT_SIZE} rows)

Output

ParameterTypeDescription
successbooleanWhether rows were inserted
rowsarrayInserted rows data
insertedCountnumberNumber of rows inserted
messagestringStatus message

table_batch_upsert_rows

Insert or update multiple rows by conflict target (up to rows). Updates require exactly one matching row; ambiguous matches are returned as per-row failures so workflows can route them without custom code.

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
rowsarrayYesArray of row data objects to insert or update (max ${TABLE_LIMITS.MAX_BATCH_INSERT_SIZE} rows)
conflictTargetstringNoColumn used to match existing rows. Required when the table has no single unique column; if multiple rows match a value, that row fails.
continueOnErrorbooleanNoWhen true, continue processing remaining rows and return per-row failures. Defaults to true.

Output

ParameterTypeDescription
successbooleanWhether the batch request completed
rowsarraySuccessfully upserted rows
resultsarrayPer-row upsert results with operation or error
insertedCountnumberNumber of rows inserted
updatedCountnumberNumber of rows updated
failedCountnumberNumber of rows that failed
messagestringStatus message

table_upsert_row

Insert or update a row based on unique column constraints. If a row with matching unique field exists, update it; otherwise insert a new row. IMPORTANT: You must use the "data" parameter (not "values", "row", "fields", or other variations) to specify the row contents.

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
dataobjectYesRow data to insert or update
conflictTargetstringNoUnique column to match when the table has multiple unique columns. If omitted, the table must have exactly one unique column.

Output

ParameterTypeDescription
successbooleanWhether row was upserted
rowjsonUpserted row data
operationstringOperation performed: insert or update
messagestringStatus message

table_update_row

Update an existing row in a table. Supports partial updates - only include the fields you want to change. IMPORTANT: You must use the "data" parameter (not "values", "row", "fields", or other variations) to specify the fields to update.

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
rowIdstringYesRow ID to update
dataobjectYesUpdated row data

Output

ParameterTypeDescription
successbooleanWhether row was updated
rowjsonUpdated row data
messagestringStatus message

table_update_rows_by_filter

Update multiple rows that match filter criteria. Data is merged into each row. Unique columns cannot be changed; use Update Row for those fields.

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
filterobjectYesFilter criteria using operators like $eq, $ne, $gt, $lt, $contains, $in, etc.
dataobjectYesFields to update (merged with existing data)
limitnumberNoMaximum number of rows to update (default: no limit, max: ${TABLE_LIMITS.MAX_BULK_OPERATION_SIZE})

Output

ParameterTypeDescription
successbooleanWhether rows were updated
updatedCountnumberNumber of rows updated
updatedRowIdsarrayIDs of updated rows
messagestringStatus message

table_delete_row

Delete a row from a table

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
rowIdstringYesRow ID to delete

Output

ParameterTypeDescription
successbooleanWhether row was deleted
deletedCountnumberNumber of rows deleted
messagestringStatus message

table_delete_rows_by_filter

Delete multiple rows that match filter criteria. Use with caution - supports optional limit for safety.

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
filterobjectYesFilter criteria using operators like $eq, $ne, $gt, $lt, $contains, $in, etc.
limitnumberNoMaximum number of rows to delete (default: no limit, max: ${TABLE_LIMITS.MAX_BULK_OPERATION_SIZE})

Output

ParameterTypeDescription
successbooleanWhether rows were deleted
deletedCountnumberNumber of rows deleted
deletedRowIdsarrayIDs of deleted rows
messagestringStatus message

table_replace_rows_by_filter

Delete rows matching filter criteria and insert replacement rows atomically. Empty replacement rows are allowed and clear the matching rows.

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
filterobjectYesFilter criteria using operators like $eq, $ne, $gt, $lt, $contains, $in, etc.
rowsarrayYesReplacement row data objects (max ${TABLE_LIMITS.MAX_BATCH_INSERT_SIZE} rows). Empty array clears matching rows.
limitnumberNoMaximum number of existing rows to replace (default: no limit, max: ${TABLE_LIMITS.MAX_BULK_OPERATION_SIZE})

Output

ParameterTypeDescription
successbooleanWhether rows were replaced
deletedCountnumberNumber of rows deleted
deletedRowIdsarrayIDs of deleted rows
insertedCountnumberNumber of replacement rows inserted
rowsarrayInserted replacement rows data
messagestringStatus message

table_query_rows

Query rows from a table with filtering, sorting, and pagination

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
filterobjectNoFilter conditions (MongoDB-style operators: $eq, $ne, $gt, $gte, $lt, $lte, $in, $nin, $contains)
sortobjectNoSort order as {field: "asc"|"desc"}
limitnumberNoMaximum rows to return (default: ${TABLE_LIMITS.DEFAULT_QUERY_LIMIT}, max: ${TABLE_LIMITS.MAX_QUERY_LIMIT})
offsetnumberNoNumber of rows to skip (default: 0)

Output

ParameterTypeDescription
successbooleanWhether query succeeded
rowsarrayQuery result rows
rowCountnumberNumber of rows returned
totalCountnumberTotal rows matching filter
limitnumberLimit used in query
offsetnumberOffset used in query

table_get_row

Get a single row by ID

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID
rowIdstringYesRow ID to retrieve

Output

ParameterTypeDescription
successbooleanWhether row was retrieved
rowjsonRow data
messagestringStatus message

table_get_schema

Get the schema configuration of a table

Input

ParameterTypeRequiredDescription
tableIdstringYesTable ID

Output

ParameterTypeDescription
successbooleanWhether schema was retrieved
namestringTable name
columnsarrayColumn definitions
messagestringStatus message

table_create

Create a new user-defined table with schema

Input

ParameterTypeRequiredDescription
namestringYesTable name (alphanumeric, underscores, 1-50 chars)
descriptionstringNoOptional table description
schemaobjectYesTable schema with column definitions
databaseIdstringNoOptional database ID to create the table in

Output

ParameterTypeDescription
successbooleanWhether table was created
tablejsonCreated table metadata
messagestringStatus message

On this page