Databases viewers / editors


If you want to access databases and query/interact/edit them there are myriad options. I’ve split off the tools that specialize in visualisation and plotting under data dashboards. You can sometimes get db-editing like behaviour out of spreadsheets.

CastleDB

CastleDB is used to input structured static data.

Everything that is usually stored in XML or JSON files can be stored and modified with CastleDB instead.

CastleDB looks like any spreadsheet editor, except that each sheet has a data model.

The model allows the editor to validate data and eases user input.

.For example, when a given column references another sheet row, you will be able to select it directly.

CastleDB stores both its data model and the data contained in the rows into an easily readable JSON file.

It uses the JSON format with newlines to store its data, which in turn allows RCS such as GIT or SVN to diff/merge the data files.

Adorably it comes with a video gam map tile editor.

Sqlite browser

sqlitebrowser does only sqlite but is open source and featureful.

sqlite studio

sqlitestudio is a qt-based sqlite manager/browser, also open source.

MySQL Workbench

MySQL workbench is the MySQL graphical tool for database administration. I stopped using this years ago (Version 5.1) because it was unusably unstable and would constantly crash. Maybe it is better these days, a few versions later, but I not longer use MySQL.

datasette

datasette provides a read-only Web JSON api for SQLite. This makes it easy to bui;d tools that visualise the data, although is not an actual UI as such.

sqlelectron

sqlectron

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

Undermaintained.

redash

redash (redash source)

Redash consists of two parts:

  • Query Editor Think of JS Fiddle for SQL queries. It’s your way to share data in the organization in an open way, by sharing both the dataset and the query that generated it. This way everyone can peer review not only the resulting dataset but also the process that generated it. Also it’s possible to fork it and generate new datasets and reach new insights.

  • Dashboards/Visualizations once you have a dataset, you can create different visualizations out of it, and then combine several visualizations into a single dashboard. Currently it supports charts, pivot table and cohorts.

dbeaver

dbeaver(Java Eclipse app)

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.