Create a Database with AI - Just Describe it
Describe what you want to keep track of, answer a few plain questions, and the Sapience Agent designs and builds the whole database for you.
Overview
You don't need to know anything about databases to get a good one. Tell the Sapience Agent what you want to keep track of, in your own words, and it designs and builds the whole thing for you.
The agent works like a good consultant:
- It asks you a few plain questions about your business, two or three short rounds at most.
- It shows you a plan in everyday language: the lists it will make, what each one records, how they link together, the saved views and any forms.
- When you say yes, it builds everything, fills each list with a few example entries, and tells you where to find it.
Nothing is created until you've seen the plan and said yes.
Step 1: A Few Plain Questions
The agent asks 3 or 4 numbered questions per round, and every question comes with an example answer so you know what kind of reply it is after:
1. What do you want to record about each dog? [Its breed, its age and which client owns it]
2. How do you charge for a walk? [A set price per walk in AUD, or by the hour]
3. Do clients book walks themselves, or do you enter them? [Clients fill in a form on my website]A few things make this quick:
- It never asks what you've already told it. Mention in your first message that every dog has a microchip number, and it simply notes it.
- It suggests sensible defaults instead of asking about everything.
- It stops after three rounds at most. Say "that's everything, show me the plan" at any point, even after the first round, and it goes straight to the plan.
- In a hurry? Say "just build it" and it skips the questions and shows you a plan built on defaults.
You'll never be asked about "schemas", "fields" or "column types". The agent talks about lists, details and entries.
Step 2: The Plan
Before building anything, the agent shows you its plan. It looks something like this:
Dog Walking Tracker - one place for your clients, their dogs and every walk.
Clients - Email (email), Phone (phone), Suburb (text)
Dogs - Dog type (text), Age (number), Client (link to Clients - one client can have several dogs)
Walks - Date (day and time), Length (length of time, minutes), Price (money, AUD),
Paid (yes/no), Status (choice: Booked, Done, Cancelled), Dog (link to Dogs),
Client phone (shown from the linked client)
Saved views - Unpaid walks on Walks: walks not yet paid, newest first (opens first) ...
Forms - New client sign-up adds entries to Clients: Name, Email (required), Phone;
a public link for people outside your team: yes
Example entries - a few in every list.
Shall I build this?Want a change? Just say so: "Also track each dog's vet." The agent shows the whole updated plan again, marking what's (new) or (changed), and asks again. Asking a question or saying "maybe" doesn't start the build. Only a clear yes, go ahead or build it does.
Step 3: The Build
Once you say yes, the agent builds the database in one go. A large database with eight lists, linked details, views and a form takes a few minutes, and you can watch the status lines as it works.
What you described | What you get |
Money ("we charge $40") | A money detail in your currency (AUD, USD, GBP, EUR…) |
A percentage ("a 10% deposit") | A percent detail |
A score ("rated out of 5") | A rating detail with that top score |
A length of time | A duration detail in minutes, hours or days |
A date, or a date and time | A date or date-and-time detail |
Yes/no facts ("paid?") | A tick box |
Fixed options ("Booked, Done, Cancelled") | A choice list with exactly your options |
Several of a set ("organic, bulk, gourmet") | A multi-choice detail |
Email, phone, website | Email, phone and web-address details |
Attachments, documents, photos | A files detail, holding one file or several |
A person on your Sapience team | A team-member detail |
"Each dog belongs to a client" | A link between the two lists, one-to-one or one-to-many, even a list linked to itself ("reports to another employee") |
"Show the client's phone on each walk" | A detail shown from the linked entry |
On top of the lists and details, you get:
- Saved views for what you said you want to see at a glance, with filters, sorting, grouping and only the details you need. Each list gets at least one, and one is marked to open first.
- Forms where other people fill information in, with friendly labels, required fields marked, an introduction, a button label and a thank-you message.
- Example entries in every list: invented, obviously fictional (emails end in
example.com), and linked so every shown-from-the-link detail has a value. Team-member details are left empty, never made up.
- Tags on the database, and on lists, views and entries if you asked for them.
- Your own notes and files, added to a list as entries, but only ones you named.
Step 4: The Hand-Off
When it's done, the agent tells you in plain words:
- each list it built and what it's for,
- each saved view and what it shows,
- each form, with its public link if it has one,
- that you can open the database from Databases,
- and two or three things to try next, such as adding your real entries or asking it to add another list.
You won't see ids, code or error messages. If any part couldn't be built, it says so plainly instead of claiming it's done.
Forms and Public Links
A form gets a public link only when the plan says people outside your team will fill it in, and you can ask for a password on that link. A form without a public link can't be filled in yet. To turn its link on later, open the form's settings in the app and choose Publish.
Adding to a Database You Already Have
The same skill works inside an existing database. Open the database, click Chat, and pick the skill or ask for it by name. The database's own agent interviews you the same way, shows a plan of only what it will add (everything already there stays as it is), and builds the new lists, views and forms into that database. It never creates a second one.
See Chatting With a Database for everything else that chat can do.
Good to Know
Topic | What to expect |
Every entry has a Name | So the agent never adds a detail called Name, Type, Owner, Tags, Position, Created at or Modified at. It picks a clearer word instead, such as "Dog type", "Client" or "Date added" |
Details shown from a linked entry | Reach one step. To show a client's phone on a walk, the walk links to the client directly, and the plan tells you so |
Layouts | The saved views it makes use the table layout unless you ask for a board, gallery, list, calendar (on a date detail) or pivot. You can also switch any view's layout yourself from the Layout dropdown |
Formulas and roll-ups | Not something it builds. For totals, it offers a saved view grouped by a detail, where the grid adds up the money, numbers and ratings under each group, or a pivot view (see Totals, Grouping And Pivot In Database Grids) |
Size | Up to ten lists in one go, up to 200 options in a choice list. You can always ask for more lists afterwards |
Quick Reference
You want to… | Do this |
Start a new database | Ask the Sapience Agent, or pick Create a Database from the skill picker |
Skip the questions | Say "just build it" or "show me the plan" |
Change the plan | Say what to change. The agent re-shows the whole plan |
Start the build | Say yes, go ahead or build it |
Add lists to an existing database | Open its Chat and use the same skill |
Let outsiders fill in a form | Say so in the interview and it gets a public link, with an optional password |
Summary
Describe your business, answer a few plain questions, check the plan and say yes. The Sapience Agent builds a complete database for you, with linked lists, the right kind of detail for every piece of information, saved views, forms and example entries, and then tells you exactly what it made and where to find it.