nocodb

What This Skill Does

The NocoDB skill allows your OpenClaw agent to bridge the gap between AI capabilities and your structured data. By providing a CLI-based interface for the NocoDB REST API, this skill enables the agent to programmatically list, retrieve, update, and manage records across your bases, tables, and views. It acts as a powerful data connector, transforming your NocoDB instance into a database-backed memory bank for your AI workflows. Whether you are managing CRM records, inventory lists, or project tasks, the agent can interact with your data in real-time.

Installation

To integrate this skill, use the ClawHub command: clawhub install openclaw/skills/skills/darkphoenix2704/nocodb-official. Once installed, ensure you have set your NOCODB_TOKEN environment variable. You can retrieve this token via NocoDB's Team & Settings menu. Optionally, set NOCODB_URL if you are hosting a self-hosted instance. Verify your connection by running nc workspace:list to ensure the agent has the correct permissions to traverse your workspace hierarchy.

Use Cases

This skill is ideal for automating data-heavy tasks. You can use it to sync customer inquiries from a messaging platform directly into a NocoDB table, automate the population of lead tracking tables, or query specific records to provide context-aware responses to user questions. For enterprise users, it allows for cross-team collaboration management and programmatic manipulation of view settings, making it a robust solution for operations automation.

Example Prompts

1. "Find the record for 'Acme Corp' in the 'Clients' table within my 'Sales' base and update the status to 'Follow-up Required'."
2. "Can you list all the records in the 'Project Tasks' table under my 'Engineering' base and show me which ones have a priority of 'High'?"
3. "Add a new record to the 'Inventory' table in my 'Warehouse' base with the item name 'Laptop Pro' and a stock level of 50."

Tips & Limitations

Use ID prefixes (e.g., 'p' for base, 'm' for table) to significantly speed up your queries; human-readable names are convenient, but IDs ensure exact targeting. Enable NOCODB_VERBOSE=1 during your initial setup to help the agent discover and cache the correct IDs. Remember that specific features like views, scripts, and team management are strictly gated by the Enterprise plan. Always ensure your token has the minimum necessary scope to perform the required actions to maintain a strong security posture.