Ligantic

/

/

/

/

Integration - SQL Disconnect

Type identifier: integration:sql:disconnect Category: Integration Operations

Description

The Integration - SQL Disconnect node explicitly closes a database connection that was established by an Integration - SQL Connect node. While connections are automatically cleaned up at the end of the top-level run, this node allows for explicit resource management within longer-running Flows. Shared SQL credential mode in Integration - SQL Query nodes is managed automatically and does not require a disconnect node.

Input Handles

Handle	Type	Description
`trigger`	control	Triggers the disconnection.
`connection`	SQL connection	The connection to close.

Output Handles

Handle	Type	Description
`success`	control	Triggered when disconnection succeeds.
`error`	control	Triggered when disconnection fails.

Configuration Options

This node has no additional configuration options.

Behaviour

Receives the connection object from the input handle
Closes the database connection
Triggers success or error control flow

Examples

Complete Database Operation Flow

Flow structure:

Integration - SQL Connect → connection
Integration - SQL Query (read) → data
Process data
Integration - SQL Query (write) → results
Integration - SQL Disconnect → cleanup

Related pages

Integration - SQL Connect

The Integration - SQL Connect node creates a connection to a SQL database that can be used by subsequent Integration - SQL Query nodes. It supports PostgreSQL and Microsoft SQL Server databases with various authentication options including connection strings and individual credential fields.

Integration - SQL Query

The Integration - SQL Query node executes SQL queries against a database connection established by an Integration - SQL Connect node. It supports parameterised queries to prevent SQL injection, validates queries for dangerous operations, and returns results matching a configurable schema.