Quarry SQL

MSSQL, Postgres, MySQL, SQLite

Free · In-App Purchases

Connect straight to SQL Server, PostgreSQL and MySQL, or open SQLite files, on iPad and iPhone. Browse, query, edit and design tables safely, with no server in between. Quarry SQL is a native SQL client for iPad and iPhone. It connects directly to SQL Server, PostgreSQL and MySQL/MariaDB, with no server or account of ours in between, and opens SQLite databases right on your device. BROWSE • Databases, schemas, tables and views, with columns, keys and indexes • Table data a page at a time, with sorting and a WHERE filter • Script any table as CREATE TABLE, to copy or open in the editor QUERY • SQL editor with syntax highlighting and suggestions for tables and columns • Run the statement at the caret, the selection or the whole script; cancel at any time • SQL Server scripts with GO batches • Results in a fast grid, with every result set and the server's messages • Searchable query history per connection DIAGRAMS • An ER diagram of any table and its neighbours: tap a table to highlight its relationships, with how many rows each side can have in crow's-foot notation (one-to-many, one-to-one, optional) • The server's row estimate on every table, and foreign keys without an index flagged • Find any table by name, and move around with the keyboard and trackpad on iPad • No database at hand? Try the built-in sample diagram SQLITE • Open SQLite databases on your device, in iCloud Drive or from another app, with the same browser, editor and diagrams • Open a .sqlite, .sqlite3 or .db file in Quarry straight from Files or the share sheet • Create a new, empty database to try SQL without a server • Files are opened defensively, so a database from someone else can't run hidden code SAFE BY DESIGN • Passwords and SSH keys are stored only in the Keychain • TLS by default, and SSH host keys are always verified • UPDATE and DELETE without WHERE ask before they run • Read-only connections are enforced, not just confirmed QUARRY PRO Try Pro free for two weeks with the yearly subscription, or buy it once for good: • Unlimited saved connections • SSH tunnels • iCloud sync of connections, passwords and SSH keys across your devices • Editing rows in tables and query results, reviewed as SQL and applied in one transaction • ER diagrams of whole schemas and of tables up to three steps away, shared as PNG or PDF or copied as Mermaid or DBML • The CREATE INDEX that fixes a foreign key without an index, ready in the editor • A query builder in the diagram: pick tables and get a SELECT with the joins worked out along the foreign keys, through link tables too, ready in the editor • A table designer for quick changes: columns, keys, indexes and checks, new tables and dropping tables, with every statement shown before it runs • Cancelling queries and ending sessions in server activity • The full query history Quarry collects no data. Connections sync through your own iCloud account, and everything else stays on your device. Quarry Pro Yearly is an auto-renewing subscription. Payment is charged to your Apple Account, and the subscription renews unless it's cancelled at least 24 hours before the end of the current period. Manage or cancel it in your Apple Account settings. Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/ Privacy Policy: https://sware.dk/quarry-privacy-policy.html

  • This app hasn’t received enough ratings or reviews to display an overview.

SQLITE • Open SQLite databases on your device, in iCloud Drive or straight from Files, with the same browser, editor and diagrams as the other engines • New Database… creates an empty database, so you can try SQL without a server • To edit a file, give Quarry access to its folder; until then it opens read-only • Edit rows (even without a primary key) and make the changes SQLite's ALTER TABLE allows in the table designer (Pro) • Files are opened defensively, so a database from someone else can't run hidden code

The developer, sWare, 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
    sWare ApS
    Size
    17.8 MB
    Category
    Developer Tools
    Compatibility
    Requires iOS 18.0 or later.
    • iPhone
      Requires iOS 18.0 or later.
    • iPad
      Requires iPadOS 18.0 or later.
    Languages
    English
    Age Rating
    4+
    In-App Purchases
    Yes
    • Quarry Pro Yearly $34.99
    • Quarry Pro Lifetime $49.99
    Copyright
    © 2026 sWare ApS