SQLite Hub | Local-first SQLite Manager and CLI
Install<br>Local database work, focused in SQLite Hub.<br>Browse, edit, query, visualize, document, and export SQLite data without a cloud layer or a heavyweight database client.
Install SQLite Hub
Explore the features
Database overviewHealth, storage, schema connectivity, and database details in one overview.
Product tour<br>Explore the core SQLite Hub workflows.<br>Each workspace stays close to the active local database and keeps the next practical action within reach.
01 / SQL Editor<br>Write, format, run, and reuse SQL.<br>The syntax-highlighted editor keeps drafts, query history, saved queries, results, performance metrics, messages, and export actions in one workspace.<br>Run with Shift + Enter, format SQL, search history, and attach titles or notes to saved queries.<br>Inspect execution time, statement counts, returned or affected rows, errors, and serialized result size.<br>Copy full columns, headers, or first-10 previews; export TXT, Markdown todos, CSV, TSV, Markdown, or a duplicate table.<br>Interactive results stay bounded at 5,000 rows while full exports keep complete rows and BLOB values.<br>Edit or delete direct single-table SELECT results when a stable row identity is available; destructive and multi-statement SQL stays visible in history and Messages.<br>Syntax highlighting<br>Query details<br>Column export<br>Result export
SQL Editor
‹›
Editor and results Run and format SQL, inspect results, and switch between Results, Performance, and Messages.Query details Search database-scoped history, save useful queries, and maintain titles and notes.Export a column Copy a complete column, include its header, preview the first values, or export it as TXT.Format a column as Markdown Turn a selected result column into Markdown todo items or a new database-scoped document.Export the complete result Export the complete query as CSV, TSV, or Markdown, or duplicate the result as a table.
02 / Data<br>Filter, export, and safely edit table data.<br>Browse up to 250 rows per page, search tables, combine column/operator/value filters, sort wide grids without losing scroll position, and export complete table data.<br>Export tables as CSV, TSV, or Markdown, or duplicate an export into a new table.<br>Compact cell previews handle long values, BLOBs, and file paths while exports retain complete content.<br>The Row Editor previews SQL changes, JSON, URLs, file paths, timestamps, text lengths, NULL states, and supported CHECK values; full-row JSON can be copied or exported.<br>Updates and deletes are enabled only when SQLite Hub has a stable primary-key or rowid identity.<br>Table browser<br>Row editor<br>CSV export<br>Simple backups
Data
‹›
Browse table data Filter, sort, paginate, and export full tables while keeping dense datasets manageable.Edit a row Preview typed values and generated SQL before updating or deleting a safely identifiable row.
03 / Documents<br>Keep Markdown notes beside each database.<br>Documents are local Markdown files scoped to the active database, with autosave, independent editor and preview scrolling, imports, exports, and flexible pane visibility.<br>Create, rename, delete, import, and export Markdown documents without leaving SQLite Hub.<br>Preview lists, tables, code blocks, links, and clickable task-list checkboxes.<br>Insert saved-query result tables or saved notes, and create documents from Markdown todo column exports.<br>Markdown notes<br>Autosave<br>Query inserts<br>Import and export
Documents
Markdown documents Edit and preview database-scoped Markdown with autosave and saved-query inserts.
04 / Charts<br>Turn saved query results into local charts.<br>Create charts from chartable SELECT entries in query history, render them from live query results, and save multiple chart configurations per query.<br>Build bar, line, pie, donut, and scatter charts with compatible column controls.<br>Configure sorting, labels, legends, line smoothing, scatter series, and optional point sizing.<br>Resize, edit, reopen, delete, and export charts as PNG.<br>Bar charts<br>Line and pie<br>Scatter plots<br>PNG export
Charts
‹›
Bar chart Compare grouped counts or values across categories with a saved bar chart.Pie chart Inspect the relative share of categories in a compact pie chart.Scatter plot Compare two numeric dimensions and inspect distribution or clustering in a scatter plot.
05 / Structure<br>Inspect schema objects and relationships.<br>Search tables, views, indexes, and triggers, inspect columns and DDL, and move through a relationship graph that keeps the current table selected between views.<br>Review declared types, primary keys, nullability, foreign keys, indexes, triggers, views, and copied DDL.<br>Fit or relayout the graph, clear selections, hide panels, and jump directly to table data.<br>Keep the last selected table while moving between Structure, Data, and related workflows.<br>Relationship graph<br>Table inspector<br>Columns and types
Structure
‹›
Table relationship graph See tables and their links in one navigable schema graph.Structure inspector Select a table...