Download AzureSQL JDBC Driver

Download the AzureSQL JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the AzureSQL JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to AzureSQL. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each AzureSQL driver uses its own syntax — see the connection details below.

The AzureSQL JDBC driver

Azure SQL Database is Microsoft's fully managed relational database service in the cloud, based on SQL Server. It offers built-in high availability, automatic backups, elastic scaling, and deep integration with Azure services — ideal for cloud-native applications.

DbSchema can connect to Azure Cloud database! Just connect using host 'servername.database.windows.net', port 1433 and configured user and password.

The Azure SQL JDBC URL

• Required File(s): sqljdbc.jar
• Java Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
• JDBC URL: get it from Azure page
• Website: Microsoft Azure

To get the connection string https://azure.microsoft.com/en-us/account/, create a database and press 'connection strings' :

If you forgot the password you can reset it directly in the interface:

Download SqlAzure JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

Set Up the Azure SQL Connection

Azure SQL Database is reachable over the public internet, but the logical server rejects every client address until you add a firewall rule for it.

1. Allowlist your client IP address. In the Azure portal open the logical server and select Networking under Security; from a database's overview page the same settings open through Set server firewall. Set Public network access to Selected networks, choose Add your client IP and save. A rule for 0.0.0.0 is the special value that lets Azure services themselves through the server firewall.
2. Check that port 1433 is open on your side too. Azure SQL communicates over port 1433, and corporate networks frequently block outbound traffic on it. A connection that times out from the office but succeeds from a home network is almost always this, not the server firewall.
3. Copy the JDBC URL from the Azure portal. You will find it in the database's Connection strings page under Settings, on the JDBC tab.
4. Paste the URL into DbSchema. In the Connection Dialog set Connection Mode to Edit the JDBC URL Manually and paste the string you copied. The user and the password are entered in the first tab, not in the URL.

The host is always servername.database.windows.net and the database name must be part of the URL — an Azure SQL login is scoped to one database, so connecting without it fails. To sign in with Microsoft Entra ID instead of a SQL login, pick one of the Entra presets in the Connection Mode combo; the interactive one opens a browser window and satisfies MFA where it is enforced.

DbSchema and Azure SQL

DbSchema connects to Azure SQL Database using the SQL Server JDBC driver, with the host in the form servername.database.windows.net. Use DbSchema's ER diagrams to visualize Azure SQL schemas and the Schema Sync feature to push local schema changes to the cloud.