Nocodb Self Host : No-code Databasefor n8n Self Host

This is an n8n community node. It lets you use Nocodb Self Host in your n8n workflows.

Description

n8n is a fair-code licensed workflow automation platform.

Table of Contents

• Installation
• Prerequisites
• Operations
• Credentials Setup
• Usage Examples
• API Reference
• Troubleshooting
• Resources

Installation

Follow the installation guide in the n8n community nodes documentation.

Operations

The following operations are supported by the Nocodb Self Host node:

Get All Rows

Retrieves all rows from a NocoDB table in structured JSON format with metadata.

Features:

• ✅ Get all rows from NocoDB table
• ✅ Manual Base ID and Table ID input for reliability
• ✅ Compatible with NocoDB v1 API
• ✅ Self-hosted NocoDB instances support
• ✅ Structured JSON output with metadata

Output Format:

Data is returned as a structured JSON object with metadata and clean data array:

{
  "success": true,
  "operation": "get-all-rows",
  "metadata": {
    "source": "nocodb",
    "baseId": "pnnh9o17by6p172",
    "tableId": "mbjxj9y2vmg5vc3",
    "timestamp": "2025-07-03T16:46:00.371Z",
    "totalRows": 5,
    "pageInfo": {
      "totalRows": 5,
      "page": 1,
      "pageSize": 25,
      "isFirstPage": true,
      "isLastPage": true
    }
  },
  "data": [
    {
      "Instance ID": "3DD4FE2D0739E005C47896155CBF9532",
      "Token": "735DC91EB86E973F505F9CE4",
      "Client Token": "Fae8d38fba15747b78692ccdb76e817ebS",
      "Name": "Hakim-Iphone Sendiri",
      "Product ID": "LG",
      "Id": 5,
      "CreatedAt": "2025-04-20 01:30:22+00:00",
      "UpdatedAt": "2025-07-03 08:24:26+00:00"
    }
  ]
}

How to Use:

1. Enter your NocoDB Token and Base URL
2. Enter Base ID (found in your NocoDB URL)
3. Enter Table ID (found in your NocoDB URL)

How to find Base ID and Table ID:

• Base ID: In your NocoDB URL, it's the part after /dashboard/: https://your-nocodb.com/dashboard/{BASE_ID}
• Table ID: When viewing a table, it's in the URL: https://your-nocodb.com/dashboard/{BASE_ID}/table/{TABLE_ID}

INFO : For more information about Nocodb Self Host, please visit https://nocodb.com

Resources

• n8n community nodes documentation