Connectors

Databases & Data Warehouses

SQL Server

Microsoft relational database: run queries, inserts, updates, and stored procedures
SQL Server documentationAPI checked August 16, 2026
Signs in with
Connection details
Runs on
Cloud or On-Prem Worker
Operations
13
Ready-made triggers
0

Connect SQL Server

  1. In Neblex open Connect › Connections and click New Connection.
  2. Search for SQL Server and give the connection a clear name.
  3. Fill in the fields. Secret values are encrypted and never shown again.
  4. Click Test, then Create Connection.
If the system is only reachable inside your network, choose an On-Prem Worker under Test from and run the flow on that Worker. See On-Prem Workers.
FieldWhat to enter
Connection setupRequired
HostRequired
PortOptionalExample: 1433
DatabaseRequired
UserRequired
PasswordRequiredSecret
Encrypt with TLSOptionalTurning this off sends traffic and credentials without transport encryption. Use plaintext only for a customer-controlled endpoint that explicitly requires it.
Connection stringRequiredSecretPaste a sqlserver:// connection string.

Use it in a flow

  1. Open a flow, open the node library and search for SQL Server.
  2. Drag it onto the canvas and choose an Operation and your connection.
  3. Map the operation's fields from earlier steps, or click Map with Matt.
  4. Use Test this step to see what it returns, then save.

To start a flow from SQL Server without a ready-made trigger: a Poll for changes trigger on SQL Server with your own query passes on new or changed records.

Operations

13 operations in 1 groups. Each one is a step you can add to a flow.

SQL13
Delete rows (mapped)deleteDelete the row matching the key columns of each record.
Execute commandcommandExecute the Transact-SQL DML, DDL, or stored procedure entered in the statement editor.
Execute queryqueryExecute the Transact-SQL entered in the statement editor with bound :name parameters.
Get server timeserverTimeReturn the current database timestamp with its offset.
Get server versionserverVersionReturn the complete SQL Server version.
Get table row counttableRowCountReturn partition row counts for every table matching the supplied name.
Insert rows (mapped)insertInsert one row per record into a table you pick, mapping each column from the record.
List table columnslistColumnsList columns for every visible table matching the supplied name.
List tableslistTablesList user-visible tables and views with their schemas and types.
Select rows (mapped)selectRead rows from a table you pick: choose the columns to return, filter by the column values you map, order and limit.
Test SQL ServerpingRun a minimal query and return ok=1.
Update rows (mapped)updateUpdate the row matching the key columns of each record, setting the other mapped columns.
Upsert rows (mapped)upsertInsert one row per record, or update the existing row when the key columns already match.