SQL Query
Query your database directly from a workflow
Last updated
Query your database directly from a workflow
Last updated
The SQL Query Step allows you to run queries directly against your connected databases. This can be useful for pulling data into your workflows, or even building out workflows focused on writing directly to your databases.
The SQL Query Step is fairly straightforward. The only prerequisite is that you have connected a SQL database via a read user. See our documentation page on Connecting Datasources for more information.
Once you have successfully connected a data source, you can add a SQL Query Step into your Workflows as shown below:
One of the most powerful use-cases we've seen for our SQL Query Step is to power an Agent to assist with writing and editing your own queries. It was so popular, that we built our "Data Sidekick" Agent template around it.
As you start to dig into your use-cases more deeply, we would recommend giving it a quick peek behind the curtains:
