Support
Help with Badger SQL for iPhone, iPad and Android.
Email support@lonebadger.tech with your iOS or Android version, the app version (Settings › About) and what happened. Please don't send passwords.
Connecting
- Azure SQL: use
yourserver.database.windows.net, port 1433, and enter a database name. Connections are always encrypted. - Local or on-premises SQL Server: use the server's host name or IP and its TCP port. Named instances need their TCP port, since the SQL Browser service isn't supported. If the server uses a self-signed certificate, turn on Trust Server Certificate.
- Paste a connection string: tap + › Paste Connection String and paste the ADO.NET string from the Azure portal.
“Blocked by the Azure firewall”
Azure SQL only accepts connections from allowed IP addresses. Tap Add to Firewall to sign in to Azure and add your current IP. Your account needs permission to change the server's firewall (for example, the SQL Server Contributor role). Remove rules later from Edit › Firewall Rules.
Microsoft Entra ID sign-in
- Badger SQL detects which Microsoft Entra directory your Azure SQL server belongs to. If sign-in picks the wrong directory, enter the Tenant ID on the connection.
- “Need admin approval”: your organization requires an administrator to approve Badger SQL. The app shows a link to send to your IT administrator; once they approve, sign in again.
- The Azure SQL server needs a Microsoft Entra admin, and your account needs a database user, before Entra logins work.
Voice input
Tap the microphone on the query editor and speak. Say punctuation and operators: “select star from customers where city equals quote Seattle quote”, “comma”, “open paren”, “greater than or equal to”, “new line”. Table and column names from the current database are recognized, so “customer id” becomes CustomerID. Voice input needs on-device speech recognition for English.
Saving queries and history
Use More › Save Query (⌘S) to keep a query; More › Query Library (⇧⌘L) shows saved queries and your history. Scripts with GO separators run batch by batch, and Run Current Statement (⇧⌘↩) runs just the statement under the cursor.
Transactions
The results bar shows how many transactions are open on the tab (@@TRANCOUNT). While one is open the tab turns orange; tap the count to commit or roll back.
Syncing connections
Turn on Sync to my devices for a connection to store it in iCloud Keychain. iCloud Keychain must be on in iOS Settings on each device. Sync is for iPhone and iPad; on Android, connections stay on the device.
Sharing a connection
- Share: choose Share… from a connection's menu, or Share in the connection editor, and send the link with any app. It holds the connection's settings, such as the server, database and user name.
- The password: it stays out unless you turn on Include Password (Encrypted). The app then shows a passphrase; tap it to copy it. On iPhone and iPad the copy stays on this device and leaves the clipboard after 2 minutes. Send the passphrase a different way from the link, such as a phone call. Other secrets are never included.
- Opening a link: it opens in Badger SQL, and nothing is saved until you check the connection and tap Save. If the password was included, the app asks for the passphrase. Without the app, the link's page offers the App Store and Google Play; or copy the whole message and choose Add › Paste Connection String.
- The privacy policy explains where a shared link's details go.
Privacy
See the privacy policy. In short, we don't collect any data.