A powerful CLI wrapper for NocoDB that enables AI agents to manage databases and spreadsheets as code.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install nocodb-api
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install nocodb-api using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is NocoDB?
The NocoDB skill provides a comprehensive bridge between AI agents and NocoDB instances, whether cloud-based or self-hosted. As an open-source Airtable alternative, NocoDB turns any database into a smart spreadsheet, and this skill for Openclaw Skills makes those capabilities accessible via a structured CLI. It supports the full lifecycle of data management, from creating workspaces and bases to handling complex record queries and schema modifications using the REST API v3.
NocoDB Use Cases
- Synchronizing data between external services and NocoDB bases using automated agents.
- Building automated reporting dashboards by querying records with advanced logical filters.
- Rapidly prototyping database schemas and managing tables through CLI commands.
- Managing file attachments and linked records programmatically within a spreadsheet interface.
- Facilitating team collaboration through automated member and role management in Enterprise environments.
How NocoDB Works
- Authentication is established by setting the NOCODB_TOKEN and optional NOCODB_URL for the target instance.
- The skill uses the nc command to traverse the platform hierarchy from workspaces down to individual records.
- Requests are sent to the NocoDB REST API v3, supporting both standard operations and enterprise-exclusive endpoints.
- Data is fetched or modified based on user-defined parameters such as complex filter expressions and sort objects.
- Structured JSON responses are returned, ensuring the data is ready for further processing by other Openclaw Skills in your workflow.
NocoDB Setup
To begin using NocoDB with Openclaw Skills, configure your environment with the following variables:
export NOCODB_TOKEN="your-api-token"
# Required: Set to your instance URL (defaults to cloud)
export NOCODB_URL="https://app.nocodb.com"
Retrieve your token from the NocoDB dashboard under Team & Settings -> API Tokens. Once configured, verify your connection by listing available workspaces:
nc workspace:list
NocoDB Data Schema & Taxonomy
The NocoDB skill organizes data according to the platform's relational structure. Users can reference entities by human-readable names or by their unique ID prefixes for faster resolution within Openclaw Skills workflows.
| Entity | ID Prefix | Example |
|---|---|---|
| Workspace | w | wabc123xyz |
| Base | p | pdef456uvw |
| Table | m | mghi789rst |
| Field | c | cjkl012opq |
| View | vw | vwmno345abc |
Record data is processed as JSON objects, typically containing a fields key with key-value pairs representing the table columns.
NocoDB Advanced Features
- Robust filter syntax supporting advanced logical operators like ~and, ~or, and ~not for precise data extraction.
- Full support for many-to-many and one-to-many linked record relationships to manage complex data structures.
- Automated file attachment uploads directly to table fields using local file paths.
- Enterprise-tier capabilities including automated view management, script execution, and team permission controls.
- High-performance ID resolution mode enabled via the NOCODB_VERBOSE flag for building efficient Openclaw Skills automations.
SKILL.md
Loading
Related Openclaw Skills
Project Assistant
A comprehensive project lifecycle tool for AI agents that handles initialization, architectural analysis, and automated Q&A documentation across 50+ project types.
Resize and Move Partition Coach
An AI-driven coach for safely resizing and moving disk partitions to reclaim storage and fix low disk space issues.
pokerclaw
An autonomous Texas Hold'em poker agent skill for the POKERCLAW platform that enables AI-driven strategic play against other bots.
OpenClaw Setup Assistant
An automated assistant designed to streamline the installation, configuration, and maintenance of the OpenClaw environment.
OpenClaw Security Suite
A comprehensive security layer for Openclaw Skills that combines static analysis and AI-driven behavioral code review.
Add Directories
An automated pipeline to discover, classify, and submit your product to AI and startup directories via URLs, text, or GitHub lists.
Featured*
