You can query your application's PostgreSQL database directly from Aha! Builder — in plain language or with SQL.
To do this, click Configuration in your application's navigation bar, select the Database tab, and click Query data.
Queries run against the environment you have selected: Preview or Production. Use the toggle at the top of the Configuration page to switch between them.
Click any of the following links to skip ahead:
Query in plain words
Use the In plain words tab to describe what you want to find using natural language. For example, type a request like "Show me all users who signed up last week" and click Show results. Aha! Builder translates your description into a database query and returns matching results. Click AI generated query to see the query it generated.
This is useful when you want to explore your data quickly without writing SQL.
Query with SQL
Use the Advanced (SQL) tab to write SQL queries directly against your application's database. Type your query and click Show results to see the output.
Use this option when you need precise control over the data you retrieve — for example, when joining multiple tables, filtering by specific conditions, or aggregating results.