sqliter: Manage SQLite Databases in a Web Interface

Overview

SQLiter provides a browser-based interface for working with SQLite files. It combines table browsing and data editing with a SQL editor, so users can handle routine database tasks without switching between command-line tools and separate GUI applications.

The project is aimed at developers and others who need a local or self-hosted way to inspect and modify SQLite data. Its Go backend and React frontend are packaged together as a single executable, and the README also documents Docker use.

Key Features

• Browse database tables and inspect column metadata, constraints, and primary keys.
• Create, edit, and delete rows, including inline edits and batch changes.
• Filter, sort, and paginate table data, with filter and sort settings persisted in the URL.
• Run custom SQL with syntax highlighting, completion, query timing, and result display.
• Export query results to CSV.
• Connect to a SQLite database file through a REST API and web interface.

Use Cases

• Developers can inspect and make targeted changes to a local SQLite database during development.
• Small application teams can use the interface for occasional data maintenance without building a custom admin panel.
• Analysts or support staff can run SQL queries and export results when they need to investigate stored application data.
• Operators can launch a database editor in a Docker container when a browser-based interface is more convenient than a desktop tool.

Getting Started

Build and run with Docker, mounting the database file you want to open:

docker build -t sqliter .
docker run -p 2826:2826 -v /path/to/your/database.db:/data/database.db sqliter --db /data/database.db

Then open http://localhost:2826. See the README for source builds, development, and API details.

Considerations

• The application can modify and delete database rows, so use care when connecting it to important data and keep backups.
• It is a relatively new project, created in 2025, with 47 stars and one open issue in the supplied repository data. Evaluate its current behavior before relying on it for critical workflows.
• The repository metadata lists TypeScript as its language, while the README describes a Go backend and React/TypeScript frontend. The README's build instructions require Go and Node.js/npm for a source build, or Docker for the container workflow.