SQL Server

Connect to Microsoft SQL Server databases.

Authentication

This connector uses Token-based authentication.

info

Set up your connection in the Abstra Console before using it in your workflows.

How to use

Using the Smart Chat

Execute the action "CHOOSE_ONE_ACTION_BELOW" from my connector "YOUR_CONNECTOR_NAME" using the params "PARAMS_HERE".

Using the Web Editor

from abstra.connectors import run_connection_action

result = run_connection_action(
  connection_name="your_connection_name",
  action_name="your_action_name",
  params={
    "param1": "value1",
    "param2": "value2"
  })

Available Actions

This connector provides 9 actions:

Action	Purpose	Parameters
query	Execute a raw SQL query	query (string) required params (object)
select	Select records from a table	table (string) required columns (array) where (object) orderBy (string) limit (number) offset (number)
insert	Insert a record into a table	table (string) required data (object) required
update	Update records in a table	table (string) required data (object) required where (object) required
delete	Delete records from a table	table (string) required where (object) required
list_tables	List all tables in the database	No parameters
list_schemas	List all schemas in the database	No parameters
describe_table	Get the structure of a table	table (string) required
test_connection	Test the database connection	No parameters