# QuestDB node

Use the QuestDB node to automate work in QuestDB, and integrate QuestDB with other applications. Automated Workflows supports executing an SQL query and inserting rows in a database with QuestDB.

On this page, you'll find a list of operations the QuestDB node supports and links to more resources.

Credentials
Refer to [QuestDB credentials](/guides/automated-workflows/integrations/builtin/credentials/questdb) for guidance on setting up authentication.

## Operations

* Executes a SQL query.
* Insert rows in database.


## Node reference

### Specify a column's data type

To specify a column's data type, append the column name with `:type`, where `type` is the data type you want for column. For example, if you want to specify the type `int` for the column **id** and type `text` for the column **name**, you can use the following snippet in the **Columns** field: `id:int,name:text`.