Open Source SQL Tools

All apps in Open Source SQL Tools category. Use the filters below to narrow down your search. 
Copy a direct link to this comment to your clipboard
  1. DBeaver icon
     373 likes

    A versatile, open-source database tool for developers and administrators supporting multiple databases via JDBC drivers with extensive plugins.

    Cost / License

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Flathub
    • Eclipse
    • Flatpak
    • Java
    DBeaver screenshot 1
    DBeaver screenshot 1
    DBeaver screenshot 2
    +3
    DBeaver screenshot 3
    181 alternatives
    4.5
    Excellent18 reviews
  2. SQLite icon
     351 likes

    SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Android
    • iPhone
    • Self-Hosted
    72 alternatives
  3. PostgreSQL icon
     323 likes

    PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • BSD
    • Self-Hosted
    PostgreSQL screenshot 1
    PostgreSQL syntax example
    75 alternatives
  4. phpMyAdmin icon
     285 likes

    phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

    Cost / License

    Application type

    Platforms

    • Linux
    • Online
    • Self-Hosted
    • PHP
    Main UI
    130 alternatives
  5. MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • BSD
    MySQL Workbench
    67 alternatives
  6. MariaDB icon
     142 likes

    MariaDB is a backward compatible, drop-in replacement of the MySQL® Database Server. It includes all major open source storage engines.

    Cost / License

    Application type

    Platforms

    • Windows
    • Linux
    • BSD
    Deploy
    Monitor
    Backup
    55 alternatives
  7. Open Source SQL Editor and Database Manager for MySQL, SQL Server, Postgres, Redshift, Sqlite and more.

    Cost / License

    • Freemium
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • MySQL Community Edition
    • MariaDB
    • Microsoft SQL Server
    • CockroachDB
    • Amazon Redshift
    • PostgreSQL
    Beekeeper studio screenshot 1
    Beekeeper studio screenshot 1
    Beekeeper studio screenshot 2
    +2
    Beekeeper studio screenshot 3
    107 alternatives
  8. DbGate icon
     31 likes

    DbGate is cross-platform database manager. Simple and effective, allowing to work with many various databases simultaneously - SQL and NoSQL.

    Cost / License

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Online
    • Flathub
    • Flatpak
    DbGate screenshot 1
    DbGate screenshot 1
    DbGate screenshot 2
    +3
    DbGate screenshot 3
    178 alternatives
    4.9
    Excellent8 reviews
  9. WhatTheDuck icon
     11 likes

    WhatTheDuck is an open-source web application built on DuckDB. It allows users to upload CSV files, store them in tables, and perform SQL queries on the data.

    Cost / License

    • Free
    • Open Source (MIT)

    Application type

    Platforms

    • Online
    • Self-Hosted
    WhatTheDuck screenshot 1
    WhatTheDuck screenshot 1
    WhatTheDuck screenshot 2
    +2
    WhatTheDuck screenshot 3
    37 alternatives
  10. The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance.

    Cost / License

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • BSD
    • Amazon Web Services
    • Google Cloud Platform
    • Microsoft Azure
    Apache Cassandra screenshot 1
    52 alternatives
  11. SurrealDB icon
     7 likes

    With an SQL-style query language, real-time queries with highly-efficient related data retrieval, advanced security permissions for multi-tenant access, and support for performant analytical workloads, SurrealDB is the next generation serverless database.

    Cost / License

    • Freemium
    • Open Source

    Platforms

    • Mac
    • Windows
    • Linux
    • Online
    • Self-Hosted
    • Kubernetes
    • Software as a Service (SaaS)
    • Docker
    SurrealDB screenshot 1
    13 alternatives
  12. Antares SQL icon
     5 likes

    Antares is an SQL client that aims to become an useful and complete tool, especially for developers.

    Cost / License

    • Free
    • Open Source (MIT)

    Platforms

    • Mac
    • Windows
    • Linux
    • Flathub
    Antares SQL screenshot 1
    Antares SQL screenshot 1
    Antares SQL screenshot 2
    +3
    Antares SQL screenshot 3
    40 alternatives
  13. DuckDB icon
     8 likes

    There are many database management systems (DBMS) out there. But there is no one-size-fits all database system. All take different trade-offs to better adjust to specific use cases. DuckDB is no different.

    Cost / License

    • Free
    • Open Source (MIT)

    Platforms

    • Mac
    • Windows
    • Linux
    8 alternatives
  14. Firebird icon
     21 likes

    Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Android
    • Android Tablet
    48 alternatives
  15. Sqlmap icon
     11 likes

    sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester and a broad range...

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Linux
    Sqlmap screenshot 1
    3 alternatives
  16. CockroachDB icon
     16 likes

    Cockroach is a distributed key/value datastore which supports ACID transactional semantics and versioned values as first-class features. The primary design goal is global consistency and survivability, hence the name.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Linux
    • BSD
    CockroachDB screenshot 1
    97 alternatives
  17. YDB icon
     4 likes

    YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions.

    Cost / License

    Application type

    Platforms

    • Self-Hosted
    • Docker
    60 alternatives
  18. PgManage icon
     2 likes

    PgManage is a modern graphical database client and administration toolkit, with a primary focus on PostgreSQL while also supporting other databases.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    Welcome Screen with recent DB connections and hotkey hints
    Creating new connection
    DB Query Interface
    +8
    Table Editor
    11 alternatives
  19. Azimutt icon
     4 likes

    Azimutt is an explorer for your database schema, similar to an Entity Relationship Diagram (ERD) but with features to handle big schema (up to 1000 tables) where most other ERD are too crowded.

    Cost / License

    • Freemium
    • Open Source (MIT)

    Application type

    Platforms

    • Online
    • Self-Hosted
    • Software as a Service (SaaS)
    View you schema in a beautiful way
    Save meaningful layouts to switch back to them later
    Find how to join two tables following foreign keys
    +1
    Get some schema recommendation to keep it great and consistent
    13 alternatives
  20. SQuirreL SQL icon
     56 likes

    SQuirreL SQL is an open-source Java SQL Client program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Flathub
    • Flatpak
    SQuirreL SQL screenshot 1
    SQuirreL SQL screenshot 1
    Object Tree of Session window
    +1
    Graph: Charts of tables and their relations
    95 alternatives