Hardcharger

Hardcharger puts a complete analytical SQL server on your iPhone or iPad. The same hardcharger-server that runs on Linux, macOS and Windows, with DuckDB 2.0 and its built-in extensions, is built into the app. Nothing leaves the device unless you ask it to. WEB UI The server's own web interface, signed in automatically: a SQL editor, a results grid, a schema browser, sessions, an API page and file uploads. Point it at a saved remote server instead with one tap. CONSOLE The hardcharger command-line client inside the app, with its dot commands (.tables, .schema, .mode table|csv|json|markdown|line, .timer, .maxrows and more) and output formatting. Return runs a statement once it ends with a semicolon; swipe through history; Command-Return on iPad. YOUR FILES Import CSV, TSV, JSON and Parquet from the Files app, the share sheet, or a drop on iPad. The database lives in Files (On My iPhone › Hardcharger), so you can back it up, copy it, or open it elsewhere. SHARE ON LOCAL NETWORK (off by default) Turn it on and a laptop on the same Wi-Fi opens the web UI over TLS at the address in the QR code, checking the certificate fingerprint the app shows. A second QR code adds the server to another iPhone or iPad. OTHER SERVERS Save Hardcharger servers anywhere else, with credentials in the Keychain. Sign in with a user name and password, or with the server's single sign-on in a secure browser session. A self-signed server is trusted by its fingerprint only when you say so. ON iPAD A sidebar, keyboard shortcuts (⌘1–⌘6 for screens, ⌘I import, ⌘⇧L sharing, ⌘R reload, ⌘⇧R and ⌘. start and stop), multiple windows and Stage Manager. Hardcharger is open source (Apache 2.0) from GizmoData: https://github.com/gizmodata/hardcharger