NocoDB MCP Server

# API v2 Migration Summary ## Changes Made ### ✅ Code Updates (nocodb_mcp_server.py) **All endpoints updated from v1 to v2:** 1. **Meta APIs:** - ❌ Old: `/api/v1/db/meta/projects` - ✅ New: `/api/v2/meta/bases` 2. **Tables:** - ❌ Old: `/api/v1/db/meta/projects/{project_id}/tables` - ✅ New: `/api/v2/meta/bases/{base_id}/tables` 3. **Records:** - ❌ Old: `/api/v1/db/data/noco/{project_id}/{table_id}` - ✅ New: `/api/v2/tables/{table_id}/records` (no base_id needed) 4. **Record Operations:** - Create: `/api/v2/tables/{table_id}/records` - Update: `/api/v2/tables/{table_id}/records/{record_id}` - Delete: `/api/v2/tables/{table_id}/records/{record_id}` ### Key Differences in API v2 1. **Projects → Bases**: In API v2, "projects" are called "bases" 2. **Simplified Record Endpoints**: Record operations don't require base_id, only table_id 3. **Backward Compatibility**: Tool parameters still accept `project_id` (treated as base_id) ### Authentication - ✅ Still uses `xc-token` header (unchanged) - ✅ API tokens work the same way ## Testing Required 1. [ ] Test `nocodb_test_connection()` - Verify it lists bases correctly 2. [ ] Test `nocodb_list_projects()` - Verify it returns bases 3. [ ] Test `nocodb_list_tables()` - Verify it works with base_id 4. [ ] Test `nocodb_get_records()` - Verify records endpoint works 5. [ ] Test `nocodb_create_record()` - Verify record creation 6. [ ] Test `nocodb_update_record()` - Verify record updates 7. [ ] Test `nocodb_delete_record()` - Verify record deletion 8. [ ] Test `nocodb_search_records()` - Verify search functionality 9. [ ] Test `nocodb_create_discord_reactions_table()` - Verify table creation 10. [ ] Test `nocodb_get_analytics()` - Verify analytics work ## Next Steps 1. **Deploy Updated Code**: Build and deploy new version with API v2 2. **Test All Tools**: Verify all MCP tools work with your NocoDB v2 instance 3. **Update n8n**: Ensure n8n workflows use API v2 (n8n v0.200.0+ supports v2) 4. **Configure MinIO**: Set up S3 storage for NocoDB (see MINIO_S3_CONFIGURATION.md) ## Compatibility Notes - **n8n Integration**: n8n v0.200.0+ supports NocoDB API v2 - **Backward Compatibility**: Tool function signatures unchanged (project_id still accepted) - **Response Format**: Responses include both `base_id` and `project_id` for compatibility ## Version Info - **Server Version**: 1.2.0 - **API Version**: v2 - **NocoDB Version Required**: v2+ - **n8n Compatibility**: v0.200.0+