Fundamentals: Interface

GesamtDB can be used through two interfaces:

• REST interface
• visual interface

REST interface

The REST interface is designed for programmatic use from code, scripts, and automated pipelines.

At a high level, it supports:

• configuring target databases
• uploading CSV/ZIP data
• executing SQL queries with AI operators
• retrieving and downloading query results

Visual interface

The visual interface (/app/) is designed for ad-hoc analytics and interactive exploration.

At a high level, it supports:

• configuring connection settings
• uploading data
• browsing tables and schema previews
• writing and running SQL queries
• inspecting and downloading results

Further reading: Visual Interface Guide and REST API Reference.