1. Download the n8n workflow from the repository<\/h3>\n
\nThe n8n workflow file can be downloaded from here<\/a>.\n<\/p>\n \nOpen the n8n workspace, create a new workflow, and then import the downloaded n8n workflow file.\n<\/p>\n \nIn n8n community edition, you can use the Credentials<\/strong> feature, but it’s still not supported base64 cred encoding, so in our project, we need to set the credentials manually for each HTTP Request.\n<\/p>\n \nHere are the n8n nodes you need to set:\n<\/p>\n \nDouble-click the node and then replace the value after \nIn Mac or Linux, you can use this command to encode username and password using base64 encoding:\n<\/p>\n \nOther than credentials, you also need to change the GridDB Cloud URL in each HTTP Request<\/strong> nodes.\n<\/p>\n \nTo test the workflow, you can run the tests command from this section<\/a>.\n<\/p>\n \nThe project sample in this article is using Node.js. Make sure to install the latest Node.js LTS<\/a> version on your machine.\n<\/p>\n \nIf you would like to sign up for a GridDB Cloud Free instance, you can do so at the following link: https:\/\/form.ict-toshiba.jp\/download_form_griddb_cloud_freeplan_e<\/a>.\n<\/p>\n \nAfter successfully signing up, you will receive a free instance along with the necessary details to access the GridDB Cloud Management GUI, including the GridDB Cloud Portal URL<\/strong>, Contract ID<\/strong>, Login<\/strong>, and Password<\/strong>.\n<\/p>\n \nGo to the GridDB Cloud Portal and copy the WebAPI URL from the Clusters<\/strong> section. It should look like this:\n<\/p>\n \nGo to the GridDB Users<\/strong> section of the GridDB Cloud portal and create or copy the username. The password is set when the user is created for the first time. Use this as the password.\n<\/p>\n \nFor more details, to get started with GridDB Cloud, please follow this quick start guide<\/a>.\n<\/p>\n \nWhen running this project, please ensure that the IP address where the project is running is whitelisted. Failure to do so will result in a 403 status code or forbidden access.\n<\/p>\n \nYou can use a website like What Is My IP Address<\/a> to find your public IP address.\n<\/p>\n \nTo whitelist the IP, go to the GridDB Cloud Admin and navigate to the Network Access<\/strong> menu.\n<\/p>\n \nYou need to run an n8n instance to try the automation workflow. The n8n can be hosted on the cloud or locally. For this article, we will install the n8n community edition locally.\n<\/p>\n \nTo install it, follow these steps:\n<\/p>\n \nGo to the n8n GitHub repository and then clone it. Currently, the latest release version of n8n is 1.113.3.\n<\/p>\n \nThe n8n basically is a runnable npm package, and it needs \nIt’s better to build the n8n first so you will run much faster if you want to run it again at other times.\n<\/p>\n \nOnce the n8n is running, by default, you can access it in the URL \nIf you want to deploy it to the cloud and expose it to the public, there are a few environment variable settings that will override the n8n default settings. Please read their official documentation for deployment<\/a> for more information.\n<\/p>\n \nBefore we dig deeper into the app project, it’s valuable to know what main operations we will use in this n8n automation related to access to the GridDB database.\n<\/p>\n \nThis n8n workflow will check the connection to the GridDB database. It will respond with a \nThe Webhook<\/strong> node is the entry node for automation. In this node, we can set the HTTP operation and authentication. It also gives us a test and production address where the client can access it publicly. For our project, this will be local. For example:\n<\/p>\n \nThe GridDB Check Connection<\/strong> node basically is a GET HTTP call to the GridDB Cloud, another form of this \nFor real production, replace the GridDB cloud address and make sure to encode the username and password into the base64 encoding.\n<\/p>\n \nThe basic \nThe above command can be converted to n8n automation very easily by using the HTTP Request<\/strong> node (using the import cURL<\/strong> button).\n<\/p>\n \nTo create a new container, we can use \nIn the n8n automation workflow, we can put the node after checking the existing container, and if it doesn’t exist, then we can create it.\n<\/p>\n \nTo get data from a known container, we can use this \nThe command uses TQL to select all data from GridDB \nTo get specific data from the GridDB database, for example, by its ID, you can use this \nIn n8n, the \nThere are a few ways to insert data in GridDB using web API endpoints:\n<\/p>\n \nWe will use the \nFrom all the \nShouldn’t there be three nodes?\n<\/p>\n \nIt’s not necessary because the only changing part in the command is the SQL statement, and the other parts are pretty much the same.\n<\/p>\n \nSo, for the user to be able to insert, update, or delete data, the user or client needs to send a SQL statement in the payload data.\n<\/p>\n2. Import the workflow into the n8n dashboard<\/h3>\n
![\"\"](\"\/wp-content\/uploads\/2026\/08\/import-n8n.png\")
<\/a><\/p>\n3. Set up the GridDB credentials<\/h3>\n
\n
Basic<\/code> with your base64 encoding of username and password.\n<\/p>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/basic-creds.png\")
<\/a><\/p>\n$ echo -n 'username:password' | base64<\/code><\/pre>\n<\/div>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/set-griddb-cloud-url.png\")
<\/a><\/p>\nPrerequisites<\/h2>\n
Node.js<\/h3>\n
GridDB<\/h3>\n
Sign Up for GridDB Cloud Free Plan<\/h4>\n
GridDB WebAPI URL<\/h4>\n
![\"\"](\"\/wp-content\/uploads\/2026\/08\/griddb-cloud-portal-scaled.png\")
<\/a><\/p>\nGridDB Username and Password<\/h4>\n
![\"\"](\"\/wp-content\/uploads\/2026\/08\/griddb-cloud-users-scaled.png\")
<\/a><\/p>\nIP Whitelist<\/h4>\n
![\"\"](\"\/wp-content\/uploads\/2026\/08\/ip-whitelist-scaled.png\")
<\/a><\/p>\nInstall n8n on Local Machine<\/h3>\n
1. Clone the source code<\/h4>\n
$ git clone --branch 1.113.3 https:\/\/github.com\/n8n-io\/n8n.git<\/code><\/pre>\n<\/div>\n2. Install deps<\/h4>\n
pnpm<\/code> to build and run.\n<\/p>\n$ cd n8n\r\n$ pnpm install<\/code><\/pre>\n<\/div>\n3. Build and run<\/h4>\n
pnpm build\r\npnpm run dev<\/code><\/pre>\n<\/div>\nhttp:\/\/localhost:5678<\/code>.\n<\/p>\nProject<\/h2>\n
Setup GridDB Connection<\/h3>\n
200<\/code> HTTP status code if the connection is successful.\n<\/p>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/griddb-check-connection.png\")
<\/a><\/p>\n$ http:\/\/localhost:5678\/webhook\/35f92470-024d-49da-8c2f-63a2f212e639<\/code><\/pre>\n<\/div>\ncurl<\/code> command:\n<\/p>\n$ curl -i --location --request GET 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/checkConnection' --header 'Authorization: Basic base64(username:password)'<\/code><\/pre>\n<\/div>\nCheck containers<\/h3>\n
curl<\/code> command to check the existing containers in GridDB is as follows:\n<\/p>\n$ curl -i --location --request GET 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/containers?limit=100' --header 'Authorization:Basic base64(username:password)' --header 'Content-Type: application\/json<\/code><\/pre>\n<\/div>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/check-containers.png\")
<\/a><\/p>\nCreate containers<\/h3>\n
curl<\/code> directly as long as we have the right credentials. Ok, now let’s create a container named “pokemon”:\n<\/p>\n$ curl -i --location --request POST \\\r\n$ 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/containers' \\\r\n$ --header 'Authorization: Basic base64(username:password)' \\\r\n$ --header 'Content-Type: application\/json' \\\r\n$ --data '{\r\n$ "container_name": "pokemon",\r\n$ "container_type": "COLLECTION",\r\n$ "rowkey": true,\r\n$ "columns": [\r\n$ {"name": "id", "type": "INTEGER", "index": []},\r\n$ {"name": "name", "type": "STRING", "index": []},\r\n$ {"name": "skills", "type": "STRING", "index": []},\r\n$ {"name": "level", "type": "STRING", "index": []}\r\n$ ]\r\n$ }'<\/code><\/pre>\n<\/div>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/create-container.png\")
<\/a><\/p>\nGet all data<\/h3>\n
curl<\/code> command to get all data:\n<\/p>\n$ curl -i --location --request POST 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/tql\/' --header 'Authorization: Basic base64(username:password)' --header 'Content-Type: application\/json' --data '[{"name":"pokemon","stmt":"select * limit 10","columns":null,"hasPartialExecution":true}]'<\/code><\/pre>\n<\/div>\npokemon<\/code> container. As with the other operations, the read data can also be easily implemented in the n8n using the HTTP Request<\/strong> node.\n<\/p>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/get-data.png\")
<\/a><\/p>\nGet Specific Data<\/h3>\n
curl<\/code> command:\n<\/p>\n$ curl -i --location --request POST \\\r\n$ 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/tql\/' \\\r\n$ --header 'Authorization: Basic base64(username:password)' \\\r\n$ --header 'Content-Type: application\/json' \\\r\n$ --data '[{"name":"pokemon","stmt":"select * where id = 4167 limit 100","columns":null,"hasPartialExecution":true}]'<\/code><\/pre>\n<\/div>\ncurl<\/code> can also be easily converted into the n8n node using the HTTP Request<\/strong> node.\n<\/p>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/get-data-by-id.png\")
<\/a><\/p>\nInsert, Update, and Delete data<\/h3>\n
\n
\/sql\/dml\/update<\/code>: accepts any SQL DML (INSERT\/UPDATE\/DELETE).<\/li>\n\/tql\/<\/code>: processes TQL statements, including PUT (…) for row upserts and SELECT queries.<\/li>\n\/containers\/\/sql\/dml\/update<\/code> in this n8n automation because we will support 3 data operations, which are: INSERT<\/strong>, UPDATE<\/strong>, and DELETE<\/strong>.\n<\/p>\nInsert<\/h4>\n
$ curl -i --location --request POST 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/sql\/dml\/update' --header 'Authorization: Basic base64(username:password)' --header 'Content-Type: application\/json' --data "[{\\"stmt\\":\\"INSERT INTO pokemon(id, name, skills, level) VALUES (26, 'Charmander', 'Flamethrower,Dragon Breath', 'Starter')\\"}]"<\/code><\/pre>\n<\/div>\nUpdate<\/h4>\n
$ curl -i --location --request POST 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/sql\/dml\/update' --header 'Authorization: Basic base64(username:password)' --header 'Content-Type: application\/json' --data "[{\\"stmt\\":\\"UPDATE pokemon SET level = 'Master' WHERE id = 25\\"}]"<\/code><\/pre>\n<\/div>\nDelete<\/h4>\n
$ curl -i --location --request POST 'https:\/\/cloud5197.griddb.com:443\/griddb\/v2\/cluster-name\/dbs\/db-name\/sql\/dml\/update' --header 'Authorization: Basic base64(username:password)' --header 'Content-Type: application\/json' --data "[{\\"stmt\\":\\"DELETE FROM pokemon WHERE id = 26\\"}]"<\/code><\/pre>\n<\/div>\ncurl<\/code> commands above, each can be easily converted into the n8n node using the HTTP Request<\/strong> node, or we can use just one n8n node and make the stmt<\/code> a variable.\n<\/p>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/insert-update-delete.png\")
<\/a><\/p>\nFull n8n Workflow<\/h2>\n
![\"\"](\"\/wp-content\/uploads\/2026\/08\/n8n-griddb-pokemon-all.png\")
<\/a><\/p>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/webhook.png\")
<\/a><\/p>\n![\"\"](\"\/wp-content\/uploads\/2026\/08\/n8n-logs.png\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"