Repolode
Submit
oliverjessner

oliverjessner/sqlite-hub

A local-first desktop-style app and CLI for browsing, editing, querying, backing up, and exporting SQLite database files.

Open-source alternative to:DB Browser for SQLite

View on GitHubWebsite
Stars
61
Forks
7
Open issues
0
Last commit
7 days ago

What is it?

SQLite Hub is a focused manager for SQLite files that runs locally and does not upload your databases to a cloud service. It lets you browse tables with filters and inline row editing, switch to a spreadsheet-like Sheets view, and run SQL in a syntax-highlighted editor with query history, charts, and performance metrics.

Beyond querying, it covers schema work and maintenance: a Structure view with a relationship graph, a Table Advisor that produces a deterministic health report for each table, type generation for TypeScript, Rust, Kotlin, Swift, and Go, and a Table Designer for creating and editing tables with a live SQL preview. Verified local backups can be created, compared, and restored, and the app asks for a safety backup before risky statements such as DROP or ALTER.

The project also ships a CLI, a local JSON API protected by database-specific tokens, and an MCP server that agents can launch over STDIO. It is installable via Homebrew or npm.

Key features

  • 01Browse, filter, sort, and edit table rows with SQL diff preview before saving
  • 02Spreadsheet-like Sheets view with inline cell editing
  • 03Structure view with relationship graph and join previews
  • 04Table Advisor for per-table health findings and SQL suggestions
  • 05Type generation for TypeScript, Rust, Kotlin, Swift, and Go
  • 06Verified local backups with SHA-256 hashing and restore

Use cases

  • Inspecting a local SQLite file and editing a few rows without a heavyweight database client
  • Designing and migrating schemas with a live SQL preview and safety backups
  • Exporting query results to CSV, JSON, Markdown, or Parquet
  • Letting AI agents run read-only queries or insert rows through the MCP server

Quick start

  1. 1

    Install via Homebrew: tap the repository

    brew tap oliverjessner/tap
  2. 2

    Install the app with Homebrew

    brew install sqlite-hub
  3. 3

    Or install globally with npm

    npm install -g sqlite-hub
  4. 4

    Start the app on an alternative port

    sqlite-hub serve --port 4174

Things to know

  • The README does not state supported platforms beyond macOS, Windows, and Linux references for discovery paths.

In collections

MCP serversCLI & terminal toolsPrivacy & local-first toolsDatabases & SQL tools

Topics

#sqlite#database-management#local-first#sql-editor#database-backup#cli#mcp#sqlite-database#sqlite3

FAQ

What is sqlite-hub?
A local-first desktop-style app and CLI for browsing, editing, querying, backing up, and exporting SQLite database files. SQLite Hub is a focused manager for SQLite files that runs locally and does not upload your databases to a cloud service. It lets you browse tables with filters and inline row editing, switch to a spreadsheet-like Sheets view, and run SQL in a syntax-highlighted editor with query history, charts, and performance metrics.
Is sqlite-hub free to use? What license does it have?
sqlite-hub is open source under the MIT license. Check the license terms before using it in commercial products.
Is sqlite-hub still maintained?
Actively maintained. The last commit to sqlite-hub was on Oct 31, 2026.
What can I use sqlite-hub for?
Inspecting a local SQLite file and editing a few rows without a heavyweight database client Designing and migrating schemas with a live SQL preview and safety backups Exporting query results to CSV, JSON, Markdown, or Parquet Letting AI agents run read-only queries or insert rows through the MCP server
How do I install sqlite-hub?
Install via Homebrew: tap the repository: brew tap oliverjessner/tap Install the app with Homebrew: brew install sqlite-hub Or install globally with npm: npm install -g sqlite-hub Start the app on an alternative port: sqlite-hub serve --port 4174
Where can I get sqlite-hub?
The source code and installation instructions are on GitHub: https://github.com/oliverjessner/sqlite-hub

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects