Database & Users

Explore the database for your workspace and your published app

Every Riff app includes a built-in PostgreSQL database for persistent data storage, plus integrated user management via Stack Auth.

Click + More and select the Database tab in the workspace top bar.

Key features:

• PostgreSQL database: Full-featured relational database

• Separate environments: Independent databases for development and production

• Migrations: Version-controlled database schema changes

• SQL queries: Run queries directly from the interface

• Schema exploration: Browse tables, columns, and relationships

• User management: Built-in authentication and user tables

How to use:

1. Ask the agent to create database tables for your data needs

2. The agent creates migrations to define the schema

3. Query data using SQL or integrate via Python APIs

4. Migrations automatically apply to production on deployment

Tips:

• Use migrations for all schema changes - they're version controlled

• Development and production databases are separate - test first in dev

• User authentication is pre-configured with Stack Auth

• The file system is not persistent - always use the database for data storage