Skill · App Builders
Database Schema Whisperer
Designs a Lovable app's tables, constraints and row level security rules before the pages exist, with a migration template and a two-user test plan.
When to use
- Before the first page prompt of an app that stores user data.
- You are unsure which tables, relationships and permissions you need.
- Requirements changed mid-build and you need to change tables without losing data.
- One user can see or change another user's data.
When not to use
- A static site or an app that stores nothing.
- Health, finance or other regulated systems: use this only as a first draft for a professional database and security review.
- The project does not use Postgres with row level security: the table design still applies, but the permission section has to be rewritten for your database.
Example
User: Recipe app. Users keep private recipes, can share one through a public link, and group recipes into collections.
Result (excerpt):
TABLES
recipes: a user's recipe
- id: uuid primary key · user_id: uuid not null → users.id (on delete: cascade)
- title: text not null · ingredients: text not null · steps: text not null
- is_public: boolean default false · created_at, updated_at: timestamptz
collections: a user's named group of recipes
collection_recipes: collection_id, recipe_id, unique together
DATABASE RULES: a recipe appears once per collection (unique pair)
PERMISSIONS
recipes: read owner, or anyone when is_public · create, change, delete: owner only,
and a new or changed row keeps user_id = the signed-in user
collections and collection_recipes: owner only
TEST PLAN: as user A, create a private recipe; as user B, open its id: not found.
Make it public; logged out, open the share link: visible. As user B, try to add
A's recipe to B's own collection: refused.Illustrative example; your output will differ.
What is inside
The full skill has these sections. The ones marked “in the pack” come with the download.
- When to use on this page
- When not to use on this page
- Inputs to ask for in the pack
- Workflow in the pack
- Rules in the pack
- Output format in the pack
- Example on this page
- Model notes (Oct 2026) in the pack
- Troubleshooting in the pack
- Paste-in version (for chats without skill support) in the pack
Get Database Schema Whisperer
The full skill is a SKILL.md folder you install once and reuse: the workflow, the checklist and the answer format written out, with notes for each model. It comes in the App Builders pack (3 prompts · 11 skills · 1 free), with a QUICKSTART, setup notes in every item and 12 months of updates.
All-Access 39 € vs 7 packs × 12 € = 84 € · less than buying 4 or more packs one by one
Stuck? Email support@meevra.com — we'll help you set it up.