SQLite Hub logo SQLite_Hub Install

A sharper way to work with SQLite.

Browse, inspect, visualize, export, back up, edit, and query local databases in a focused interface.

Install See the Interface
Homebrew Install in two lines 
$ brew tap oliverjessner/tap$ brew install sqlite-hub
npm Global install 
$ npm install -g sqlite-hub
Focused desktop workflow

Inside the app

Connections, structure, data, and SQL in one quiet workspace.

The interface stays sharp, dark, and close to the work whether you open a database, inspect schema, browse rows, or run queries.

Connections

Jump back into local databases without ceremony.

Recent SQLite files and connection shortcuts stay close so you can reopen work quickly instead of hunting through folders.

  • Recent files
  • Shortcuts
  • Quick access
Local files

Structure

Inspect schema without losing pace.

Columns, types, and relationships stay easy to scan when you need to understand the shape of a file quickly.

  • Columns
  • Types
  • Schema detail

Table structure

schema view

Scan columns, types, and schema details without leaving the main structure view.

Open the inspector when you want deeper detail for one table and its fields.

SQL Editor

Write queries with a cleaner edge.

The editor keeps query writing, results, and syntax highlighting in a single dark frame, while query history lets you save SQL with names and notes, search it later, and see how often each query ran.

  • Saved queries
  • Search
  • Run counts

Query flow

editor live

Write and run SQL with syntax highlighting and results directly below the editor.

Save queries with names and notes, search them later, and track how often they were executed.

Editing

From browse state to row edit, without context switching.

Flip between the table and the record editor in the same visual frame.

  • Browse rows without leaving the data view.
  • Open one record and edit it in place.
  • Export CSV files or create a quick backup before bigger changes.

Live preview

table live

Scan rows, sort fast, export CSV, keep moving.

Open one record, change the fields, commit, continue.

Install

Install with Homebrew or npm.

Pick the setup that fits your workflow and get straight to the database.

Homebrew if you want the tap. npm if you want the one-liner.

Homebrew
Install in two lines 
$ brew tap oliverjessner/tap$ brew install sqlite-hub
npm
Global install 
$ npm install -g sqlite-hub

CLI

Create in the UI, automate from the CLI if you want to.

SQLite Hub stays interface-first, but the CLI gives you quick access to help text, version info, imported database metadata, table names, and saved query execution.

Use the UI for the visual work. Use the CLI when Terminal is the faster move.

General
Basics 
--help                      Show this help text.--port:PORT                 Start the server on a custom port.--version                   Show the version number.
Database + SQL Editor
Inspect and run 
--database                  List all imported databases.--database-path:name        Get the file path of a database by name.--database-size:name        Get the size of a database by name.--database-lastopened:name  Get the last opened timestamp of a database by name.--database-tables:name      Get all table names from a database.--database:name --sqleditor List all saved queries for a database.--database:name --sqleditor:"query"  Execute a saved query by name.

FAQ

A few quick answers.

Short, direct, and close to the product.

Is SQLite Hub local-first?

Yes. SQLite Hub is built around local SQLite files and fast desktop workflows instead of hosted dashboards or enterprise layers.

How do I install SQLite Hub?

Install it either with Homebrew using `brew tap oliverjessner/tap` and `brew install sqlite-hub`, or globally with npm using `npm install -g sqlite-hub`.

Can I browse data, edit rows, and run SQL in one place?

Yes. SQLite Hub combines structure inspection, graph visualization, data browsing, row editing, CSV export, simple backups, and a syntax-highlighted SQL editor in one focused interface.

Can I export data or make a backup?

Yes. You can export table data or query results as CSV, and create a simple backup before you make larger changes to a database file.

Does SQLite Hub have a CLI?

Yes. SQLite Hub also includes a CLI for help and version output, imported database metadata, table listings, and running saved SQL editor queries by name.

Who is SQLite Hub for?

It is built for developers and technical users who want a clean, local tool for working with SQLite without extra platform noise.

SQLite Hub

Built for fast local SQLite work.

Open a database. Inspect the structure. Visualize tables. Export CSV. Run SQL.

Get source code