Tell Lovable what data you need:

"Create a database table for Books with:
- title (text)
- author (text)
- isbn (text)
- publishedYear (number)
- rating (number 1-5)"

Lovable:

• Creates the table
• Sets up CRUD operations
• Handles queries

---

Option 1: Through Your App UI

Build forms in your app. Lovable handles saving to database.

Option 2: Ask Lovable to Add Test Data

"Add 5 sample books to the database for testing"

Lovable seeds the database.

---

Tell Lovable what to show:

"Show all books sorted by rating, highest first"

or

"Show books by a specific author when user searches"

Lovable writes the database queries.

---

"Add edit functionality where users can update book details"

Lovable:

• Adds update forms
• Handles database updates
• Shows updated data

---

"Add delete button to remove books from database"

Lovable adds delete with confirmation.

---

Relationships

"Add Authors table. Each book should link to an author"

Lovable handles foreign keys and relationships.

Filtering

"Add filters to show only books with rating above 4"

Pagination

"Show 10 books per page with next/previous buttons"

All database queries handled by Lovable.

---

Free tier: Suitable for testing
Paid tier: Production-ready database

No separate database hosting needed.

---

Don't overthink it. Lovable handles database complexity.

Focus on your app logic. Let Lovable handle SQL, schema, queries.

---

Get started:

• Lovable - Database included

---

More Lovable guides:

• Build with Lovable
• Add Auth

---

Disclosure: Some links are affiliate links.