If you want to redirect to pages from within a Skuid page it's best practice to use a relative url because Skuid "knows" your salesforce url. For example, if you want to go to another Skuid page you can redirect to /apex/UI?page=SkuidPageName and you'll be redirected to that page within the org you're in. You can use a similar template for redirecting to standard pages; for example, I can redirect to /006/o to go to the Salesforce standard opportunities list page. By doing this you won't have to change redirect URLs when you change from a sandbox to production, as long as your Skuid page names that you redirect to are the same. Does that help?