Varan is a desktop SQL client for querying across different databases at once. Point it at MySQL, PostgreSQL, DuckDB, or spreadsheet files (CSV and Excel) and run a single SQL query โ including JOINs โ across all of them, without ETL pipelines or importing everything into one database first.
It runs on a local-first DuckDB engine, so queries execute on your own machine with read-only access to your sources: no admin rights, no server to set up, and nothing is written back to your databases.
Beyond cross-source SQL, Varan adds the tools data people always wish they had โ automatic anomaly detection when you open a table (duplicate keys, missing values, outliers, and orphaned foreign-key references), column-level lineage, git-style rollback of every change, and a Python surface on the same live tables you query in SQL.
Varan is a cross-platform desktop app for macOS, Windows, and Linux, currently in beta.
Cross-source SQL
Write one SQL query with a normal JOIN across MySQL, PostgreSQL, DuckDB and spreadsheet files โ no need to move everything into a single database first.
Local-first DuckDB engine
Queries run on your own machine via a bundled DuckDB engine โ fast, private, and no server to stand up.
No ETL, read-only access
Connect with read-only credentials and query directly. No pipelines, no exports, no admin rights, and nothing is written back to your sources.
Automatic anomaly detection
Flags data issues the moment you open a table โ duplicate keys, missing values, outliers, mixed types, and orphaned foreign-key references โ with the exact rows highlighted.
Column-Level Lineage
Trace where every column comes from and how it flows through your queries and transformations.
Git-style rollback
Every mutation is snapshotted before it runs, so you can undo any change like reverting a commit.
Python surface
Switch into Python (pandas and friends) on the same live tables you query in SQL โ no exports or CSV round-trips.
Spreadsheets as tables
Query CSV and Excel files directly, and JOIN them to database tables in a single SQL statement.
Built-in charts & data insights
Turn results into no-code charts and get per-column statistics without leaving the app.
Cross-platform desktop app
Native builds for macOS, Windows, and soon Linux
Varan runs a single SQL query across different databases and files at once. Most SQL clients (DBeaver, DataGrip, TablePlus) connect to one database at a time; Varan lets you JOIN a MySQL table to a PostgreSQL table to a CSV in one statement, powered by a local-first DuckDB engine โ no ETL, no pipelines, no data copied into a warehouse first. On top of that it adds automatic anomaly detection, column-level lineage, and git-style rollback in the same workspace.
Data analysts, analytics engineers, and data-adjacent developers who regularly work across several databases and spreadsheets. People who can write SQL but aren't DBAs โ they have read-only access to production and don't want to spin up ETL pipelines or a warehouse just to answer an ad-hoc question spanning two systems.
Traditional SQL clients are single-database, so cross-source work means exporting and stitching data by hand. Federated engines like Trino or ClickHouse can query across sources but need infrastructure to stand up and manage. Varan sits in between: open a desktop app, point it at your sources (read-only, no admin), and query across all of them instantly โ with lineage, anomaly detection, and rollback built in. It's the convenience and workflow of a polished app on top of a serious engine, without the setup.
Varan started from a recurring frustration: whenever an answer needed data from two places โ a Postgres database, a MySQL host, and the inevitable sales_final.xlsx โ the options were to build an ETL pipeline, hand-write fragile pandas glue, or give up. We wanted to just point one tool at everything and write a normal JOIN. So we built Varan around a local-first DuckDB engine that queries across sources directly, and added the data-quality and versioning tools we always wished we had. It's currently in beta.
DuckDB (the local-first query engine) Electron + React (desktop application) Node.js (application/runtime layer) Python (bundled analysis surface) Java / Spring Boot (the licensing & sync hub backend) PostgreSQL (hub data store)
We have collected here some useful links to help you find out if Varan is good.
Check the traffic stats of Varan on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of Varan on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of Varan's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of Varan on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about Varan on Reddit. This can help you find out how popualr the product is and what people think about it.
Do you know an article comparing Varan to other products?
Suggest a link to a post with product alternatives.
Is Varan good? This is an informative page that will help you find out. Moreover, you can review and discuss Varan here. The primary details have been verified within the last quarter. So they could be considered up to date. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.