Open Source Linux SQL Clients
Sort By:
SQL Clients for Linux
View 20 business solutionsBrowse free open source SQL Clients and projects for Linux below. Use the toggles on the left to filter open source SQL Clients by OS, license, language, programming language, and project status.
-
Our Free Plans just got better! | Auth0You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
-
Keep company data safe with Chrome EnterpriseMake AI work your way with Chrome Enterprise. Block unapproved sites and set custom data controls that align with your company's policies.
-
1
SQuirreL SQL Client
A Java SQL client for any JDBC compliant database
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. -
2
DBeaver
Free universal database tool
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. -
3
OmniDB
Open Source Web Tool for Database Management
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). -
4
Beekeeper Studio
Cross-platform SQL Editor and Database Manager
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. -
Desktop and Mobile Device Management SoftwareDesktop Central is a unified endpoint management (UEM) solution that helps in managing servers, laptops, desktops, smartphones, and tablets from a central location.
-
5
Azure Data Studio
A data management tool that enables working with other SQL tools
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). -
6
SQLECTRON
A simple and lightweight SQL client desktop with cross database
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. -
7
TOra is a Toolkit for Oracle which aims to help the DBA or developer of database applications. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a full set of DBA tools. TOra also includes support for MySQL and Postgres.
-
8
River SQL
Fast and reliable background jobs in Go
River is a durable background job system for Ruby on Rails, designed for reliability, observability, and simplicity. It provides persistent queues, native Active Job support, automatic retries, and real-time job monitoring through its admin interface. River focuses on clear diagnostics, performance, and minimal configuration, making it ideal for production-ready job handling in Rails apps. -
9
SQL Notebook
SQL Notebook — Casual data exploration in SQL
SQL Notebook is a free Windows application for querying and analyzing data across multiple sources, including SQLite, PostgreSQL, Excel, and CSV files. It combines a SQL editor with a notebook interface, allowing for data exploration, transformation, and visualization in one place. SQL Notebook is ideal for analysts and data enthusiasts. -
Airlock Digital - Application Control (Allowlisting) Made SimpleFor organizations seeking the most effective way to prevent malware and ransomware in their environments. It has been designed to provide scalable, efficient endpoint security for organizations with even the most diverse architectures and rigorous compliance requirements. Built by practitioners for the world’s largest and most secure organizations, Airlock Digital delivers precision Application Control & Allowlisting for the modern enterprise.
-
10
SQLPad
Web-based SQL editor run in your own private cloud
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. -
11
Redash
Connect to any data source, easily visualize and share your data
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. -
12
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.
-
13
SQL Explorer
Easily share data across your company via SQL queries
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. -
14
PGManage
Web tool for database management
pgManage is an open-source, cross-platform desktop GUI for managing PostgreSQL databases. It provides a tabbed interface for browsing schemas, writing queries, and managing server configurations. Designed for both developers and DBAs, pgManage aims to be a user-friendly yet powerful alternative to pgAdmin. -
15
repmgr
A lightweight replication manager for PostgreSQL (Postgres)
repmgr is a management tool for PostgreSQL replication, providing monitoring, failover, and administrative capabilities for streaming replication setups. It simplifies the configuration of primary/standby clusters and automates failover processes for high availability. repmgr is widely used in production environments where database resilience and minimal downtime are critical. -
16
Bdash
Simple SQL Client for lightweight data analysis
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. -
17
Supabase JS
An isomorphic Javascript client for Supabase
supabase-js is the official JavaScript client library for interacting with Supabase services. It enables developers to easily access Supabase’s Postgres database, authentication, storage, and real-time subscriptions through a unified client. Designed for frontend and full-stack apps, supabase-js integrates smoothly with modern frameworks and supports both browser and server environments. -
18
pg_probackup
Backup and recovery manager for PostgreSQL
pg_probackup is an advanced backup and recovery tool for PostgreSQL developed by PostgresPro. It supports full, incremental, and differential backups with compression and encryption, and provides fine-grained control over backup and restore processes. It’s designed for enterprise-grade backup strategies in PostgreSQL environments. -
19
sqldef
Idempotent schema management for MySQL, PostgreSQL, and more
sqldef is a schema migration tool that automatically generates SQL migration statements by comparing database schemas. Instead of writing migrations manually, developers define the desired schema, and sqldef computes the difference. It's compatible with MySQL, PostgreSQL, SQLite, and others, making migrations safer and more maintainable. -
20
CStore FDW
Columnar storage extension for Postgres
cstore_fdw is a columnar store extension for PostgreSQL built by Citus Data using the Foreign Data Wrapper (FDW) interface. It stores data in a compressed, columnar format that significantly reduces disk I/O for analytical queries. Ideal for read-heavy workloads and time-series data, cstore_fdw enhances Postgres’ ability to serve as a lightweight data warehouse. -
21
Evolve
Database migration tool for .NET and .NET Core projects
Evolve is a lightweight database migration tool for .NET applications, compatible with PostgreSQL, MySQL, SQLite, and SQL Server. Designed with simplicity and speed in mind, it runs SQL scripts in order and tracks their history to keep database schema consistent. Evolve integrates easily with .NET projects for version-controlled schema updates. -
22
SPQR
Stateless Postgres Query Router
SPQR is a sharding proxy for PostgreSQL that enables horizontal scalability by distributing queries across multiple PostgreSQL instances. Designed for large-scale, multi-tenant architectures, SPQR routes, rewrites, and manages SQL queries to ensure they are executed efficiently across shards. It provides a PostgreSQL-compatible interface so applications can scale transparently without code changes. -
23
Temporal Tables
Postgresql temporal_tables extension in PL/pgSQL
temporal_tables is a PostgreSQL extension that adds temporal support to tables by automatically tracking row history. It enables versioned records, letting users query data as it existed at any point in time. This is ideal for audit logging, data versioning, and time-travel queries without needing manual triggers or archive tables. -
24
tabix
Tabix.io UI
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. -
25
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
