Direct Database Connector
Establish a direct connection to your instance's PostgreSQL database
Last updated
Was this helpful?
Establish a direct connection to your instance's PostgreSQL database
Last updated
Was this helpful?
Direct Database Connector is available as a paid add-on. Please visit your to add this to your plan.
Database Connector is a premium add-on that is available for Launch and Scale plans. Please visit your Billing page for the most up-to-date pricing for this additional feature.
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.
How to Access the Database Connector
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.
Get your database's public IP
Get your database credentials
Settings Panel
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.
Establishing a Database Connection (Example)
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...
