Database

Browse your app's built-in database tables and inspect data — and ask the Riff agent to create, query, update, or delete records directly.

Every Riff app includes a built-in PostgreSQL database. The Database tab lets you browse your tables and inspect rows. The Riff agent can interact with the database directly on your behalf.

What you can see

Capability	Detail
Table browser	View all tables in your database
Data inspection	Browse rows in any table — useful for verifying data your app has written
Environment switcher	Toggle between your development (Workspace) and production (Deployed) database

What the Riff agent can do

The Riff agent has direct tools to work with your database. You can ask it to:

• Create records — "Add ten sample purchase orders to the database so I can test the dashboard"

• Read and analyse data — "How many invoices are in an open state right now?" or "Show me the last 5 supplier records that were updated"

• Update records — "Set the status of PO-1042 to Confirmed"

• Delete records — "Remove the test data we created earlier"

• Generate synthetic data — "Populate the supplier table with 20 realistic test entries"

This means you rarely need to write SQL yourself. Ask the Riff agent what you need and it will handle the database interaction.

Notes

• The tab shows your development database by default. Switch to production using the environment dropdown when you need to inspect live data.

• All schema changes (adding tables, columns, migrations) should be done by asking the Riff agent — it creates version-controlled migrations automatically.