👻Top 8 Free, Open Source SQL Clients🔥

This page summarizes the projects mentioned and recommended in the original post on dev.to

Our great sponsors
  • WorkOS - The modern API for authentication & user identity.
  • Onboard AI - ChatGPT with full context of any GitHub repo.
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • sqlchat

    Chat-based SQL Client and Editor for the next decade

    SQL Chat is a young player, prompting SQL clients from the traditional GUI-based to the Chat-based stage: it's powered by ChatGPT to write and polish SQL for you.

  • dbeaver

    Free universal database tool and SQL client

    DBeaver is a veteran SQL client. In addition to basic visualization and management capabilities, it has a SQL editor, data and schema migration capabilities, monitor database connections, and more. It supports a full range of databases (both SQL and NoSQL). DBeaver is also hooked up with GPT-3, which converts your natural language to SQL.

  • WorkOS

    The modern API for authentication & user identity. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    Beekeeper Studio is a modern (aesthetic) and lightweight SQL client that supports MySQL, Postgres, SQLite, SQL Server, etc. It is available on Linux, Mac and Windows.

  • dbgate

    Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

    DbGate works in Windows, Linux, Mac, and your web browsers without compromises in functionality. Both SQL and noSQL databases are supported, from MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, to CockroachDB.

  • sqlectron-gui

    A simple and lightweight SQL client desktop with cross database and platform support.

    Sqlectron is lightweight SQL client with simplicity in mind. It has cross-database (PostgreSQL, Redshift, MySQL, MariaDB, SQL Server, Cassandra, SQLite) and platform (Mac, Linux, Windows) support.

  • HeidiSQL

    A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi

    HeidiSQL is also a lightweight SQL client that supports a long list of databases including MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase and Firebird. In addition to basic SQL client functionalities, users can export structures and data to SQL files or copy them to the clipboard or other servers.

  • phpMyAdmin

    A web interface for MySQL and MariaDB

    phpMyAdmin was born in 1998, written in PHP, and is a classic SQL client. It was the default tool for LAMP and MAMP at that time. phpMyAdmin has grown to become one of the leading tools for managing MySQL and MySQL-like databases (e.g. MariaDB) It has over 200,000 direct downloads per month (and countless other users install it using prepackaged installations or using package managers).

  • Onboard AI

    ChatGPT with full context of any GitHub repo. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at app.getonboardai.com.

  • pgadmin4

    pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

    pgAdmin to PostgreSQL is what phpMyAdmin is to MySQL, and it can be used on Linux, Unix, macOS and Windows to manage PostgreSQL. pgAdmin 4, the latest pgAdmin, is a complete rewrite of pgAdmin using Python and Javascript/jQuery.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts