A local-first SQLite manager designed for efficient database operations.

What it does

A comprehensive suite of tools for managing SQLite databases directly on your local machine. It empowers users to browse, edit, query, visualize, document, and export SQLite data without relying on cloud services or complex database clients. The platform is built with a local-first approach, ensuring your data remains under your control and accessible offline.

Key features

SQL Editor — Write, format, run, and reuse SQL queries with syntax highlighting, query history, and performance metrics.
Row Editing — Safely edit single-table SELECT results directly, with destructive and multi-statement SQL visible in history.
Schema Graph — Visualize database schema connectivity and relationships.
Charts — Create visual representations of your data.
Markdown Documents — Integrate Markdown for documentation directly within your database workspace.
Media Tagging — Organize and tag media assets associated with your data.
Exports — Export data in various formats including TXT, CSV, TSV, and Markdown.
Backups — Securely back up your SQLite databases.
CLI — Command-line interface for scripting and automation.

Use cases

Developers managing local SQLite databases for applications.
Data analysts visualizing and exploring SQLite datasets.
Users needing to document and export SQLite data without cloud dependencies.
Anyone seeking a streamlined, local-first SQLite management experience.

What makes it different

Its a strictly local-first architecture, eliminating cloud reliance for enhanced privacy and offline accessibility. Its integrated approach combines advanced SQL editing with intuitive data visualization and documentation tools in a single, user-friendly interface.

Oliver Jessner

Projects

SQLite Hub

Oliver Jessner

Projects

SQLite Hub