Use Microsoft SQL Server to query or modify rows, execute T-SQL, and inspect tables, keys, and indexes.
Connection setup
In Integrations, add a connection with the host, port, database, username, password, and transport-security settings. Sim proves the connection with SELECT 1 before saving it encrypted, then reads it on the server for each run; the block, the workflow, and agents never see the password. Reconnect the connection from Integrations when its credentials change. The runtime must be able to reach the database host.
- Encrypt connection requests TLS; leave it enabled. A server that does not support encryption gets an unencrypted session rather than an error, so confirm the server has encryption on.
- Trust server certificate skips certificate validation. Enable it only for a server with a self-signed certificate you trust.
- Named instances are not supported; give the instance a static TCP port and connect to that port.
Workflows built before saved connections keep their inline connection fields and run unchanged.
Use the block
Query, insert, update, delete, execute raw T-SQL, and introspect schemas.
Actions
Microsoft SQL Server Query
Execute a SELECT query on a Microsoft SQL Server database
Microsoft SQL Server Insert
Insert data into a Microsoft SQL Server table
Microsoft SQL Server Update
Update rows in a Microsoft SQL Server table
Microsoft SQL Server Delete
Delete rows from a Microsoft SQL Server table
Microsoft SQL Server Execute
Execute a raw T-SQL statement on a Microsoft SQL Server database
Microsoft SQL Server Introspect
Introspect a Microsoft SQL Server schema to retrieve table structures, columns, keys, and indexes. Results only cover objects the login can see, so a low-privilege account returns a partial schema rather than an error