Microsoft SQL
The Microsoft SQL block runs queries against a Microsoft SQL Server database from your workflow — read data with custom queries, and insert, update, or delete rows.
Database Automation: Look up a customer, insert a new order row, or clean up old records as part of any workflow — with workflow variables passed safely as query parameters.
Microsoft SQL is not available on the Free plan. Upgrade your workspace plan to use this block.
Key Features
- Execute Query: Run any SQL statement and read the returned rows
- Insert Row: Add a row with parameterized values (protected against SQL injection)
- Update Rows: Change columns on rows matching a WHERE clause
- Delete Rows: Remove rows matching a WHERE clause
- Response Mapping: Save rows, row counts, and affected-row counts into variables
- Secure Connections: Encryption on by default, with an option to trust self-signed certificates
Operations
| Operation | Required fields | Notes |
|---|---|---|
| Execute Query | Query | Any SQL statement; returned rows go to the output |
| Insert Row | Table, Values | Values is a JSON array, e.g. ["Jane", "jane@x.com"]. Columns is an optional comma-separated list, e.g. name, email |
| Update Rows | Table, Columns, WHERE clause | Columns is a JSON object of column → new value, e.g. {"status": "shipped"} |
| Delete Rows | Table, WHERE clause | Deletes every row matching the WHERE clause |
Update and Delete apply to every row matching the WHERE clause. Double-check the clause — a too-broad condition changes more rows than you expect.
Configuration
| Parameter | Type | Required | Description |
|---|---|---|---|
| Microsoft SQL account | Credential | Yes | The database connection to use |
| Action | Select | Yes | One of the four operations above |
| Query | Text | Execute Query | The SQL to run; supports {{variables}} |
| Table | Text | Insert / Update / Delete | The target table name |
| Columns | Text | Update (JSON object) / Insert (optional list) | See the operations table for the format per action |
| Values | JSON array | Insert | The row values, bound as query parameters |
| WHERE clause | Text | Update / Delete | Condition selecting the rows to change, without the WHERE keyword |
| Response mapping | Value → Variable | No | Save response values into workflow variables |
Setting up the credential
- Collect your SQL Server connection details: host (e.g.
myserver.database.windows.net), port (default1433), database name, username, and password. - In the block settings, click to add a Microsoft SQL connection.
- Enter the Host, Port, Database, Username, and Password.
- Optionally enter a Domain for Windows (NTLM) authentication.
- Leave Encrypt on (required for Azure SQL). Enable Trust Server Certificate only if your server uses a self-signed certificate.
- Save the credential and select it in the block.
Make sure your SQL Server allows connections from your Indite instance — check firewall rules and, for Azure SQL, the server's network access settings.
Example: save chatbot signups
- A Webhook Trigger receives a new signup from your bot.
- A Microsoft SQL block with Insert Row adds it: Table
Customers, Columnsname, email, Values["{{name}}", "{{email}}"]. - A second block with Execute Query runs
SELECT COUNT(*) AS total FROM Customersand maps Rows to a variable for a daily report.
Output
Use Response mapping to extract values into variables:
| Value | Description |
|---|---|
Rows | The rows returned by the statement (Execute Query) |
Row Count | How many rows were returned |
Affected Rows | How many rows an Insert / Update / Delete touched |
Success | Whether the operation succeeded |
Full Data | The complete raw result |