NocoDB MCP Server

# NocoDB API v2/v3 Migration & Integration Plan ## Current Situation - **NocoDB Version**: Running v2 on `nocodb.v1su4.com` - **Official API**: Website shows v2 and v3 (v1 no longer documented) - **Storage**: No storage configured - need MinIO S3 at `minio-api.v1su4.com` - **Integration**: Need seamless integration with n8n at `n8n.v1su4.com` - **Current Code**: Using API v1 endpoints (needs update) ## Critical Updates Required ### 1. API Version Migration (URGENT) **Current Implementation (v1):** ``` /api/v1/db/meta/projects /api/v1/db/meta/projects/{project_id}/tables /api/v1/db/data/noco/{project_id}/{table_id} ``` **Need to Update to v2/v3:** - Check which version your instance supports - Update all endpoint paths in `nocodb_mcp_server.py` - Verify authentication still uses `xc-token` header ### 2. MinIO S3 Storage Configuration **Required Environment Variables for NocoDB:** ```bash # MinIO S3 Configuration NC_S3_BUCKET_NAME=nocodb-storage NC_S3_REGION=us-east-1 # or your region NC_S3_ENDPOINT=https://minio-api.v1su4.com NC_S3_ACCESS_KEY=your_minio_access_key NC_S3_ACCESS_SECRET=your_minio_secret_key NC_S3_FORCE_PATH_STYLE=true # Required for MinIO NC_S3_ACL=public-read # or private based on your needs ``` **MinIO Bucket Setup:** 1. Create bucket in MinIO: `nocodb-storage` 2. Set appropriate permissions 3. Configure CORS if needed for web access ### 3. n8n Integration Requirements **n8n NocoDB Node Configuration:** - **Host**: `https://nocodb.v1su4.com` - **API Token**: Same token used by MCP server - **API Version**: Must match NocoDB instance (v2/v3) **Workflow Considerations:** - Ensure n8n can access NocoDB API - Verify network connectivity between services - Test data flow in both directions ## Action Items ### Phase 1: Verify Current API Version 1. [ ] Check NocoDB instance version at `nocodb.v1su4.com` 2. [ ] Access Swagger UI to see available API versions 3. [ ] Test v1, v2, and v3 endpoints to see which work 4. [ ] Document which version is actually available ### Phase 2: Update Code for v2/v3 1. [ ] Update `nocodb_mcp_server.py` to use correct API version 2. [ ] Update endpoint paths (projects → bases, etc.) 3. [ ] Test all MCP tools with new endpoints 4. [ ] Update documentation with new endpoints ### Phase 3: Configure MinIO S3 Storage 1. [ ] Set up MinIO bucket for NocoDB 2. [ ] Add S3 environment variables to NocoDB in Coolify 3. [ ] Test file uploads/attachments work with S3 4. [ ] Verify storage is persistent ### Phase 4: n8n Integration 1. [ ] Configure NocoDB credentials in n8n 2. [ ] Test n8n → NocoDB workflows 3. [ ] Test NocoDB → n8n webhooks/triggers 4. [ ] Document integration patterns ## API Endpoint Mapping ### v1 → v2/v3 Changes (Expected) **Meta APIs:** - v1: `/api/v1/db/meta/projects` - v2/v3: `/api/v2/meta/bases` or `/api/v3/meta/bases` (projects → bases) **Tables:** - v1: `/api/v1/db/meta/projects/{project_id}/tables` - v2/v3: `/api/v2/meta/bases/{base_id}/tables` or similar **Records:** - v1: `/api/v1/db/data/noco/{project_id}/{table_id}` - v2/v3: `/api/v2/tables/{table_id}/records` or `/api/v3/tables/{table_id}/records` **Note**: Exact endpoint structure needs verification from your instance's Swagger UI ## Testing Checklist ### API Version Testing - [ ] Test v1 endpoints (may still work for backward compatibility) - [ ] Test v2 endpoints - [ ] Test v3 endpoints - [ ] Document which version(s) work ### Storage Testing - [ ] Upload file via NocoDB UI - [ ] Verify file appears in MinIO bucket - [ ] Test file retrieval - [ ] Verify persistence after container restart ### n8n Integration Testing - [ ] Create workflow that reads from NocoDB - [ ] Create workflow that writes to NocoDB - [ ] Test webhook triggers from NocoDB - [ ] Verify data consistency ## Next Steps 1. **Immediate**: Check Swagger UI at `https://nocodb.v1su4.com/api/v2/swagger` or `/api/v3/swagger` 2. **Update Code**: Modify `nocodb_mcp_server.py` once we know which API version works 3. **Configure Storage**: Add MinIO S3 configuration to NocoDB 4. **Test Integration**: Verify n8n can connect and work with NocoDB ## Resources - **NocoDB API v2/v3 Docs**: https://nocodb.com/apis/v3/ - **MinIO Documentation**: https://min.io/docs/ - **n8n NocoDB Node**: https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.nocodb/ - **NocoDB Storage Config**: https://nocodb.com/docs/self-hosting/environment-variables