KBAISE/ for lovable
Library
Docs

Database

about 5 minFirst appchecked 5d agoOfficial page
The short version

The Database view lets you view, search, and edit your app's saved information just like a spreadsheet without writing code. You can create new data tables anytime by describing what you want to track in the project chat.

Anyone building an app that needs to remember data such as user accounts, client details, orders, or form submissions.

Do this, in order

  1. 1

    Describe the data your app needs to track in the main project chat.

    Lovable automatically creates the proper database tables, columns, and code for you.

  2. 2

    Open More, then select Database.

    This opens the dashboard where all of your app's saved data tables are listed.

  3. 3

    Click on any table to view, filter, double-click to edit, or export records to CSV.

    It lets you inspect customer submissions and fix or add data manually without technical tools.

  4. 4

    Click Manage inside the Database view if you need to view backups, access rules, or settings.

    It gives you direct access to technical management tools like scheduled jobs and server settings.

Paste this into your project

I want to add a database to track my clients. Create a table with fields for name, email, phone number, and notes. Also create a deals table linked to each client that tracks deal value, deal stage, and expected close date.

Words decoded

PostgreSQL
A reliable, industry-standard system for storing structured data in tables of rows and columns.
Migration
A recorded file that details an update to your database structure, making sure your code and database stay in sync.
Primary key
A unique identifier column (like an ID number) that ensures every single row in a table is distinct.
Database view
A read-only saved snapshot that pulls and displays data combined from one or more tables.

Where people get stuck

  • Edits or row deletions you make in the Database view happen directly on your live database with no undo button.
  • You cannot enable a database from inside a project draft; you must request it in the main project version.
  • Running manual commands in the SQL editor will change your data directly without saving a migration file in your code history.
  • The data table view does not refresh automatically in real time, so click Refresh to check for recent submissions.

The short version, steps, decoder and prompt on this page are written automatically from Lovable's own documentation and can lag or misread it. The official page is always the authority.