Quarry Support
SQL client for SQL Server, PostgreSQL and MySQL/MariaDB on iPhone and iPad
Need help? Email support@sware.dk. We usually reply within a few working days. The answers below cover the most common questions.
Connecting to a database
Quarry can’t reach my server
Quarry connects directly from your iPhone or iPad to the database server, with no proxy in between. The server must be reachable from the device itself:
- Check the host name and port: SQL Server usually uses 1433, PostgreSQL 5432 and MySQL/MariaDB 3306.
- A server on a company network usually needs a VPN on the device, or an SSH tunnel through a server you can reach (see below).
- Make sure the server accepts remote connections and that no firewall blocks the
port. For PostgreSQL, check
listen_addressesandpg_hba.conf; for MySQL/MariaDB,bind-addressand the user’s allowed host.
TLS and certificate errors
Use TLS is on by default for new connections. If your server uses a self-signed certificate, or one your device doesn’t trust, turn on Trust Server Certificate in the connection’s settings. Only do this for servers you know. Turning TLS off sends data unencrypted, so avoid it outside trusted networks.
Which logins are supported?
Quarry supports user name and password logins: SQL Server logins (SQL Server 2012 or later), and PostgreSQL and MySQL/MariaDB users. Windows authentication (Kerberos/NTLM) and Microsoft Entra ID logins aren’t supported.
Read-only connections
Turn on Read-Only for a connection to block edits and SQL that may change data. On SQL Server, which has no read-only session, use a login that can only read for full protection.
SSH tunnels (Quarry Pro)
- Turn on Use SSH Tunnel in the connection’s settings and enter the
SSH server, user name and either a password or a private key. Enter the database
host as the SSH server sees it, often
localhost. - Private keys must be in OpenSSH format (
-----BEGIN OPENSSH PRIVATE KEY-----). Ed25519 and ECDSA keys are supported; RSA keys are not. To make a new key:ssh-keygen -t ed25519. - On the first connection, Quarry shows the server’s host key fingerprint. Check that it matches what the server’s administrator gave you before you trust it.
- If the server’s host key changes, Quarry refuses to connect. If the change is expected, tap Forget Host Key in the connection’s settings and connect again.
iCloud sync (Quarry Pro)
- Saved connections sync between your devices when you are signed in to iCloud with the same Apple Account on each of them.
- Passwords and SSH keys sync through iCloud Keychain, which is end-to-end encrypted. iCloud Keychain must be turned on in the Settings app. You can turn this off with Sync Passwords and SSH Keys in Quarry’s Settings (the gear button in the connections list).
- Remove from iCloud in Quarry’s Settings deletes Quarry’s passwords and SSH keys from iCloud Keychain on all your devices. The device you do it on keeps its own copies.
- Query history isn’t synced. It stays on the device where you ran the queries.
- A connection created separately on two devices shows up twice. Delete the one you don’t need.
Quarry Pro and purchases
What’s free and what’s Pro?
Free includes all three database engines, up to 2 saved connections, the schema browser, the query editor, read-only table data, server activity and the latest 10 history entries per connection.
Pro adds unlimited connections, SSH tunnels, iCloud sync, editing rows, ER diagrams, the table designer, server activity actions and the full query history. Pro is available as a yearly subscription, with a free trial for new subscribers, or as a one-time lifetime purchase.
Restoring a purchase
On a new device, or after reinstalling, open Quarry’s Settings and tap Restore Purchases. Use the same Apple Account you bought Pro with.
Managing or cancelling a subscription
Tap Manage Subscription in Quarry’s Settings, or open the Settings app, tap your name and then Subscriptions.
Refunds
Purchases are handled by Apple, so refunds are too. Request one at reportaproblem.apple.com.
What happens if Pro ends?
Nothing is deleted. Connections beyond the free limit stay in the list but can’t be opened, and your synced data stays in iCloud. Everything is available again when you renew.
Reporting a problem
Email support@sware.dk and include:
- The Quarry version, your device and its iOS or iPadOS version
- The database engine and its version (for example PostgreSQL 17 or SQL Server 2022)
- Whether you use TLS and/or an SSH tunnel
- The exact error message, or a screenshot, and the steps that lead to it
Please never send passwords, private keys or real data from your databases.
Privacy
Quarry doesn’t collect any data. Read the privacy policy.