Applications you build in Aha! Builder can be backed by a PostgreSQL database. PostgreSQL (also called Postgres) is a relational database that stores data in structured tables and lets you query that data using SQL, a standard query language.
You do not need to set up or configure a database. Aha! Builder provisions one or more databases automatically when you create an application, depending on how much information Elle (the AI assistant) needs to store.
To access it, click Configuration in your application's navigation bar and select the Database tab.
Click any of the following links to skip ahead:
Database page
The database page shows the tables Elle created as part of your application, along with the number of rows in each table. Click a table name to view its columns and data.
This information is generated and maintained by Aha! Builder as you build and refine your application with Elle. You can inspect the structure of your database here — including the tables Elle created and the relationships between them. You can also query your database by clicking Query data.
Preview and production databases
Your application has two separate database environments that correspond to the Preview and Production environments in Aha! Builder. Use the Preview and Production toggle at the top of the page to switch between these environments.
The preview database is a sandbox for building and testing. You can experiment freely without affecting what your users see. When you deploy your application to production, data from Preview does not carry over. The two databases are kept separate intentionally.
Data security and isolation
Your application's database is isolated at both the engine and network levels. Data from one Aha! Builder account is not accessible to another account, and credentials cannot be used across account boundaries. Your application code and all data run on the same AWS infrastructure as other Aha! products.