Skip to main content

Microsoft SQL Server Component

Query and manage data in a Microsoft SQL Server (MSSQL) Database

Component key: ms-sql-server


Microsoft SQL Server (MSSQL) is a popular relational database system. This component allows you to query an MSSQL database.

Instead of generating dynamic queries and sanitizing SQL yourself, you can use generic queries with named parameter placeholders like @variableKey. For example, you can enter a query that reads INSERT INTO users (name, email) VALUES (@name, @email). Then, you can enter values with keys of name and email, and whatever values you like. Values provided for name and email are sanitized automatically.

If you are dynamically generating SQL queries and do not know what parameters you will need ahead of time, create a key/value object in another step and reference them through the Parameters Object input. In the example above, you could generate an object of the form {name: "John doe", email: ""}.


MS SQL Server Connection

The MS SQL Server username and password can be put directly into a connection, alongside the database host, port, and database name.



Interact with a Microsoft SQL Server Database | key: query