If you’re not familiar with backend structure, it’s worth pointing out that Databases and Tables are different things in Morph. Tables hold multiple records, while Databases hold multiple Tables. Think of a Database like a folder with the Tables as a set of spreadsheet files inside that folder, and you won’t be far off.
In Morph, Tables within the same Database can interact and link to one another. Tables in different Databases cannot.
‘My First DB’ tour: Morph Anatomy (only)
- Updated @September 15, 2023 with new Notebook UI
‘My First DB’ tour: Morph Anatomy + create a new DB + create table by CSV import
- NOT updated yet with new Notebook UI
Creating a Database
To create a Database:
- click the '+' button to the right of 'Database' in the sidebar
- enter a database name and click the 'Create' button
It will take up to a minute for the database to be created.
Click on the '+' button to the right of 'Tables' in the left sidebar to bring up a popup.
You can now choose to create your new Table by importing outside data, or start from scratch with a blank Table.
Creating a table from scratch
To create a completely new, blank Table, enter the table name in the form in the Create New Table popup.
- Table Name: The name you and other users will see. Capitalize it, throw in space; up to you.
- Slug: the Slug is the machine-readable name for the Table, like an ID. It will be automatically generated from the Table Name you enter, so you don’t need to worry about it. It’s used internally by the system, and for tasks such as APIs.
- Description: describing the role of the table in the Comment can help other users unfamiliar with the data, help you remember what the Table does, and improve the accuracy of AI-based functions.
Importing CSV / Excel files.
You can import existing CSV / Excel files to create tables.
Once the file has been uploaded, a preview will be displayed. Field types will be automatically detected, but it’s always a good idea to check them.
You can edit or remove Fields by clicking on their header.
Importing via from other service
Example of importing data from Notion.