nocodb

What This Skill Does

The NocoDB skill allows your OpenClaw agent to interact directly with NocoDB instances, which are powerful, open-source alternatives to Airtable. By connecting to your self-hosted instance via a secure API token, the agent can perform full CRUD (Create, Read, Update, Delete) operations on your structured data. This skill effectively turns your NocoDB base into a programmatic database for your agent, allowing it to list bases, inspect table schemas, filter rows using complex criteria, and perform data entry without manual intervention.

Installation

To install this skill, run the following command in your terminal:

clawhub install openclaw/skills/skills/nickian/nocodb

After installation, you must configure your environment variables to allow the agent to authenticate with your NocoDB instance:

1. Set NOCODB_URL to your instance's full URL (e.g., https://nocodb.example.com).
2. Set NOCODB_TOKEN to your API token, which can be generated in the NocoDB dashboard under Team & Settings > API Tokens.

Use Cases

This skill is perfect for automating data-heavy workflows. Use it to:

• Manage project tracking by automatically inserting rows when a task is completed in another system.
• Query inventory or customer data for reports or data-driven insights.
• Act as a knowledge base where the agent retrieves documentation or FAQ entries stored in tables.
• Perform spreadsheet-style lookups, such as finding a user's contact information based on their ID or name.

Example Prompts

1. "Look up the status of the project titled 'Alpha' in the 'Projects' table and tell me the deadline."
2. "Find all rows in the 'Sales' table where the 'Region' is 'West' and the 'Amount' is greater than 5000, then summarize the results."
3. "Add a new record to the 'Inventory' table for an item named 'Mechanical Keyboard' with a stock quantity of 25."

Tips & Limitations

• Case Sensitivity: While base and table names are generally handled case-insensitively, consistency is key for reliability.
• Filtering: Utilize the powerful filter syntax to narrow down large datasets efficiently. Remember that combined filters use the ~and syntax (e.g., (Price,gt,10)~and(Stock,gt,0)).
• Data Structure: Always inspect column schemas using the columns command before attempting to insert data to ensure your JSON keys match the NocoDB column names exactly.
• Limits: When querying large datasets, use the --limit and --offset flags to handle pagination effectively, preventing the agent from becoming overwhelmed by large API responses.