Browse, edit, query, generate test data, back up, visualize, and export SQLite databases through a focused GUI, built-in CLI, local API, and MCP server.
$ brew tap oliverjessner/tap$ brew install sqlite-hub
npm alternative:
npm install -g sqlite-hub
Database overviewYour SQLite database stays a file—not a platform.
LOCAL-FIRST
OPEN SOURCE
GUI + CLI + API + MCP
SYNTHETIC DATA
BACKUPS
TYPE GENERATION
CSV
TSV
JSON
Markdown
PARQUET
Developer feedback
What developers say about SQLite Hub.
Feedback from developers working with SQLite and local data.
“
SQLite is widely used in every smartphone, browser, and OS. Yet we never had a clean tool like this to work with it. This fills a real gap.
Why
Why SQLite Hub?
01
Focused on SQLite
No generic multi-database complexity. SQLite Hub is designed around local SQLite workflows.
02
Local by design
Work directly with database files on your machine without uploading them to a hosted platform.
03
Safer changes
Inspect generated SQL, create backups, and keep control when editing data or changing schemas.
04
Built for automation
Use the same databases through the graphical interface, command-line tools, local JSON API, or MCP tools for agents.
Product tour
Four core workflows.
SQLite Hub keeps the common SQLite work loop short: understand the file, make careful changes, automate repeatable work, and export without lock-in.
01 / Data
Explore, edit, and generate data
Browse tables, inspect complete records, filter large datasets, safely edit individual rows, and generate synthetic rows for testing.
Search, sort, filter, and page through dense local tables without turning SQLite into a hosted system.
Open full records, preview typed values, review generated SQL, and update or delete only safely identifiable rows.
Generate synthetic records directly from the Data menu when you need realistic local test data without touching production data.
Data Viewer
Row Editor
Synthetic Data
Filtering
Safe editing
Data
Browse table dataFilter, sort, search, paginate, and export table data from a focused local workspace.Edit a rowPreview typed values and generated SQL before applying a precise row change.Generate synthetic dataCreate realistic sample rows for local testing, demos, and development databases.
02 / SQL
Query and analyze
Write and run SQL, inspect execution details, reuse query history, and export complete result sets.
Format SQL, run with keyboard shortcuts, inspect execution details, and keep query history scoped to the database.
Export full result sets as CSV, TSV, JSON, Markdown, or Parquet, or turn query results into charts.
SQL Editor
Query History
Execution details
Result export
SQL Editor
Editor and resultsRun SQL, inspect results, and switch between Results, Performance, and Messages.Export query resultsExport complete query results into portable formats instead of copying partial grids.
03 / Schema
Understand and change the schema
Inspect tables, indexes, relationships, and DDL. Design schema changes and generate application types from your database.
Design table changes with live SQL preview and generate TypeScript, Rust, Kotlin, or Swift types from the schema.
Structure
Table Designer
Generate Types
DDL
Structure
Relationship graphUnderstand how tables connect before changing schema or data.Generate application typesGenerate TypeScript, Rust, Kotlin, or Swift definitions from the active schema.
Table Designer
Design table changesConfigure columns, keys, defaults, constraints, and preview SQL before applying schema changes.
04 / Backups and exports
Protect and move your data
Create verified backups before risky changes and export complete tables or query results into portable formats.
Backups are created through SQLite, hashed with SHA-256, and verified before restore.
Export complete tables or query results as CSV, TSV, JSON, Markdown, or Parquet.
Verified backups
Restore
Open exports
No lock-in
Backups
Backup managerCreate, review, verify, restore, download, and delete managed local backups.
Exports
Export table dataMove complete data sets out of SQLite Hub as portable files.
Beyond browsing
More than a database browser
Secondary tools stay available without taking over the main workflow.
DOC
Markdown Documents
Keep database-scoped notes beside the data. Insert saved-query tables or notes when you need context.
CHART
Charts
Turn saved query results into bar, line, pie, donut, or scatter charts. Export charts as PNG.
TAG
Media Tagging
Configure media and tag tables, then work through image, video, or audio queues.
CONN
Connection Management
Open local files, label connections, use custom icons, and keep recent databases close.
VIEW
Database Overview
Review storage, schema connectivity, runtime, and access details in one place.
OK
Database Health
Check integrity, object counts, foreign-key clusters, isolated tables, and largest tables.
SAVE
Saved Queries
Name useful queries, add notes, reopen them, and use them from the GUI, CLI, or API.
HIST
Query History
Keep database-scoped query history for repeated analysis and safer iteration.
MCP
MCP Server
Connect Codex and other agents to structured SQLite Hub tools for schema inspection, read-only queries, query plans, backups, and type generation.
Interfaces
One database. Four interfaces.
Work interactively in the GUI, automate repeatable workflows from the terminal, connect development tools through the local API, or give agents structured access through MCP.
GUI
GUI
Browse, edit, query, visualize, document, and manage SQLite databases interactively.
>_
CLI
Inspect schemas, execute SQL, export results, create backups, and generate types from the terminal.
Your database remains a standard SQLite file. Export complete tables and query results as CSV, TSV, JSON, Markdown, or Parquet—and continue using them in scripts, notebooks, reports, and other database tools.
No proprietary project format. No hosted database layer. Your data stays portable.
Use cases
When SQLite Hub helps.
Common jobs where a focused SQLite workspace is faster than switching between tools.
01
Explore an unfamiliar database
Understand tables, relationships, indexes, and sample data before changing anything.
02
Clean or correct records
Find problematic rows, create a backup, preview the generated SQL, and apply precise changes.
03
Generate realistic test data
Create synthetic rows for demos, local development, and test databases without copying sensitive production data.
04
Automate and share results
Run saved queries through the CLI or API and export complete datasets into open formats.
Install
Install SQLite Hub.
Homebrew is the primary path on macOS and Linux. npm is available for global installs, and GitHub Releases remain linked for release notes and artifacts.
macOS
Linux
Windows
$
HomebrewPrimary install path for macOS and Linux
$ brew tap oliverjessner/tap$ brew install sqlite-hub
No. SQLite Hub is built for local SQLite files and runs against the database on your machine. It does not require a hosted database layer.
Which platforms and installation methods are supported?
SQLite Hub lists macOS, Linux, and Windows support. Install with Homebrew on macOS/Linux or npm globally; release notes and artifacts are available on GitHub.
Is SQLite Hub free and open source?
Yes. SQLite Hub is free, open source, MIT licensed, and available on GitHub.
Can I use SQLite Hub without the GUI?
Yes. Use the built-in CLI for terminal workflows, the local JSON API for scripts and development tools, or MCP for Codex and other agents.
Can SQLite Hub generate synthetic data?
Yes. The Data menu includes synthetic data generation for creating local sample rows for testing, demos, and development workflows.
Does the MCP server give agents unrestricted database access?
No. MCP exposes defined SQLite Hub tools such as schema inspection, read-only queries, query-plan analysis, backups, and type generation instead of unrestricted file access.
Get started
Open your SQLite database and start working.
Install SQLite Hub, open a local file, and use the GUI, CLI, local API, or MCP without moving your database into a hosted platform.
