✓ Verified 📊 Data Processing ✓ Enhanced Data

Nocodb

Access and manage NocoDB databases, tables, and records via REST API.

Rating: 4.1 (367 reviews)
Downloads: 3,699 downloads
Version: 1.0.0

Overview

Access and manage NocoDB databases, tables, and records via REST API.

Complete Documentation

View Source →

NocoDB

Manage bases, tables, and rows on a self-hosted NocoDB instance via REST API.

Setup

bash

export NOCODB_URL="https://your-nocodb-instance.com"
export NOCODB_TOKEN="your-api-token"

Get your API token: NocoDB → Team & Settings → API Tokens → Add New Token.

Commands

List bases

bash

{baseDir}/scripts/nocodb.sh bases

List tables in a base

bash

{baseDir}/scripts/nocodb.sh tables --base "Library"
{baseDir}/scripts/nocodb.sh tables --base pz38oanbzcaqfae

Base and table args accept names (case-insensitive) or IDs.

Show columns (schema)

bash

{baseDir}/scripts/nocodb.sh columns --base "Library" --table "Books"

Query rows

bash

{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --limit 10
{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --sort "-CreatedAt"
{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --where "(Title,like,%Preparation%)"
{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --limit 5 --offset 10

Sort: prefix with - for descending. Where: NocoDB filter syntax (Field,op,value).

Get single row

bash

{baseDir}/scripts/nocodb.sh row --base "Library" --table "Books" --id 1

Insert a row

bash

{baseDir}/scripts/nocodb.sh insert --base "Library" --table "Books" --json '{"Title": "New Book", "Publish Date": 2026}'

Pass field values as a JSON object. Check columns first to see available fields.

Filter Operators

Common NocoDB where operators: eq, neq, like, gt, lt, gte, lte, is, isnot, null, notnull.

Combine filters: (Field1,eq,val1)~and(Field2,gt,val2)

Installation

Terminal bash


openclaw install nocodb

Copied!

💻Code Examples

export NOCODB_TOKEN="your-api-token"

export-nocodbtokenyour-api-token.txt

Get your API token: NocoDB → Team & Settings → API Tokens → Add New Token.

## Commands

### List bases

{baseDir}/scripts/nocodb.sh tables --base pz38oanbzcaqfae

basedirscriptsnocodbsh-tables---base-pz38oanbzcaqfae.txt

Base and table args accept names (case-insensitive) or IDs.

### Show columns (schema)

{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --limit 5 --offset 10

basedirscriptsnocodbsh-rows---base-library---table-books---limit-5---offset-10.txt

Sort: prefix with `-` for descending. Where: NocoDB filter syntax `(Field,op,value)`.

### Get single row

example.sh

{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --limit 10
{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --sort "-CreatedAt"
{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --where "(Title,like,%Preparation%)"
{baseDir}/scripts/nocodb.sh rows --base "Library" --table "Books" --limit 5 --offset 10