How do I create a database in Lovable?

The database comes with Cloud, not as a separate step

You don't "create a database" independently — enabling Lovable Cloud provisions a Postgres database automatically. From there, you describe the tables you need and Lovable creates them.

Set up Lovable Cloud for this project. I need tables for products (name, price, description, image) and orders (customer name, email, items, total, status).

Reviewing what was created

Use the built-in Database view in Lovable to see the tables, columns and data that get created — you can browse rows and check structure without needing separate dashboard access.

Show me the current database schema.

Add security as you go

Every table storing user or business data needs row-level security reviewed, not just created:

Add row-level security to the orders table: customers can only see their own orders, and only admins can see all of them.

Roles for checks like "is this user an admin" must live in a separate user_roles table — never as a column on a profile row, since that pattern is far easier to exploit.

What usually goes wrong

• Assuming a table is instantly secure: newly created tables need explicit RLS policies matched to your actual access rules — don't assume defaults are correct for sensitive data.
• Over-specifying types you don't understand: if you're unsure what column type fits (e.g. currency, dates with time zones), describe the real-world use ("store a price in dollars and cents") and let Lovable choose an appropriate type.
• Forgetting relationships: if orders should reference products or customers, say so explicitly so Lovable adds the correct foreign keys.

For the actual mechanics of adding tables and columns after the database exists, see how do I create database tables.