Manual · 9

Data source endpoints

Method Path Description
GET /datasources List all data sources
POST /datasources Connect a data source (admin) – see Connect a data source
POST /datasources/sqlite Create a new, empty SQLite database (admin) – see Create a new SQLite database directly
DELETE /datasources/{id} Remove a data source (admin) – only deletes the connection, not the external data
POST /datasources/{id}/sync Re-read the schema (admin) – see Synchronizing
GET /datasources/{id}/tables List this data source’s tables
GET /datasources/{id}/download Download the SQLite file (SQLite only)
GET /datasources/{id}/export-schema Export the app configuration – see Export and import schema
POST /datasources/{id}/import-schema Import the app configuration (admin)
POST /datasources/{id}/sql Execute SQL (admin) – see SQL Terminal
POST /datasources/{id}/sql-import/preview SQL import preview (admin)
POST /datasources/{id}/sql-import Run an SQL import (admin) – see SQL import
POST /datasources/{id}/csv-import/preview CSV import preview for a new table (admin)
POST /datasources/{id}/csv-import/tables Create a new table from CSV (admin) – see CSV import
POST /datasources/{id}/tables Create a new empty table (admin)