Data Engine
A local database on your machine. Query with SQL or plain English.
Local database
Jetro runs a database (DuckDB) on your machine. Financial data gets cached automatically, imported files become queryable tables, and your portfolio holdings are synced so you can run SQL on everything. Or just ask the agent in plain English.
Data sources
- Financial data automatically cached from API calls
- Your files (CSV, Excel, Parquet, JSON) registered as queryable tables
- External databases like PostgreSQL, MySQL, and others
- Portfolio holdings synced and ready for queries
Saved queries
Define reusable views that transform raw data. Save a query once, and it loads automatically every time you open your workspace.
Unlimited queries
Local database queries don’t count toward your daily usage limit. Query as much as you want. It’s all running on your machine, no API cost.