Repolode
Submit
coleifer

coleifer/sqlite-web

A web-based SQLite database browser written in Python, for viewing, editing and importing or exporting SQLite data from a browser.

Open-source alternative to:DB Browser for SQLite

View on GitHub
Stars
4,179
Forks
407
Open issues
0
Last commit
2 days ago

What is it?

sqlite-web is a web-based browser for SQLite databases, built on Flask and peewee. You start it from the command line against one or more database files, then manage tables, columns, indexes and rows through a page in your browser without writing SQL for everyday tasks.

The interface covers the common workflow: an index page with table and index counts and file size, a structure tab for columns, indexes, triggers and foreign keys, a content tab with sorting and pagination, and a query tab that runs arbitrary SQL and exports results as JSON or CSV. CSV and JSON files can be imported into a table, with an option to create columns for unrecognized keys.

It can run in read-only mode, be protected with a password, or serve over SSL. Additional databases can be uploaded or, if enabled, loaded from disk at runtime. A Docker image is provided, and a gevent-based sqlite_wsgi entry point is available for higher-throughput serving.

Key features

  • 01Add, drop or rename tables, columns and indexes, including on older SQLite versions.
  • 02Insert, update and delete rows through the browser.
  • 03Run arbitrary SQL queries and export results as JSON or CSV.
  • 04Import CSV or JSON files into a table.
  • 05Protect access with a password and optionally run in read-only mode.
  • 06Load additional databases at runtime when enabled.

Use cases

  • Quickly inspecting or editing a local SQLite file without installing a desktop client.
  • Exploring a database shipped inside an app or container during development.
  • Importing CSV or JSON data into a SQLite database for analysis.
  • Sharing a read-only view of a database on a local network with password protection.

Quick start

  1. 1

    Install sqlite-web with pip

    pip install sqlite-web
  2. 2

    Run sqlite-web against your database file

    sqlite_web /path/to/database.db
  3. 3

    Open http://localhost:8080/ in your browser to view the database

Things to know

  • Exposing the browser over the network requires adding a password or SSL yourself, since the defaults bind to localhost only.

In collections

Databases & SQL tools

Topics

#sqlite#database-browser#python#flask#web-ui#csv-import#sql#database

FAQ

What is sqlite-web?
A web-based SQLite database browser written in Python, for viewing, editing and importing or exporting SQLite data from a browser. sqlite-web is a web-based browser for SQLite databases, built on Flask and peewee. You start it from the command line against one or more database files, then manage tables, columns, indexes and rows through a page in your browser without writing SQL for everyday tasks.
Is sqlite-web free to use? What license does it have?
sqlite-web is open source under the MIT license. Check the license terms before using it in commercial products.
Is sqlite-web still maintained?
Actively maintained. The last commit to sqlite-web was on Nov 5, 2026.
What can I use sqlite-web for?
Quickly inspecting or editing a local SQLite file without installing a desktop client. Exploring a database shipped inside an app or container during development. Importing CSV or JSON data into a SQLite database for analysis. Sharing a read-only view of a database on a local network with password protection.
How do I install sqlite-web?
Install sqlite-web with pip: pip install sqlite-web Run sqlite-web against your database file: sqlite_web /path/to/database.db Open http://localhost:8080/ in your browser to view the database
Where can I get sqlite-web?
The source code and installation instructions are on GitHub: https://github.com/coleifer/sqlite-web

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

Related projects