GizmoSQL

The GizmoSQL app turns your iPhone or iPad into a high-performance SQL database server using the Arrow Flight SQL protocol — the same columnar data transfer standard used in enterprise analytics.

START A SERVER IN SECONDS

Choose DuckDB or SQLite as your backend, tap Start, and you have a fully functional database server running on your device. Connect from laptops, desktops, or other devices on your network using any Arrow Flight SQL client — including JDBC, ADBC (Go, Python, C++), ODBC, and Node.js drivers.

DUCKLAKE COMPATIBLE

Access your DuckLake using your GizmoSQL mobile server. The PostgreSQL and httpfs extensions are pre-loaded so you can connect to and query your data lake seamlessly.

BUILT-IN SQL CLIENT

Write and execute SQL queries directly on your device with a terminal-style interface. Features include syntax highlighting, box-drawing table output, query timing, and automatic result pagination for large datasets.

DATA BROWSER

Explore your database visually. Navigate catalogs, schemas, and tables. View column names, types, and constraints. Preview data and manage tables — all without writing a query.

KEY FEATURES

- DuckDB and SQLite database backends

- Arrow Flight SQL protocol for high-performance columnar data transfer

- Automatic TLS encryption with self-signed certificates

- Username/password authentication with JWT session tokens

- Configurable query timeout, logging, and init SQL commands

- Export database files via the Files app — copy to iCloud Drive, AirDrop, or any sharing method

- Real-time server logs with color-coded severity levels

- Active session monitoring

BUILT FOR ANALYTICS

DuckDB is an analytical database engine optimized for complex queries over large datasets. Combined with Arrow Flight SQL's columnar transport, GizmoSQL delivers fast query results whether you're running TPC-H benchmarks or exploring real-world data on the go.

CONNECT FROM ANYWHERE ON YOUR NETWORK

Once the server is running, any device on the same Wi-Fi network can connect using the displayed connection string. GizmoSQL supports the full Arrow Flight SQL protocol including prepared statements, transactions, catalog metadata, and bulk data ingest.

See: https://gizmodata.com/gizmosql for more details.

View the source code at: https://github.com/gizmodata/gizmosql