GizmoSQL

Mobile database server

$0.99 · Designed for iPad. Not verified for macOS.

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

  • 5.0
    out of 5
    2 Ratings

Updated DuckDB to version: v1.5.3

The developer, Gizmo Data LLC, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Collected

    The developer does not collect any data from this app.

    Privacy practices may vary, for example, based on the features you use or your age. Learn More

    The developer has not yet indicated which accessibility features this app supports. Learn More

    Seller
    • Gizmo Data LLC
    Size
    • 63.4 MB
    Category
    • Developer Tools
    Compatibility
    Requires iOS 17.0 or later.
    • iPhone
      Requires iOS 17.0 or later.
    • iPad
      Requires iPadOS 17.0 or later.
    • Mac
      Requires macOS 14.0 or later and a Mac with Apple M1 chip or later.
    • Apple Vision
      Requires visionOS 1.0 or later.
    Languages
    • English
    Age Rating
    4+
    Copyright
    • © 2026 GizmoData LLC