​

Database

The Database data source allows you to connect and sync data tables directly from an external SQL database.

​

Supported Databases

• PostgreSQL
• Microsoft SQL Server

​

Connect Data source

1. Select Data Sources > + Add.
2. Choose Database as the source type.
3. Select your database provider (e.g., PostgreSQL or Microsoft SQL Server).

​

Upload Database (Excel)

Alternatively, you can upload an offline database in Excel format. This is useful for importing static datasets that follow a relational structure.

1. In the “Connect your data” modal, select Database.
2. Switch to the Upload tab.
3. Upload your Excel file (Max 500 MB).

​

Excel Format Requirements

The Excel file must follow a strict template with three sheets: schema, data, and info.

​

1. Schema Sheet

Defines the table structure.

• Column Name: The name of the field.
• Column Type: Data type (e.g., VARCHAR(255), TEXT, INTEGER, TIMESTAMP).
• Description: A description of what the column represents.

​

2. Data Sheet

Contains the actual data records corresponding to the schema.

​

3. Info Sheet

Provides metadata about the table.

• Cell A1: A comprehensive description of the table’s purpose (e.g., “This table holds all audit records…”).

​

Managing Databases

Once connected or uploaded, your database tables appear in the data sources list.

​

Schema Manager

You can view and edit the metadata for any table by clicking the Schema Manager link (gear icon). The Schema Manager allows you to:

• Edit Table Description: Update the high-level description of what the table contains.
• Edit Column Descriptions: Refine the descriptions for individual columns.