QStudio - Fully Open Source SQL Analysis Tool

qStudio is a Free SQL Client and Notebook that lets you browse tables, run SQL scripts, and chart and export the results. qStudio runs on Windows, macOS and Linux, and works with every popular database including mysql, postgresql, mssql, kdb… For more info see timestored.com/qstudio

Runs on everything

Windows, macOS, Linux

Suports Every Database

kdb+, mySQL, QuestDB, PostgreSQL, Redis TimeScale, Microsoft SQL Server, H2 Database, DuckDB, Oracle TDengine, DolphinDB, Clickhouse, MongoDB, Druid, InfluxDB Derby, HSQLDB, SQLite, CSV, MS Access, JDBC Apache Calcite Avatica, Snowflake, Elastic Search, MariaDB, Apache Kylin, DB2, Teradata, CrateDB, NuoDB, SAP HANA, Gemfire XD, Snappy Data Tibco Spark Hive, Kyubi Hive, Yandex Clickhouse, Neo4J, Presto, Trino Apache Solr, Apache Ignite, Omnisci, Informix, Sqream, Aurora

SQL Notebook

Write markdown, generate beautiful reports instantly.

Features

• Server Browser - Browse a server as a tree of objects with useful common tasks available from drop down menus.
• Built-in Charts - Simply send the query you want and select the chart type wanted to draw a chart.
• Syntax Highlighting
• Code Completion

Pivot and Chart Data Easily

Powerful AI Assistant

• Text2SQL - Generates queries from plain English.
• Explain-My-Query - Walks you through your code.
• Explain-My-Error - Ask AI why your code throw an error.

Current Status

Check out the CHANGELOG.md file for the latest information.

Troubleshooting qStudio

Check the Troubleshooting for more information.