SQL Server

Insert a new row into any table in your SQL Server database.

Modify the values of an existing row identified by a primary-key column.

Execute any custom SQL statement — INSERT, DELETE, or stored-procedure call — that completes within 30 seconds.

Look up a single row in a table by matching a specified column value — returns the first match.

Return a single row matching a custom SELECT query you write — useful when the lookup condition spans multiple columns or joins.

Return a set of rows from a custom SELECT query — supports joins, WHERE clauses, ORDER BY, and LIMIT for precise multi-row retrieval.

Remove a single row from a table identified by its primary key — use for hard-delete workflows such as GDPR erasure requests.

Call a named stored procedure and return its result set — useful for complex business logic already encapsulated in the database.

Retrieve the column definitions, data types, and constraints for a specified table — useful for validation before writing data.

Return a list of all tables and views in the connected SQL Server database — useful for dynamic schema discovery.

Insert multiple rows into a table in a single operation — efficient for writing batch data from external sources without looping N+1 inserts.

Execute a SELECT query using aggregate functions (COUNT, SUM, AVG, MAX, MIN) and return the summary result — ideal for KPI checks and threshold alerts.

Return a boolean indicating whether at least one row matching a given column-value pair exists — useful as a pre-condition check before insert or update.

Return the total number of rows in a table or the count matching a WHERE condition — useful for health checks, pagination planning, and data-volume alerts.

Fires within about a minute when a new row is added to a specified table — lets agents react to fresh data without polling manually.

Fires within about a minute when a row is inserted or a tracked column is modified — useful for keeping downstream systems in sync with live database changes.

Fires when a custom SELECT query returns new rows not seen in the previous poll — gives full SQL flexibility for complex trigger conditions.

Fires when a custom SELECT query returns rows that are new or have changed since the last poll — ideal for multi-table join conditions that standard triggers cannot express.

Fires when a new column is added to a specified table — useful for schema-change monitoring and documentation workflows.

Fires when a new table is created in the database — useful for infrastructure governance and automatic onboarding of new data sources.