Skip to main content
The Database module provides structured data storage for your project. It allows you to view, manage, and export the data your project generates, and serves as the foundation for most data-driven features in YouBase.

Data Storage

Persistent, structured storage for your project data

Export & Backup

Download your data anytime for backup or analysis

Time Travel

Restore your database to any previous state

Tables Overview

The table list shows all database tables in your project. Once data is available, the table list displays:
  • All tables in the project
  • The total number of rows in each table
  • The latest autosave status
When the database contains data, the autosave status appears at the top: “Autosaved: just now · Time Travel”. Selecting Time Travel opens the database history and restore view.

Table List Capabilities

From the table list, you can:

View Tables

See all tables and their row counts

Copy Names

Copy table names by hovering over them

Refresh Data

Refresh the table list to load the latest data

Exporting the Database

You can export all database data at the project level.
Export RestrictedClicking Export opens an upgrade prompt.
  • The export feature is labeled as a Pro capability
  • Upgrade to Pro or Ultra to enable database exports

Table Details

Selecting a table opens the table detail view, where you can inspect its contents.

Paginated Browsing

Navigate through records page by page

Adjustable Page Size

Choose 25, 50, or 100 rows per page (default: 50)
Each row represents a single record stored in the database.

Working with Table Data

Inside a table, you can:

View Records

View all records stored in the table

Copy Cell Values

Copy individual cell values by hovering over a cell

Copy Column Names

Copy column names for reference or debugging

Refresh Table

Refresh the table to load the latest data
These actions allow you to inspect and verify data without modifying table structure.

Exporting Table Data

You can export data from an individual table.
  • Exported data is packaged as a ZIP file
  • Each export contains only the selected table’s data
Export behavior follows the same rules as database export: Free users are prompted to upgrade, while paid users receive the prepared download automatically.

Table Structure & Limitations

Row Operations

You cannot manually add, edit, or delete rows

Schema Management

You cannot manually modify table structure
Tables, columns, and row data are managed by the system. Users cannot add, edit, or remove tables, columns, or rows directly. This design keeps data structures stable and avoids accidental changes in production projects.

Time Travel & Bookmarks

YouBase provides a Time Travel view for database history and recovery. This feature allows you to restore your database to a specific historical point.

View History

Browse through all recorded database changes

Restore Anytime

Roll back to any previous state with one click

Bookmarks

Bookmarks record key changes in your database and are listed in reverse chronological order (most recent first). Each bookmark includes:
  • Timestamp (displayed in the user’s local timezone)
  • Change description
  • Affected table(s), when applicable

Bookmark Types

There are three types of bookmarks:

Automatic System Bookmarks

Automatically created when the system modifies the database.Examples:
  • Deleted {n} rows from "{table}"
  • Added {n} rows to "{table}"
  • Created table "{table}"
  • Added column "{column}" to "{table}"
  • Modified "{table}" with 4 changes
  • Modified database with 2 changes

Restore Behavior & Plan Limits

Restoring overwrites the current database state. All restore actions require confirmation.

Free Plan

  • Can view recent bookmarks only
  • Older bookmarks are hidden with an upgrade prompt
  • Restore not available
Upgrade prompts clearly indicate required plans before actions are taken.

When to Use the Database

The Database module is recommended when your project needs:

Persistent Storage

Store data that persists across sessions

Data Inspection

View and export your project’s data

Data Recovery

Recover from accidental data changes

AI Memory

Support for AI memory, logs, or usage history
If your project does not store structured data, the Database module is optional.

Common Use Cases

Below are common scenarios where the Database module is useful. You don’t need to match all of them — use these examples to decide whether your project needs structured data storage.
ScenarioYou want to store information submitted by users through a form.Examples
  • Contact forms
  • Feedback or survey responses
  • Sign-up or waitlist forms
What the Database provides
  • Persistent storage for each submission
  • Ability to review and export collected data
  • A reliable record even after page refreshes or restarts
ScenarioYour UI displays a list of items that should update as data changes.Examples
  • Task or to-do lists
  • Admin dashboards
  • Content management views
What the Database provides
  • Structured tables to store items
  • Row-based records that map cleanly to UI elements
  • Stable data that can be reused across multiple pages
ScenarioEach user should only see or modify their own data.Examples
  • Personal notes or bookmarks
  • User profiles or settings
  • Saved progress in a tool or workflow
What the Database provides
  • Records that can be associated with user accounts
  • Persistent data tied to a specific user identity
  • A foundation for personalized experiences
(Requires Users & Authentication)
ScenarioYour AI-powered app needs to remember past interactions or inputs.Examples
  • Chat history
  • Previous prompts or results
  • Usage logs for analysis or improvement
What the Database provides
  • Reliable storage for historical records
  • Structured data suitable for querying or analysis
  • A stable memory layer across sessions
ScenarioYou are building a prototype or internal tool that relies on real data.Examples
  • Internal trackers
  • Lightweight CRMs
  • Early SaaS dashboards
What the Database provides
  • Production-ready data storage without schema management
  • Built-in export and recovery tools
  • Safety features like Time Travel and bookmarks

When you might not need the Database

If your project:
  • Is purely static or informational
  • Does not store user input or generated data
  • Does not require persistence across sessions
You can keep the Database module disabled and enable it later when your project grows.