sqlitebrowser

GUI editor for SQLite databases

TLDR

Open a database file

$ sqlitebrowser [database.db]

Open a database in read-only mode

$ sqlitebrowser -R [database.db]

Execute a SQL file after opening

$ sqlitebrowser -s [script.sql] [database.db]

Import a CSV file

$ sqlitebrowser --import-csv [data.csv] [database.db]

Open to a specific table

$ sqlitebrowser -t [tablename] [database.db]

SYNOPSIS

sqlitebrowser [options] [database]

sqlitebrowser (DB Browser for SQLite) is a visual, open-source tool for creating, designing, and editing SQLite database files. It provides a spreadsheet-like interface for browsing data, an SQL editor for running queries, and tools for managing tables, indexes, and triggers.Despite being a graphical application, it supports useful command-line options for automation, such as importing CSV files, executing SQL scripts, and opening specific tables.

PARAMETERS

-h, --help

Show command-line options.

-v, --version

Display version.

-q, --quit

Exit after executing scripts.

-s FILE, --sql FILE

Execute SQL file after opening database.

--import-csv FILE

Import CSV file into database.

-t TABLE, --table TABLE

Browse a specific table on startup.

-R, --read-only

Open database in read-only mode.

-S FILE, --settings FILE

Use specified settings file.

-o SETTING, --option SETTING

Temporarily set a setting (group/setting=value).

--in-memory

Start with an in-memory database.

CAVEATS

This is a GUI application that requires a display server. The command-line options configure how the graphical window launches. Not a replacement for the sqlite3 command-line shell.