Xano (beta)
Connect to your Xano instance to interact with your data in your Softr apps.
Connecting Xano to Softr
1. Login to Xano and click the gear icon next to the server instance you want to connect to Softr.
Note that all workspaces inside an instance will be available inside your Softr apps.
![Click on the gear icon next to the server instance you want to connect to.](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2F06708ae9-1a90-43ab-abb7-4fb2535b7181%2FScreenshot_2024-05-30_at_8.48.02_AM.png?table=block&id=2e0d41e9-ab93-4810-a82a-f498dacad51d&cache=v2)
2. In the menu on the right, select the Database Connector option.
![Select the Database Connector option](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2Faf99c00c-b78e-4bae-a47d-b86f4ea03caa%2FScreenshot_2024-05-30_at_8.51.09_AM.png?table=block&id=251a2981-34da-4302-b01a-50cc3e25d3bd&cache=v2)
3. Click the buttons to get your instance’s public IP and access credentials.
In order for Softr to be able to access your instance, you’ll need to create a publicly accessible IP address and get some credentials so that only those with the credentials can access it.
![Click the GET buttons to generate a public IP and server credentials.](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2F00ed3c9b-8fcb-4994-9487-7652b548adbc%2FScreenshot_2024-05-30_at_9.00.39_AM.png?table=block&id=7854473f-0bab-4d2e-bf65-d0a4ef04cfc0&cache=v2)
4. Copy your credentials to a secure location.
By default your credentials are hidden for security purposes, but you can show or hide them at anytime using the checkbox. Unhide and copy these credentials and save them in a secure place or write them down.
![Click on Show credentials to reveal them](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2Fc5443e1f-b2e9-4544-84d0-d840ff40584e%2FScreenshot_2024-05-30_at_9.06.46_AM.png?table=block&id=a9fda088-d135-4e63-b43b-d64b61a22493&cache=v2)
5. Click on the settings tab, add Softr’s IP addresses, then click Save.
Click on the Settings tab. Click on the + Add button and paste in Softr’s three IP addresses. You can also add any other IPs that need to access your instance here. When finished, make sure to click Save at the bottom of the Setting pane. Softr’s three IP addresses are:
3.120.79.212
3.123.159.186
52.58.246.121
![Click on the settings tab, add Softr’s IP addresses, then click Save.](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2F8854de6f-07bf-4d1e-a84b-d175b8bc1fab%2FScreenshot_2024-05-30_at_10.08.01_AM.png?table=block&id=1311fda1-2202-418d-a6d6-9f388451fef1&cache=v2)
6. Login to Softr and select Data sources on the left-hand menu
![Select Data sources](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2Ff7f9fc46-92be-4c01-a398-fdc57d77dd7b%2FScreenshot_2024-05-30_at_9.15.38_AM.png?table=block&id=5f23e8df-4d54-461a-a238-046fe3b9f66e&cache=v2)
7. Click on Connect Data Source in the upper-right corner
![Click on Connect Datasource](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2F427359d9-2f8b-4af3-b8b7-39d1efb8e4dd%2FScreenshot_2024-05-30_at_9.17.06_AM.png?table=block&id=924db21b-bd59-4b6a-87a6-4e3e66f6216e&cache=v2)
8. Click on Xano
![Click on Xano](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2Ff40fe36d-6ca6-4c4d-b70f-ebd97d577ce2%2FScreenshot_2024-05-30_at_9.18.56_AM.png?table=block&id=907fd204-a3eb-4015-b76d-95d8d3db2e08&cache=v2)
9. Copy the parts of your credentials into the appropriate blanks.
Note that you have Full Access credentials as well as Read-Only credentials so make sure to use the correct ones for your use case. We always recommend using the Full Access credentials so you don’t have to re-authenticate later if you expand your Softr apps’ capabilities. In Xano you have several fields as a part of your credentials:
- User
- Pass
- Host
- Database
These can be put into the corresponding blanks in the Softr setup. The Name field can be anything you like and the Port should always be 5432 for Xano. The rest of the fields can be filled in with the corresponding name, like so:
![Fill in the fields with the parts of your server credentials.](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2Fa9f7cf24-6455-4715-bc35-331c1471a169%2FScreenshot_2024-05-30_at_9.20.51_AM.png?table=block&id=62fc6a3f-580f-45ff-aa20-ed56a71b3743&cache=v2)
10. Click Connect in the lower-right corner of the setup modal
Your end result should look similar to this. Click Connect to complete the data connection setup.
![Click Connect once you’ve pasted in your credentials.](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2F1b491250-413f-4267-b8e1-03aaa1782eae%2FScreenshot_2024-05-30_at_9.32.28_AM.png?table=block&id=cd81fc94-ff50-49c5-8b61-5994abacd45d&cache=v2)
Re-authenticating, removing, and renaming your Xano data source.
As with all data sources in Softr, you can always rename, remove, or edit your data source’s connection by clicking the ellipses (three dots) on the data source itself:
![Click on the three dots to rename, remove, or edit your Xano data source](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F484adde5-19ba-4c92-b797-4cbdd4ad462b%2F6b5c1fd0-fe19-439b-b7ad-5c2f89e0308b%2FScreenshot_2024-05-30_at_9.35.41_AM.png?table=block&id=5adeb3a5-dd3f-4fe0-b188-b272a4031da9&cache=v2)
Last updated on June 4, 2024