dbnet

README

dbNet is a web-based SQL IDE using Go as a backend, and your browser (or electron) as front-end. I built it because I was unsatisfied with the database clients out there. Alot of them are top-heavy, unituitive, slow or expensive. dbNet aims to be smart and useful especially for analysis and simply querying any SQL database.

The goal is to make it a great SQL IDE which gives useful context as you hover table and column names for example. It should allow you to ingest files with ease, imagine drag-dropping a CSV file into a schema where dbNet auto-creates the table with proper column types. The other nifty part is that it can run from a shell/terminal on any machine and lets users access the UI from the browser (with dbnet serve).

dbNet is in active developement and will be open-sourced soon. Here are some of the databases it connects to:

• Clickhouse
• Google BigQuery
• Google BigTable
• MySQL
• Oracle
• Redshift
• PostgreSQL
• SQLite
• SQL Server
• Snowflake
• DuckDB
• ScyllaDB (coming soon)
• Firebolt (coming soon)
• Databricks (coming soon)

Installation

Brew on Mac

brew install dbnet-io/dbnet/dbnet

# You're good to go!
dbnet -h

Scoop on Windows

scoop bucket add dbnet https://github.com/dbnet-io/scoop-dbnet.git
scoop install dbnet

# You're good to go!
dbnet -h

Docker

docker pull dbnetio/dbnet

# You're good to go!
docker run --rm -it dbnetio/dbnet -h

Build from source

git clone https://github.com/dbnet-io/dbnet.git
cd dbnet

go mod tidy

# Ensure you have npm & yarn installed with NodeJS 16+
bash build.sh

./dbnet -h

Notes

Electron

• https://github.com/electron/electron-packager
• https://www.electron.build/
• nativefier -n DbNetClient --counter 'http://localhost:5987/'

Icons

https://github.com/jackmordaunt/icns cat icon.png | icnsify > icon.icns bash frontend/src-tauri/icons/generate.sh