Quarry SQL

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. 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 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