# GizmoSQL — Mobile database server

> Mobile SQL database server with Arrow Flight SQL protocol support. (iPhone/iPad app by Gizmo Data LLC.)

- Source: https://appshunter.io/ios/app/gizmosql/id6761951280 (this page in markdown: same URL + `.md`)
- Developer: [Gizmo Data LLC](https://appshunter.io/developer/1781708820)
- Category: Developer Tools, Utilities
- Price: $0.99 (on sale, was $4.99)
- Rating: 5.00/5 from 2 App Store ratings
- Age rating: 4+
- Requires: iOS 17.0 · 62 MB
- Languages: American English
- Released: 2026-04-13
- Data updated: 2026-08-25
- Monetization: paid
- User reviews in markdown: https://appshunter.io/ios/app/gizmosql/id6761951280/reviews.md

## What is 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

## Key features

- DuckDB and SQLite backends
- Arrow Flight SQL protocol
- Built-in SQL client
- Data browser
- Network connectivity
- TLS encryption
- Username/password authentication

## Chart rankings

- #44 in Top Paid · Developer Tools (US App Store)


## Frequently asked questions about GizmoSQL

### What is GizmoSQL?

GizmoSQL turns your iPhone or iPad into a high-performance SQL database server. It supports the Arrow Flight SQL protocol for efficient data transfer and can be connected to from any device on your network.

### What database engines does GizmoSQL support?

GizmoSQL supports both DuckDB and SQLite as backend database engines, offering flexibility for different analytical and development needs.

### How can I connect to GizmoSQL?

You can connect to GizmoSQL from laptops, desktops, or other devices on your network using any Arrow Flight SQL client, including JDBC, ADBC, ODBC, and Node.js drivers.

### Does GizmoSQL have ads?

GizmoSQL does not contain advertisements. It is a paid application that provides an ad-free experience for its users.

### What are the pricing details for GizmoSQL?

GizmoSQL is available for a one-time purchase of $0.99. There are no subscription fees or in-app purchases required to use its full functionality.

### What devices is GizmoSQL compatible with?

GizmoSQL is compatible with both iPhone and iPad devices, running on iOS. It is suitable for users who need a portable database solution.

### How often is GizmoSQL updated?

The latest version of GizmoSQL is 1.32.0, last updated on June 19, 2026. Updates typically include new features, performance improvements, and bug fixes.

### What is the user sentiment for GizmoSQL?

GizmoSQL has received excellent user feedback, holding a rating of 5.0 stars from 2 ratings. This indicates a high level of user satisfaction with the application.

## Version history (last 5 releases)

### 1.32.0 — 2026-06-19

Allow graceful shutdown of GizmoSQL server, various bug fixes.

### 1.30.1 — 2026-06-19

DuckDB has been upgraded to version v1.5.4

### 1.30.0 — 2026-06-13

Minor bugfixes

### 1.28.0 — 2026-06-06

Improved instrumentation - with captured query profiles.  Statement queuing, wildcard catalog security support.

### 1.26.2 — 2026-05-23

Updated DuckDB to version: v1.5.3

## More apps by Gizmo Data LLC

- [GizmoEdge](https://appshunter.io/ios/app/gizmoedge/id6738658135)

All apps by Gizmo Data LLC: https://appshunter.io/developer/1781708820

## Related topics

[gizmosql](https://appshunter.io/ios/topics/gizmosql)

---

*Data collected daily from the US App Store and indexed by [AppsHunter](https://appshunter.io/). User reviews are verbatim App Store reviews. Ratings, prices and chart positions refresh continuously; this snapshot is from 2026-08-25.*
