Your First Collection in 5 Minutes
Your First Collection in 5 Minutes
You don't need to know anything about databases, APIs, or coding to get started. By the end of this guide, you'll have a working data collection that stores and retrieves real information.
What's a Collection?
Think of a collection as a folder that holds related tables. And a table is just a spreadsheet — rows and columns, but smarter.
For example:
- A "CRM" collection might hold tables for Customers, Deals, and Contacts
- An "Inventory" collection might hold Products, Categories, and Suppliers
You decide what goes where. There's no wrong answer.
Step 1: Open the Schema Designer
After signing in to IdealVibe, navigate to your dashboard. You'll see the Schema Designer — an AI assistant that helps you build your database by talking to it.
Click "New Collection" or just type something like:
"I want to track my customers and their orders"
The Schema Designer will suggest a collection structure for you. It understands plain English — no technical jargon needed.
Step 2: Review the Suggested Schema
The AI will propose something like:
Collection: CRM
| Table | Columns |
|---|---|
| Customers | name, email, phone, company, created_at |
| Orders | customer (linked), amount, status, order_date |
Each column has a type (text, number, date, etc.) that keeps your data clean. The link between Orders and Customers means every order knows which customer placed it.
You can:
- Accept the suggestion as-is
- Modify it (add columns, rename things, remove what you don't need)
- Ask for changes in plain English: "Add a 'notes' column to Customers"
Step 3: Create It
Once you're happy with the schema, click Create (or tell the AI "looks good, create it"). Your collection is live in seconds.
Behind the scenes, IdealVibe creates the tables, sets up the relationships, and configures everything. You don't need to worry about any of that.
Step 4: Add Your First Record
Navigate to your new collection and open the Customers table. Click "Add Record" and fill in the fields:
| Field | Value |
|---|---|
| Name | Jane Smith |
| jane@example.com | |
| Phone | 555-0123 |
| Company | Smith & Co |
Hit Save. That's it — your first record is stored.
Step 5: Query Your Data
Now that you have data, you can search and filter it:
- Search: Type "Jane" in the search bar to find her instantly
- Filter: Show only customers from a specific company
- Sort: Order by date added, name, or any column
As your data grows, these tools keep everything findable.
What's Next?
You just created a working database in under 5 minutes. Here's where to go from here:
- Add more tables to your collection (products, invoices, tasks — whatever your business needs)
- Set up relationships between tables so your data connects together
- Invite your team and assign roles so everyone has the right access
- Build a Customer Tracker — our next guide walks you through a complete CRM setup
Quick Reference
| Term | What It Means |
|---|---|
| Collection | A group of related tables (like a folder) |
| Table | A structured set of records (like a spreadsheet) |
| Schema | The blueprint that defines your table's columns and types |
| Record | A single row of data (one customer, one order, etc.) |
| Relation | A link between two tables (e.g., an order belongs to a customer) |
That's all there is to it. No servers to set up, no code to write, no database to manage. Just describe what you need and start working.