What is soarSQL?

soarSQL is an SQL editor made for analytical processing on Postgres, MySQL, and CSVs - powered by duckDB.

How can soarSQL help me?

Analytical SQL queries on OLTP databases will run in a fraction of the time compared to standard editors. A query that originally took me 40+ minutes ran in just 14.6 seconds with soarSQL.

By leveraging duckDB's processing engine, your queries will perform like those on an OLAP system such as BigQuery, Redshift, or Snowflake. You won't need to materialize a copy of your data or perform extra processing.

Since soarSQL handles the bulk of the processing locally on your device, you will save money and minimize the risk of overloading your database.

Additionally, you can open CSV files of any size and query them as if they were Postgres tables.