Tables
Standard SQL data types including text, integers, floating-point values, and Booleans.
Bring AI Operators to Your Database
Enable AI Analytics on Your Cloud Database.
GesamtDB stores images and sound in your existing cloud database. It enables you to write SQL with AI operators on text, images, and audio. Supports PostgreSQL, MySQL, and DuckDB.
Why customers choose GesamtDB
- Use your existing cloud database without migration
- One query layer for text, images, audio, and tables
- Predictable pricing with low monthly fees
- Visual interface and REST API
Connect and query
Step 1
Connect your existing PostgreSQL, MySQL, or DuckDB/MotherDuck database.
Step 2
Upload CSV or ZIP files containing images, audio, or text data.
Step 3
Run SQL with AI operators using REST API or visual interface.
Supported data types
Ingest and analyze mixed data workloads in one environment.
Images
AI analysis over common image formats such as JPEG and PNG.
Text
Document and free-text analysis stored directly in relational tables.
Sound
AI analysis for audio files such as MP3 and WAV.
Supported AI operators
Express analytical intent in natural language while staying in SQL.
AIFILTER
Filter multimodal data with natural-language conditions.
AICLASSIFY
Classify records with label names only.
AISCORE
Assign scores based on natural-language criteria.
AIMAP
Transform or extract information with natural-language instructions.
AIJOIN
Join datasets using semantic matching rules defined in natural language.
Supported file formats
Each uploaded format is available as a first-class input for SQL + AI workflows.
CSV
Structured tabular uploads for relational analysis.
ZIP
Archive container for mixed multimodal assets.
JPG
Compressed image format for visual analysis tasks.
PNG
Lossless image format with high visual fidelity.
GIF
Image format supported for uploaded media datasets.
WEBP
Modern web image format for compact storage.
MP3
Compressed audio format for speech and sound data.
WAV
Uncompressed audio format for detailed signal quality.
Supported systems
Connect your existing database and run the same SQL + AI operators across all supported engines.
PostgreSQL
Power reliable analytics on your production Postgres data without migrations.
MySQL
Bring AI-native SQL workflows to existing MySQL applications and dashboards.
DuckDB / MotherDuck
Run fast cloud analytics on DuckDB workloads through MotherDuck.
Pricing
View Full Plan Details
Plans by query scale
Plans differ by daily query budgets while keeping the same core SQL + AI model.
Basic
$9 / month
- Up to 100 queries per day
- Up to 500,000 tokens per day
- Up to 2,500 model calls per day
- Up to 30 compute minutes per day
Standard
Most Popular$19 / month
- Up to 250 queries per day
- Up to 1,500,000 tokens per day
- Up to 5,000 model calls per day
- Up to 60 compute minutes per day
Professional
$49 / month
- Up to 1,000 queries per day
- Up to 5,000,000 tokens per day
- Up to 15,000 model calls per day
- Up to 120 compute minutes per day
SQL + AI use cases
Switch between representative use cases and inspect each SQL pattern with syntax highlighting.
Finding complaints in survey comments
Count customers who mention pricing concerns in free-text responses.
SELECT COUNT(*)
FROM SurveyResults
WHERE AIFILTER(Comments, 'the customer complains about the price');Classifying image collections
Tag uploaded holiday images with semantic classes in one query.
SELECT AICLASSIFY(pic, 'beach picture', 'city visit', 'other')
FROM HolidayImages;Ranking sentiment in reviews
Sort comments by positivity score to prioritize outreach.
SELECT *
FROM SurveyResults
ORDER BY AISCORE(Comments, 1, 10, 'Positivity');Summarizing call recordings
Condense support calls into short summaries for quality reviews.
SELECT AIMAP(AudioContent, 'Summarize the call in three sentences')
FROM RecordedCalls;Entity matching across product catalogs
Match equivalent products from independent datasets with semantic joins.
SELECT *
FROM ProductDB1 P1, ProductDB2 P2
WHERE AIJOIN(P1.productName, P2.productName, 'this is the same product');Documentation and guided tutorials
Read endpoint-by-endpoint API docs, operator specs, and practical tutorials for both the visual interface and Python REST clients.