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.