Effortless NocoDB Table Cloning: Automate to New Base

Streamline your NocoDB database management with this powerful automation that clones complete table structures and data between bases in minutes, not hours. Perfect for developers and data engineers who need reliable, repeatable table duplication without manual export/import workflows.

What This Workflow Does

This n8n automation leverages the NocoDB v3 API to perform intelligent table cloning across different bases. The workflow operates in two distinct phases: first, it fetches complete table metadata including field names, types, and configurations from your source tables. Then it creates exact replicas in your destination base, automatically appending timestamps to prevent naming conflicts (e.g., "Invoices - Copy 2025-04-28 14:32:00").

The system intelligently handles data relationships by excluding complex field types like Links, Lookup, LinkToAnotherRecord, ForeignKey, and ID fields during the copy process, ensuring clean, functional table duplicates every time.

Use Cases

• Environment Management: Clone production tables to staging or development bases for safe testing
• Backup Creation: Generate timestamped table snapshots before risky data migrations or schema changes
• Template Deployment: Duplicate standardized table structures across new project bases
• Multi-Environment Workflows: Automate data promotion through development → staging → production pipelines
• Project Scaffolding: Quickly establish new NocoDB bases with proven table architectures

Technical Details

Built using core n8n nodes including HTTP Request for NocoDB API calls, Set nodes for data transformation, Switch nodes for conditional logic, and Split Out nodes for batch processing. The workflow triggers manually and processes multiple table IDs simultaneously through efficient API interactions.

Designed specifically for NocoDB power users, data engineers, and automation specialists who manage complex multi-base environments and require programmatic control over their database architecture without UI dependencies.