Use Microsoft SQL Server to query or modify rows, execute T-SQL, and inspect tables, keys, and indexes. Configure the host, port, database, credentials, and TLS settings for your instance.

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

Input

Output

Microsoft SQL Server Insert

Insert data into a Microsoft SQL Server table

Input

Output

Microsoft SQL Server Update

Update rows in a Microsoft SQL Server table

Input

Output

Microsoft SQL Server Delete

Delete rows from a Microsoft SQL Server table

Input

Output

Microsoft SQL Server Execute

Execute a raw T-SQL statement on a Microsoft SQL Server database

Input

Output

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

Inputs and outputs

Input

Parameter	Type	Required	Description
host	string	Yes	Microsoft SQL Server hostname or IP address
port	number	No	Server port (default: 1433). A named instance must be reached through its static TCP port
database	string	Yes	Database name to connect to
username	string	Yes	Database username
password	string	Yes	Database password
encrypt	string	No	Request TLS encryption for the connection (enabled, disabled). Defaults to enabled. Disabling sends the login packet and every row in cleartext. Enabling requests encryption over TDS 7.4, which the server negotiates during prelogin - a server that answers NOT_SUP yields an unencrypted session rather than an error, so this is a request, not a guarantee
trustServerCertificate	string	No	Trust a self-signed server certificate (enabled, disabled). Defaults to disabled. Enabling skips certificate validation, so the connection is open to a machine-in-the-middle
connectionTimeout	number	No	Connection and request timeout in milliseconds (default: 15000)
schema	string	No	Schema to introspect (default: dbo)

Output

Parameter	Type	Description
message	string	Operation status message
tables	array	Array of table schemas with columns, keys, and indexes
↳ name	string	Table name
↳ schema	string	Schema name (e.g., dbo)
↳ columns	array	Table columns in ordinal position order
↳ name	string	Column name
↳ type	string	Data type (e.g., int, nvarchar, datetime2)
↳ nullable	boolean	Whether the column allows NULL values
↳ default	string	Default value expression
↳ isPrimaryKey	boolean	Whether the column is part of the primary key
↳ isForeignKey	boolean	Whether the column is a foreign key
↳ references	object	Foreign key reference information
↳ schema	string	Referenced schema name
↳ table	string	Referenced table name
↳ column	string	Referenced column name
↳ primaryKey	array	Primary key column names, in key order
↳ foreignKeys	array	Foreign key constraints declared on this table
↳ column	string	Local column name
↳ referencesSchema	string	Referenced schema name
↳ referencesTable	string	Referenced table name
↳ referencesColumn	string	Referenced column name
↳ indexes	array	Non-primary-key rowstore indexes on this table
↳ name	string	Index name
↳ columns	array	Key columns included in the index, in key order
↳ unique	boolean	Whether the index enforces uniqueness
schemas	array	List of available schemas in the database