// the find
timestored/qstudio
qStudio - Free SQL Analysis Tool
qStudio is a Java Swing desktop SQL client that connects to an unusually wide range of databases — kdb+, DuckDB, PostgreSQL, ClickHouse, and 40+ more — with a built-in SQL notebook mode that mixes markdown and query results. It's aimed at analysts and data engineers who work across multiple database types and want a single tool instead of one per DB.
The kdb+/q support is genuinely rare — most SQL tools ignore it entirely, and qStudio has deep kdb+ integration including a tutorial notebook. The database breadth is real: bundled JDBC drivers for DuckDB, PostgreSQL, MySQL, MSSQL, ClickHouse, and others means it mostly just works without hunting down drivers. FlatLaf theming gives it a modern look for a Swing app — it doesn't feel like it was built in 2008. The SQL notebook format (markdown blocks + SQL blocks + charts) is practical for sharing analysis without needing Jupyter or a separate BI tool.
The build system is Ant with JARs checked into `/lib` — no Maven, no Gradle for the main module, just a `build.xml` and a pile of vendored binaries. Contributing or upgrading dependencies is painful. The AI features (Text2SQL, Explain-My-Query) are documented on an external website but the actual implementation (`AIFacade.java`) is opaque — no indication of which model or API is called, and the cloud dependency isn't clearly disclosed in the UI. With 57 forks and 1075 stars after what appears to be years of development, the community is thin; issues and PRs may sit. Test coverage looks minimal — the test infrastructure is there (JUnit, Mockito, FEST-Swing) but no evidence of a meaningful test suite in the tree.