# Nocodb Self Host : No-code Databasefor n8n Self Host

![npm version](https://img.shields.io/npm/v/n8n-nodes-nocodb-self-host)
![npm downloads](https://img.shields.io/npm/dm/n8n-nodes-nocodb-self-host)
![license](https://img.shields.io/npm/l/n8n-nodes-nocodb-self-host)

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

## Description

[n8n](https://n8n.io/) is a [fair-code licensed](https://docs.n8n.io/reference/license/) workflow automation platform.

## Table of Contents

- [Installation](#installation)
- [Prerequisites](#prerequisites)
- [Operations](#operations)
- [Credentials Setup](#credentials-setup)
- [Usage Examples](#usage-examples)
- [API Reference](#api-reference)
- [Troubleshooting](#troubleshooting)
- [Resources](#resources)

## Installation

Follow the [installation guide](https://docs.n8n.io/integrations/community-nodes/installation/) 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:
```json
{
  "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](https://docs.n8n.io/integrations/community-nodes/)