GizmoSQL
No in-app products collected for this app.
| Rating | Price | |||
|---|---|---|---|---|
| United States | 100%2 | 5.00 | $0.99 | |
| United Arab Emirates | <1%0 | — | AED 2.99 $0.81 | |
| Afghanistan | <1%0 | — | $0.99 | |
| Antigua And Barbuda | <1%0 | — | $0.99 | |
| Anguilla | <1%0 | — | $0.99 | |
| Albania | <1%0 | — | $0.99 | |
| Armenia | <1%0 | — | $0.99 | |
| Angola | <1%0 | — | $0.99 | |
| Argentina | <1%0 | — | $0.99 | |
| Austria | <1%0 | — | €0.99 $1.14 |
Description
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