App
SQL Server
Connect directly to a Microsoft SQL Server database and run SQL statements from your automations.
What your agent can do with SQL Server
Triggers and actions 4 triggers · 7 actions
- TriggerNew or Updated Row
Triggers when a new row is added or modified.
- TriggerNew or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.
- TriggerNew Row
Triggers when you add a new row.
- TriggerNew Table
Fires when a new table appears in the connected SQL Server database.
- ActionAdd Row
Add one row to a table on the connected SQL Server database.
- ActionDelete Row
Delete the rows in a table whose chosen column equals a value.
- ActionFind Row
Find the first row in a table whose chosen column matches a value.
- ActionFind Rows via Custom Query
Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.
- ActionFind Row via Custom Query
Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.
- ActionRun Custom Statement
Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.
- ActionUpdate Row
Change column values on every row of a table whose chosen column matches a value.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Not listed?
Need a trigger or action that is not here?
Ask your agent. Describe what you need in plain language and it reads the SQL Server API documentation, builds the operation at whatever depth the API allows, tests every branch and ships it. The list above is what exists today, not the limit.