Establish a direct connection to your instance's PostgreSQL database
Database Connector is a premium add-on only available to Scale+ plans. Please visit your Billing page for the most up-to-date pricing for this additional feature.
On the Scale plan and above, you have the option to connect your Xano instance's PostgreSQL database directly with an external application or service. This can be useful if there is a platform for manipulating your database that you prefer to use over the Xano interface, creating custom backup and restore solutions, or even performing data analytics.
Use care when accessing your database directly. This type of connection removes a significant portion of normal checks and balances for data validity that using Xano directly provides.
Proceed with caution.
On your instance selection screen, click the ⚙️ icon, and in the panel that opens, choose Database Connector.
The panel that opens is split into two sections, Details and Settings.
Details allows you to retrieve the access information for a direct database connection.
Settings allows you to enable and use an allow list, to limit direct database connections to specific IP addresses.
- 1.Get your database's public IP
- 2.Get your database credentials
- 3.Settings Panel
- 4.Add an IP address to your allow list
Clicking both of the "Get" buttons will provide us with the database IP and two sets of credentials, full-access and read-only.
From this panel, you can also revoke and re-generate your database credentials, should the need arise.
You can use any application you'd like that is capable of connecting to a PostgreSQL database. In this example, we'll be using Navicat.
Select 'Connection' in the top-left, and fill in your credentials and the IP recieved from Xano.
Click 'Save' to save the connection. We can now navigate the PostgreSQL database from Xano using Navicat. We can even add / update data, run queries, etc...