Kaggle and Postgres integration
How to connect Kaggle and Postgres
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Build your own Kaggle and Postgres integration
Create custom Kaggle and Postgres workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Supported API Endpoints for Kaggle
List competitions
List available competitions
List competition files
List competition files
Download competition files
Download competition files
Submit to a competition
Make a new competition submission
List competition submissions
Show your competition submissions
List datasets
List available datasets.
List files
List dataset files.
Download dataset files
Download dataset files.
Create dataset
Create a new dataset after initializing metadata.
Create dataset version
Create a new version of an existing dataset with version notes.
Download metadata
Download metadata for an existing dataset using its URL suffix.
Get dataset creation status
Get the status of the dataset creation process using its URL suffix.
List kernels
List available kernels based on specified filters.
Initialize kernel metadata
Initialize metadata for a new kernel setup.
Push code to kernel
Push new code to a kernel and execute it.
Pull code from kernel
Pull down the latest code from a kernel.
Get kernel output
Retrieve data output from the latest run of a kernel.
Get kernel run status
Display the status of the latest kernel run.
Get model
Retrieve a specific model using its URL suffix.
List models
Get a list of models with optional sorting and filtering.
Initialize model metadata
Create a metadata file for a new model.
Create model
Create a new model with specified metadata.
Delete model
Delete a model using its URL suffix.
Update model
Update a model by fetching its metadata file first.
Get model instance
Retrieve a model instance using its URL suffix.
Initialize model instance
Initialize a metadata file for creating a model instance.
Create model instance
Create a new model instance after initializing metadata file.
Delete model instance
Delete a model instance using its URL suffix.
Update model instance
Update a model instance after fetching its metadata file.
Create model version
Create a new version for a model instance.
Download model instance version
Download a model instance version using its specific URL suffix.
Delete model instance
Delete a model instance version using its specific URL suffix.
View current config values
View the current configuration values set in the system.
Set a configuration value
Set a new value for a specific configuration parameter.
Clear a configuration value
Clear an existing configuration value by name.
To set up Kaggle integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Kaggle to query the data you need using the API endpoint URLs you provide.
See the example hereThese API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Kaggle official documentation to get a full list of all API endpoints and verify the scraped ones!
Postgres supported actions
Delete
Delete an entire table or rows in a table
Execute Query
Execute an SQL query
Insert
Insert rows in a table
Insert or Update
Insert or update rows in a table
Select
Select rows from a table
Update
Update rows in a table
Kaggle and Postgres integration details
Other integrations with Postgres
Kaggle and Postgres integration tutorials
How to export data from PostgreSQL to CSV
CSV is a universally accepted and easy-to-read format to interpret data, and PostgreSQL is one of the most popular relational databases. Read on to learn how to export PostgreSQL as a CSV file using the COPY command, \copy command, and n8n.
How to import CSV into PostgreSQL
PostgreSQL remains one of the most popular relational database options among data enthusiasts. Read on to learn how to import a CSV file into PostgreSQL using pgAdmin, SQL statements, and n8n.
Database activity monitoring: How to automatically monitor and set alerts for a database
Learn what database activity monitoring is, why it's important, and how to automatically monitor a Postgres database containing IoT data with n8n workflows.
Automate your data processing pipeline in 9 steps
Learn how to build an n8n workflow that processes text, stores data in two databases, and sends messages to Slack.
FAQ
Can Kaggle connect with Postgres?
Can I use Kaggle’s API with n8n?
Can I use Postgres’s API with n8n?
Is n8n secure for integrating Kaggle and Postgres?
How to get started with Kaggle and Postgres integration in n8n.io?
Need help setting up your Kaggle and Postgres integration?
Discover our latest community's recommendations and join the discussions about Kaggle and Postgres integration.
Postgres node IN operator with parameters
Mikhail Savenkov
Describe the problem/error/question Postgres node is not working with IN Operator when the parameters is an Array. I suppose that’s because of the sanity checks. E.g. I have a list of some workflows that I’m returning v…
Open topic
Passing an array as query parameter in Postgresql
Honza Pav
Hello, I have a follow-up question related to a topic that has been discussed but is closed: Postgres use array as a query parameters I want to pass an array into a Postgresql query as a query parameter. Ideally, I woul…
Open topic
Self-Hosted n8n 1.59.3 does not have Postgres PGVector Store and Postgres Chat Memory nodes
Vyacheslav Karbovnichy
Describe the problem/error/question I have set up local n8n (latest stable v1.59.3) and wanted to try the solution from here https://www.youtube.com/watch?v=PEI_ePNNfJQ but when importing that workflow locally I have so…
Open topic
Node does not return "enough items"
Dennis
Hey everyone, I have the following problem & one question. Problem I have an HTTP request and a split. The split node correctly splits the HTTP into 10 items. But the Postgres only returns 1 item. No matter what, which…
Open topic
Sudden Spike in Database Request
Dennis
Hey everyone, I love N8N so far; as a newbie when it comes to databases and development, I am happy for this awesome solution. Situation I am, at best, an intermediate coder. Right now we are building an MVP, before h…
Open topic
Looking to integrate Kaggle and Postgres in your company?
The world's most popular workflow automation platform for technical teams including
Why use n8n to integrate Kaggle with Postgres
Build complex workflows, really fast
