Open Source Database Tools & GUIs Software

Database Tools & GUIs provide graphical interfaces for managing structured data and executing SQL queries. These tools replace command line interactions with visual editors for modifying schemas, designing entity relationship diagrams, and browsing table rows. This type of software serves developers and data analysts who need to visualize complex database architectures. Self-hosting these apps ensures that sensitive connection strings and database credentials remain on private infrastructure. These tools allow you to manage multiple database engines and automate migration scripts without relying on external cloud management platforms.

This page lists 18 open source tools in the Database Tools & GUIs category. The most popular are NocoDB, drawDB and Chat2DB. Most use the AGPL-3.0 or Apache-2.0 license, and 16 offer an official Docker image.

NocoDB

Low-Code/No-Code

Turns existing databases into no-code platforms by providing a spreadsheet interface for data management and API generation.

64k StarsWeb App / Server

drawDB

Database Tools & GUIs

A browser based database schema editor for creating entity relationship diagrams and generating SQL scripts without accounts.

38k StarsWeb App / Server

Chat2DB

Database Tools & GUIs

A database client and SQL workspace that uses AI to convert natural language into SQL queries.

27k StarsWeb App / Server

Beekeeper Studio

Database Tools & GUIs

A cross-platform SQL editor and database manager for managing multiple database types via a desktop interface.

23k StarsDesktop App

ChartDB

Database Tools & GUIs

Visualize and design database schemas using smart queries to generate interactive diagrams and SQL migration scripts.

23k StarsWeb App / Server

Teable

Low-Code/No-Code

A self-hosted database platform that combines a spreadsheet interface with the ability to scale to millions of rows.

22k StarsWeb App / Server

Bytebase

CI/CD Platforms

Manage database schema changes through a web based workspace with GitOps integration and automated SQL review workflows.

14k StarsWeb App / Server

Tiny RDM

Database Tools & GUIs

Manage Redis databases through a lightweight graphical interface with support for clusters, sentinel mode, and SSH tunnels.

13k StarsDesktop App

Datasette

Database Tools & GUIs

Explore and publish data by converting SQLite databases into interactive websites with accompanying JSON APIs.

11k StarsWeb App / Server

Adminer

Database Tools & GUIs

A database management tool contained within a single PHP file for easy deployment to servers.

7.5k StarsWeb App / Server

DbGate

Database Tools & GUIs

Manage multiple SQL and NoSQL databases through a single interface with visual query building and schema comparison.

7.2k StarsDesktop App

Mathesar

Database Tools & GUIs

Provides a spreadsheet-like web interface for viewing, editing, and querying PostgreSQL data without coding.

5.1k StarsWeb App / Server

CloudBeaver

Database Tools & GUIs

A web based database manager providing a rich interface for managing and querying various database systems.

5k StarsWeb App / Server

Sqlectron

Database Tools & GUIs

A lightweight SQL client providing a graphical interface for managing multiple database types across different operating systems.

4.8k StarsDesktop App

Tabularis

Database Tools & GUIs

A desktop SQL workspace with notebooks and AI integration for PostgreSQL, MySQL, SQLite and other databases.

3.9k StarsDesktop App

NetPad

General Purpose Editors

A cross-platform C# editor and playground for running code snippets without creating full projects.

2.3k StarsDesktop App

Azimutt

Database Tools & GUIs

Visualize, document, and analyze complex database schemas through interactive entity relationship diagrams and data navigation tools.

2.2k StarsWeb App / Server

Conar

Database Tools & GUIs

Manage multiple database connections with AI assisted SQL query writing and encrypted storage for various database engines.

1.4k StarsWeb App / Server
Open Source Software.io

Join our newsletter to get shiny new open source software delivered to your inbox. Unsubscribe anytime.