Open Source Linux SQL Clients

Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It's engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards. Use Azure Data Studio to query, design, and manage your databases and data warehouses wherever they are, on your local computer or in the cloud. Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git).

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, Snowflake, Google BigQuery, SQLite, TiDB, and many more via ODBC. The docker image runs on port 3000 and uses /var/lib/sqlpad for the embedded database directory. latest tag is continuously built from latest commit in repo. Only use that if you want to live on the edge, otherwise use specific version tags to ensure stability. See docker-examples directory for example docker-compose setup with SQL Server.

Simple SQL Client for lightweight data analysis. You can share the result with gist. Supports MySQL, PostgreSQL (Amazon Redshift), SQLite3, Google BigQuery, Treasure Data, Amazon Athena. You can download and install from Web Site or Releases.

SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. SQL Explorer is inspired by any number of great query and reporting tools out there.

Eclipse SQL Client for database querying/browsing any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2, MySQL, PostgreSQL, Sybase, Informix) and can be extended.

Open source simple business intelligence application and sql editor tool for Clickhouse. Auto-completion of fields, dictionaries and functions. Tips on fields and functions in Russian and English. Reformatting queries / autoformat. Minimizes brackets and subqueries. Setting the autocompletion / enableLiveAutocompletion. Backlight brackets. The list of functions is loaded based on the capabilities of the server. Displays which query is running. Display the number of tables at the database. The icon of the table depends on its engine. List of fields in the table and inserting the field when clicking in the editor. DB selection via double click in the tree, pop-up window about selection. Search in the tree of objects, filtering the tree. Rebuilding the list of databases / tables after the query is executed. Table with information about completed requests at the end of the list / Requests in the tab are logged for performance comparison.

Quantum is a database plugin for Eclipse (needs GEF, Point Eclipse at http://quantum.sourceforge.net/update-site). It currently supports most databases with a JDBC driver. It shows tables, views, and sequences in a tree format and provides an SQL editor

Jisql is a Java based utility to provide a command line interactive session with a SQL server. It can connect to any database with a JDBC driver.

PL/SQL Editor Plugin for Eclipse using file and database access for auto completion and many standard source editing capabilities of eclipse. Designed to support editing the Oracle based PL/SQL language. Written in java, supported on all platforms.

The interface supports drag and drop HTML components, javascript and scriptlet events, and generate a very fast code, with no additional softwares layers or libraries. You can put your libraries, like jQuery. The generated code works with all browsers. You can create and debug Applets or Java Swing applications easily with the Visual Editor of the tool. Build C++ applications.

DBPad is a GUI-based SQL client for relational databases. As long as you have a JDBC driver for your DB, you can use DBPad to view or manipulate your data and metadata of your tables.

lib4d_sql is a C library providing the required functions (connect, prepare, execute, ...) to write a SQL client for 4D databases. It uses the public 4D SQL protocol wich is supported by 4D products since... the version 11. It is already used by the PDO_

Simple java based command line SQL editor. Will connect to any database that you can provide a JDBC Type 4 driver for (in the form of a jar).

Generic C++ SQL client wrapper over different SQL DB engines. Using a unified interface, it currently supports MySQL/MariaDB, ODBC, PostgreSQL and SQLite.

This project will add support for editing Oracle PL/SQL objects right inside the NetBeans IDE, including syntax highlighting, code folding and indentation. See Wiki for more information.