Ask HN: Tools to visualize data in SQL database?

1

Observable

It doesn't speak MariaDB (yet - I have a long-term goal to investigate adding alternative database backends as plugins) but you can instead use the https://datasette.io/tools/db-to-sqlite CLI tool to convert a PostgreSQL or MySQL (or other SQL Alchemy supported) database to SQLite, then use Datasette against the resulting file. This actually works pretty well for small (<1GB) databases, where you can run a cron periodically to build the SQLite version. Then you can visualize with plugins such as https://datasette.io/plugins/datasette-cluster-map or https://datasette.io/plugins/datasette-vega I also often load data into Datasette and then do custom visualizations in Observable Notebooks by fetching data back out through the Datasette JSON API - here's an example notebook that does that, using the Observable Plot charting library: https://observablehq.com/@simonw/datasette-downloads-per-day-with-observable-plot.

#Data Visualization #Data Dashboard #Data Science Notebooks 283 social mentions

2

Arctype

You should check out Arctype! (https://arctype.com) We're trying to re-imagine popular SQL clients (phpMyAdmin, MySQL Workbench) to have the design and software quality of modern tools like Superhuman, Linear, etc. We make it very easy to query and create charts from your database then share it with your team. We currently support MySQL, Postgres, PlanetScale, Yugabyte, and in the next couple of weeks SQLite and ClickHouse.

#Developer Tool #MySQL #PostgreSQL 36 social mentions

3

Redash

Redash(https://redash.io/) is pretty easy to use and get up and started with, especially if you know SQL. It's free and open source.

#Data Dashboard #Business Intelligence #Data Visualization 19 social mentions

4

Whaly

Maybe not exactly what you are looking for but https://whaly.io can do the trick !

#Data Analysis #Data Analytics #SaaS 19 social mentions

5

Metabase

Metabase is what you're looking for. https://metabase.com/.

#Business Intelligence #Data Dashboard #Data Analysis 14 social mentions

6

Basetool

Https://basetool.io Credentials to admin panel in one click.

#App Builder #Data Management #No Code 1 social mentions

7

Trevor.io

Couple of tools not yet mentioned: PopSql - https://popsql.com Trevor - https://trevor.io.

#Data Dashboard #Business Intelligence #Data Visualization 2 social mentions

8

PopSQL

Couple of tools not yet mentioned: PopSql - https://popsql.com Trevor - https://trevor.io.

#Data Dashboard #Business Intelligence #Database Tools 5 social mentions