Open Source Linux SQL Clients

DBeaver is a free, multi-platform database tool that supports any database having a JDBC driver. It is useful for developers, SQL programmers, database administrators and analysts. DBeaver comes with plenty of great features such as metadata and SQL editors, ERD, data export/import/migration and more. Plugins are available for certain databases, and there are also several database management utilities. DBeaver’s Enterprise Edition provides even more features and supports non-JDBC datasources.

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

A simple and lightweight SQL client desktop/terminal with cross database and platform support. In case you prefer terminal interfaces. You should try this one. A desktop application with a simple interface.

Redash is an essential tool to help you make sense of your data. It allows everyone, regardless of level of technical know-how to harness the power of data. SQL users connect, query, visualize and share data easily and efficiently, allowing everyone in their organization to use the data. Redash combines the power and comfort of an SQL client with the collaborative benefits of a cloud-based service. It lets you create big, beautiful and easy to digest visualizations on dashboards for better decision-making. Redash supports a multitude of SQL and NoSQL data sources, and can be extended to support even more. Best of all it’s open source, so you can customize and add features to suit your organization’s needs perfectly.

OmniDB is an open source, collaborative web tool for database management focused on interactivity and ease of use, with a design that allows it to be both powerful and lightweight. OmniDB is a browser-based tool, which means it can be accessed on any platform with the browser as a medium. It features a responsive, single-page interface, a unified workspace, a smart and beautiful SQL editor and more. It currently supports Windows, Linux and OSX platforms, and the following DBMS: PostgreSQL, MariaDB, Oracle, MySQL, SQLite (WIP), Firebird (WIP), SQL Server (WIP), IBM DB2 (WIP).

Beekeeper Studio is an open source, cross-platform SQL editor and database management app that is both powerful and easy to use. It lets you query and manage your relational databases, with support for connecting to SQLite, MySQL, MariaDB, Postgres, SQL Server and Amazon Redshift databases. Unlike most other open source SQL editors and database managers, Beekeeper Studio isn’t cluttered with unnecessary features, but does come with the essentials that you need. This includes SQL auto completion, sensible keyboard shortcuts, and the option to encrypt your connection with SSL. Beekeeper Studio is available for Windows, Linux and Mac.

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.

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.

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.

An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights. Platform independent web application. Single JAR file + Single SQLite DB file. Get up and running in 5 minutes. PostgreSQL, Oracle, SQL Server, MySQL, Elasticsearch... You name it. No ETLs, no generated SQL, polish your own SQL query to transform data. Pixel-perfect positioning + Drag'n'Drop support to customize the reports and charts in your own way. Utilize the power of dynamic SQL with query variables to connect Filters and Charts. Capture the snapshot of historical data. Free up space in your own database. Three system level role configurations + Group based report access control. Custom the language pack and translations just for your audience. Auto refresh, drill through, fullscreen, embeds, color themes + more features in development.

Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start. Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples

JookDB is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, Oracle, PostgreSQL, SQLite, MongoDB,Redis, DM, OceanBase, TiDB and SQLServer databases from a single application. You can quickly and easily build, manage and maintain your databases.

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.

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.

DaFT is a frontend to any database that can be connected via ODBC. It provides list views of tables and columns, table view of data, SQL editor, CSV,HTML,SyLK,XLS data format export, and functions for copying data between two ODBC databases.

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.

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.

Panda-Sql is an IDE tool, browser and Sql/PlSql editor for Oracle, Mysql, MsSql, PostgreSQL, SqLite. Best compromise between simplicity and functionality, this professional tool offers all the essential functions for database management.

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.

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

SQL Star, a SQL client provides a common Graphical User Interface (GUI) for all database servers (like, oracle, microsoft sql server, mysql etc.,) using JAVA JDBC 3.0 API With type 4 driver.

APQ is an Ada95 thick binding to allow Ada SQL client programs to access PostgreSQL, MySQL and Sybase database systems. The project is now hosted at http://framework.kow.com.br

Lets you open, create reports, see and execute SQL commands in Oracle database, MySQL, MS Access, SQLServer, and much more MD5 12e7b515835da9c87431d3d3c0be3937

Apache Kyuubi™ is a distributed and multi-tenant gateway to provide serverless SQL on data warehouses and lakehouses. Kyuubi provides a pure SQL gateway through Thrift JDBC/ODBC interface for end-users to manipulate large-scale data with pre-programmed and extensible Spark SQL engines. This "out-of-the-box" model minimizes the barriers and costs for end-users to use Spark at the client side. At the server-side, Kyuubi server and engines' multi-tenant architecture provides the administrators a way to achieve computing resource isolation, data security, high availability, high client concurrency, etc.