Skip to content

QuestDB#

The QuestDB node allows you 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.

Examples and templates

For usage examples and templates to help you get started, take a look at n8n's QuestDB integrations list.

Basic Operations#

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

Example Usage#

This workflow allows you to create a table and insert data into it in QuestDB. You can also find the workflow on n8n.io. This example usage workflow would use the following nodes. - Start - Set - QuestDB

The final workflow should look like the following image.

A workflow with the QuestDB node

1. Start node#

The start node exists by default when you create a new workflow.

2. QuestDB node (Execute Query)#

  1. First of all, you'll have to enter credentials for the QuestDB node. You can find out how to do that here.
  2. Select 'Execute Query' from the Operation dropdown list.
  3. Enter the following SQL query in the Query field: CREATE TABLE test (id INT, name STRING);.
  4. Click on the Node tab and toggle Always Output Data to true.
  5. Click on Execute Node to run the node.

Using the QuestDB node to create a table

3. Set node#

  1. Click on the Add Value button and select 'Number' from the dropdown list.
  2. Enter id in the Name field.
  3. Click on the Add Value button and select 'String' from the dropdown list.
  4. Enter name in the Name field.
  5. Enter the value for the name in the Value field.
  6. Click on Execute Node to run the node.

Using the Set node to set data to be inserted by the QuestDB node

4. QuestDB1 node (Insert)#

  1. Select the credentials that you entered in the previous QuestDB node.
  2. Enter test in the Table field.
  3. Enter id, name in the Columns field.
  4. Click on Execute Node to run the node.

Using the QuestDB node to insert data into a table

FAQs#

How to specify the data type of a column?#

To specify the data type of a column, append the column name with :type, where type is the data type of that 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:init,name:text.