โก TL;DR More, Database shows tables with filters, inline editing and CSV export. The SQL editor confirms destructive statements. Each project has its own isolated PostgreSQL database.
Your data, visible and editable right inside the editor.
๐๏ธ Browsing Data
Open More, Database (edit access needed). Double-click values to edit, filter, add or delete rows, and export to CSV. Views are read-only.
๐งพ SQL Editor
Manage, SQL editor, then Run or Ctrl/โ+Enter. Autocomplete helps, and destructive statements need confirmation.
๐ Limits
Keep in mind:
- โ 10 to 100 rows per page
- โ Full-row edits need a single primary key
- โ The region is fixed at creation
- โ Only approved PostgreSQL extensions
๐ Sharing Data
Projects cannot share a built-in database; point apps at the same external Supabase project instead.
๐ก Pro tip Leave the drizzle folder alone; it tracks migrations.
Need a data model designed? Lord of the Wix can help. โจ
โ Lovable database FAQ
Can projects share a database?
No, use external Supabase.
Can I run SQL?
Yes, in the SQL editor.
Can rows be exported?
Yes, to CSV.
Are all extensions supported?
No.
What are the drizzle files?
Migration records.
๐ Credit: Based on public information from the Lovable documentation. Lovable is a product of Lovable. Source: docs.lovable.dev. Lord of the Wix is an independent agency and is not affiliated with Lovable.