QuestDB#
Use the QuestDB node to automate work in QuestDB, and integrate QuestDB with other applications. n8n 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 for guidance on setting up authentication.
Operations#
- Executes a SQL query.
- Insert rows in database.
Templates and examples#
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
.