Databases viewers/ editors

structured data storage for completists and “data science”

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.

  • dbeaver

    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.

    (Java Eclipse app)

  • sqlitebrowser does only sqlite but is open source and featureful.

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

  • datasette provides a read-only Web JSON api for SQLite

  • sqlectron

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

    Unmaintained.

  • sqlite-viewer is a pire in-browser SQLite file viewer

  • 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.