qStudio - Free SQL Analysis Tool

qStudio is a free SQL GUI, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including mysql, postgresql, mssql, kdb.... For more info see timestored.com/qstudio

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

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.