otty / apps
All apps/SQLite

SQLite

sqlite3

A simple command-line program that lets the user manually enter and execute SQL statements against an SQLite database.

Runs as sqlite3|macOS, Linux, Windows|sqlite.org
Open form in Otty otty.toml

Command form

ai-draft · 2 tasks · 14 fields

Open a database in the sqlite3 shell with a chosen output mode and options. Memory tuning, VFS and tracing flags are left out.

Opens the form; the finished command lands at your prompt, unrun
Run in Otty
otty gui sqlite3
SQLite shellExample values, fixed in this page — nothing here reaches a terminal
Basic
Database file*
file
Read-only
-readonly
Headers on
-header
TasksEach one presets the form for one job
Open a database
databasereadonlyheader
CSV with headers
databasereadonly
ParametersOnly these flags are editable in the form
Database file
Database file to open; blank opens a transient in-memory database.
path · positional 0
Read-only
Open the database read-only.
boolean
-readonly
CSV output
Set output mode to 'csv'.
boolean
-csv
Column output
Set output mode to 'column'.
boolean
-column
HTML output
Set output mode to HTML.
boolean
-html
Line output
Set output mode to 'line'.
boolean
-line
Headers on
Turn headers on.
boolean
-header
Headers off
Turn headers off.
boolean
-noheader
Commands before stdin
Run each command before reading stdin.
string · repeatable
-cmd
Init file
Read and process the named file.
path
-init
Column separator
Set output column separator.
string
-separator
NULL text
Set text string for NULL values.
string
-nullvalue
Stop on error
Stop after hitting an error.
boolean
-bail
Echo commands
Print commands before execution.
boolean
-echo
SourcesEvery flag above is checked against these
fig
completion

github.com

Before it fills your prompt, Otty checks the installed sqlite3 against its version. A form that does not match your version is not offered.