Brief introduction
Morph is an all-in-one data studio that enables users to collaborate on data tasks in real time and provides AI-assisted data to collect, sort, and analyze data. It is designed to handle millions of records and provides developers with powerful API support. Morph is designed to make it easy for everyone to collect, store, and understand data through a simple interface.
How to use
The table is now Source and View
In Morph, the place where all the data is placed is called a table, or depending on internal processes, it might be called a "master table" or a "lookup table."
Ultimately, in order to understand what is happening in the table and what can be executed, we must focus on the process of creating the table and the SQL being executed.
You can understand Morph by mastering two concepts: "source" and "view".
Source data
A source, as the name suggests, is where a data source is stored. It looks the same format on the application as the presentation graph.
In addition to Morph's built-in Postgres creation, Source can incorporate MySQL or Postgres that you manage.
view
Views are used to display data extracted from a Source. Allows you to set and save the display and filtering criteria for fields.
Board view
With the release of the view, a new "board view" was added. You can view and edit the content of the data source in both Kanban board and table formats.
space
In the sidebar to make it easier to see your space.
Rights management
All resources on Morph, that is, sources and views, now support member- and group-level permissions. You can now create a private master database and share views only with the specific columns extracted from it.
External source integration
You can now import data from external services.
Importing from Notion and Airtable is currently supported. We plan to support more services in the future.
use
Let AI do the heavy lifting, and Morph's AI can help you collect, sort, and analyze data. Just tell it what you need in simple language.
Price
API
Video loading...
Use Morph as the backend of your application
You can create APIs for Morph's tables that can be accessed by external programs and servers.
This allows you to connect Morph data to external tools or use it as a no-code backend for front-end applications.
Each of these APIs comes with a unique API key that restricts access. Please handle with care.
Create an API for the table
To create an API for a table, click the button in the upper-right corner of the table screen and select the type of data API you want to create from the drop-down menu.
API type
Morph supports the following types of table APIs:
- Query: Retrieves a list of records
- Create: Creates a new record
- Update: Update an existing record
- Delete: Deletes the existing record
- Upload: Upload an image or file
- Download: Download a list of records in CSV format
- Aggregation: Perform aggregation or grouping on tables and retrieve results
Configure the API type
Query APIs and download APIs
The Query API and Download API can set the following rules:
- Select: Choose which fields are exposed to the API.
- Mask: Select the field for which you want to mask the collection results. The fields specified here must also be specified in the selection.
- Filter: Allows you to specify filter criteria. Always apply the filters set here; Additional filtering criteria can also be given when executing the API.
- Sort: Allows you to specify sort criteria. Always apply the sort criteria set here; Additional sorting criteria can also be given when executing the API.
Create APIs and update APIs
The Create API and Update API allow you to set the following rules:
- Fixed value: Set a default value to insert, regardless of the content of the API request.
Aggregation API
The aggregation API allows you to set the following rules:
- Aggregation: Select the fields you want to aggregate. Aggregate functions include sum, count, mean, and median.
- Grouping key: If you want to group aggregated results by the value of a specific field, you can specify the field here.
- Filter: Specify the filter criteria. Always apply the filters set here; Additional filtering criteria can also be given when executing the API.
- Sort: Specify the sort criteria. Always apply the sort criteria set here; Additional sorting criteria can also be given when executing the API.
Delete the API and upload the API
There are no additional configuration rules for the Delete or Upload API. Required parameters are specified at run time.
API documentation.
For detailed specifications of the API, see the API documentation.
https://api-docs.morphdb.io/