NocoDB Skill
CLI wrapper for NocoDB API v3. Supports both NocoDB Cloud (app.nocodb.com) and self-hosted instances.
NocoDB is an open-source Airtable alternative that turns any database into a smart spreadsheet. This skill provides complete access to NocoDB's REST API for managing workspaces, bases, tables, records, and more.
Setup
Required Environment Variables
CODEBLOCK0
Getting Your API Token
- 1. Open NocoDB dashboard
- Go to Team & Settings → API Tokens
- Click Add New Token
- Copy the token and set it as INLINECODE0
Verification
Test your connection:
CODEBLOCK1
Quick Start
CODEBLOCK2
Usage
The skill provides the nc command with a hierarchical structure:
CODEBLOCK3
Identifier Formats
You can use names (human-readable) or IDs (faster performance):
| Resource | ID Prefix | Example |
|---|
| Workspace | INLINECODE2 | INLINECODE3 |
| Base |
p |
pdef456uvw |
| Table |
m |
mghi789rst |
| Field |
c |
cjkl012opq |
| View |
vw |
vwmno345abc |
Tip: Use IDs directly for better performance. Set NOCODB_VERBOSE=1 to see ID resolution in action.
Commands
Workspaces
Note: Workspace APIs require Enterprise plan (self-hosted or cloud-hosted).
CODEBLOCK4
Workspace Collaboration (Enterprise):
CODEBLOCK5
Bases
CODEBLOCK6
Base Collaboration (Enterprise):
CODEBLOCK7
Tables
CODEBLOCK8
Fields
CODEBLOCK9
Field Types:
- -
SingleLineText, LongText, Number, Decimal, Currency, INLINECODE18 - INLINECODE19 ,
URL, INLINECODE21 - INLINECODE22 ,
DateTime, INLINECODE24 - INLINECODE25 , INLINECODE26
- INLINECODE27 , INLINECODE28
- INLINECODE29 ,
Links, User, INLINECODE32
Views
Note: View APIs require Enterprise plan.
CODEBLOCK10
View Types: grid, gallery, kanban, calendar, INLINECODE37
Records
CODEBLOCK11
Pagination Parameters:
- -
page: Page number (default: 1) - INLINECODE39 : Records per page (default: 25)
- INLINECODE40 : Filter expression (see Filter Syntax)
- INLINECODE41 : Sort expression (see Sort Syntax)
- INLINECODE42 : Comma-separated field names to return
- INLINECODE43 : Filter by view
Linked Records
CODEBLOCK12
Filters & Sorts
View-level Filters:
CODEBLOCK13
View-level Sorts:
CODEBLOCK14
Attachments
CODEBLOCK15
Scripts (Enterprise)
CODEBLOCK16
Teams (Enterprise)
CODEBLOCK17
API Tokens (Enterprise)
CODEBLOCK18
Filter Syntax
Basic Syntax
CODEBLOCK19
Operators
| Operator | Description | Example |
|---|
| INLINECODE44 | Equal | INLINECODE45 |
| INLINECODE46 |
Not equal |
(status,neq,archived) |
|
like | Contains (% wildcard) |
(name,like,%john%) |
|
nlike | Does not contain |
(name,nlike,%test%) |
|
in | In list |
(status,in,active,pending) |
|
gt | Greater than |
(price,gt,100) |
|
lt | Less than |
(stock,lt,10) |
|
gte | Greater or equal |
(rating,gte,4) |
|
lte | Less or equal |
(age,lte,65) |
|
blank | Is null/empty |
(notes,blank) |
|
notblank | Is not null/empty |
(email,notblank) |
|
null | Is null |
(deleted_at,null) |
|
notnull | Is not null |
(created_by,notnull) |
|
checked | Is checked/true |
(is_active,checked) |
|
notchecked | Is not checked/false |
(is_archived,notchecked) |
Logical Operators
Important: Use tilde prefix (~and, ~or, ~not)
CODEBLOCK20
Date Filters
CODEBLOCK21
Complex Examples
CODEBLOCK22
Sort Syntax
CODEBLOCK23
Plan Requirements
Free Plans: Base, Table, Field, Record, Link, Attachment, Filter, Sort APIs
Enterprise Plans (self-hosted or cloud-hosted):
- - Workspace and Workspace Collaboration APIs
- View APIs
- Script APIs
- Team APIs
- API Token APIs
- Base Collaboration APIs
Examples
Basic Queries
CODEBLOCK24
Filtering
CODEBLOCK25
Sorting
CODEBLOCK26
Creating Data
CODEBLOCK27
Updating Data
CODEBLOCK28
Working with Linked Records
CODEBLOCK29
Using Views
CODEBLOCK30
Uploading Files
CODEBLOCK31
Troubleshooting
Connection Issues
CODEBLOCK32
Verbose Mode
Enable verbose output to see resolved IDs:
CODEBLOCK33
Common Errors
| Error | Solution |
|---|
| INLINECODE77 | Set the environment variable |
| INLINECODE78 |
Check workspace name or use ID |
|
base not found | Check base name or use ID |
|
table not found | Check table name or use ID |
|
401 Unauthorized | Check your API token |
Help
Show complete command reference:
CODEBLOCK34
Show filter syntax help:
CODEBLOCK35
Resources
- - NocoDB Documentation: https://docs.nocodb.com/
- API Reference: https://docs.nocodb.com/developer-resources/rest-APIs/
- GitHub: https://github.com/nocodb/nocodb
License
This skill wraps the NocoDB API. NocoDB is open-source under the AGPL-3.0 license.
