Databases & Connectivity

DbSchema supports connections to various SQL and some NoSQL databases. A proper JDBC Driver is required for this connection. When you connect to a database, DbSchema automatically retrieves the necessary JDBC driver from its public web repository.

To learn how to configure the connection dialog, click here. If your database is hosted on a different computer, you will need to provide the correct TCP/IP HostName. For certain databases, you may also need to enable remote connections, activate TCP/IP, grant user access, or configure firewall settings. More details can be found in the next section.

If the database you're looking for is missing from the JDBC driver list you can upload the driver in DbSchema.

DbSchema Video Presentation

Database Specific Information

Learn how to connect to one of this databases by clicking one of the links below.

See all supported databases here.

Table of Contents

Connection Dialog

The connection dialog allows you to configure connections to any database with ease.

Establish a Connection Using a Composed URL

Database Connection Dialog
  1. Assign a Connection Name for your database connection. This name will serve as an alias for referencing the connection throughout the application.
  2. Select the appropriate JDBC Driver, a .jar file required for database connectivity. DbSchema automatically downloads the driver when you choose your DBMS. JDBC drivers are typically provided by the database vendor. If needed, you can upload a custom driver by clicking the Cogs icon. Uploaded drivers are stored locally at C:\Users\<YourUser>\.DbSchema\drivers\SqlServer....
  3. Configure the JDBC URL template. You can either use a pre-built template or manually edit the URL.
    JDBC URL
    The JDBC URL is a formatted string containing key connection details such as host, port, and database name.

    DbSchema automatically builds the JDBC URL using the values you provide for host, port, and database fields.

    For cloud databases (e.g., AWS, Azure, Google Cloud), choose Edit Manually and copy the URL from the cloud console. A text field will appear for entering the JDBC URL.
    Edit JDBC URL Manually

  4. In the Server Location section, specify the database server's location:
    • Select This computer, default port for a locally hosted database.
    • Select Remote computer or custom port for a remote database, and provide the server's hostname and port.
  5. Use the Check (Ping) button to test the server connection and verify proper configuration.
  6. In the Authentication section, enter the Database User and Password. These credentials are typically defined during database setup or user creation. Click Help and Tips for additional guidance on database connection settings.
  7. In the Database section, specify a name for your DbSchema model. This local file allows you to work offline on your schema and synchronize changes with the database later.

How to Find the Hostname of the Database Server

Windows

You can find the hostname on a Windows server using several methods:

1. Using Command Prompt

  • Press Win + R, type cmd, and press Enter.
  • Type the command: hostname
  • The output will display the hostname of the system.

2. Using ipconfig

  • Open Command Prompt as above.
  • Type: ipconfig /all
  • Look for the line labeled Host Name in the output.

3. Using nslookup

  • Open Command Prompt.
  • Type: nslookup <IP address>
  • Replace <IP address> with the server's IP. If a reverse DNS entry exists, this will return the hostname.

4. Using nbtstat

  • Open Command Prompt.
  • Type: nbtstat -A <IP address>
  • Replace <IP address> with the actual IP. This displays the NetBIOS name table, which includes the hostname.

Linux

Use the terminal to retrieve the hostname:

  1. Open a terminal application (e.g., Applications > Accessories > Terminal).
  2. Type one of the following commands:
    • hostname
    • cat /proc/sys/kernel/hostname
  3. Press Enter.
  4. The system's hostname will be displayed.

macOS

You can find the hostname of your Mac in the System Preferences:

  1. Go to Apple Menu > System Preferences > Sharing.
  2. The computer name (hostname) will be shown at the top of the window.

If you still can't determine the hostname or have trouble connecting, please contact your system administrator or network support team.

How to Find the IP Address of the Database Server

On Windows

  1. Open the Start Menu and type cmd, then press Enter to launch the Command Prompt.
  2. In the Command Prompt, type: ipconfig
  3. Look for the line labeled IPv4 Address under the active network adapter. This is the server's IP address.
Windows IP Address using ipconfig

On Linux

  1. Open a terminal (e.g., Applications > Accessories > Terminal).
  2. Type one of the following commands:
    • ip addr show — recommended for newer systems
    • ifconfig -a — for older systems (requires net-tools)
  3. Press Enter.
  4. Look for the IP address next to inet under the active interface (e.g., eth0, wlan0).

On macOS

  1. Go to Apple Menu > System Preferences > Network.
  2. Select the active network interface on the left (with the green dot).
  3. Your IP address will appear below the connection status.

Note: If your server is behind a router, firewall, or VPN, the displayed address may be an internal IP (e.g., 192.168.x.x). To find the external IP address, open a browser on the server and visit whatismyipaddress.com.

How to Test the Hostname or IP Address of the Database Server

Before connecting DbSchema to a remote database server, it's useful to test whether the server is reachable from your machine. Here are three methods to verify connectivity: using ping, telnet, or openssl.

1. Using Ping

This checks basic network reachability.

ping <hostname or IP>

Example:

ping dbserver.mycompany.com
        ping 192.168.1.25
  • If the server replies, it means the host is reachable.
  • If you receive "Request timed out", the server may be offline, behind a firewall, or blocking ICMP requests.

2. Using Telnet

This tests if a specific port (e.g., the database port) is open and accepting connections.

telnet <hostname or IP> <port>

Example:

telnet dbserver.mycompany.com 5432   # PostgreSQL
        telnet 192.168.1.25 3306             # MySQL
  • If the screen clears or shows a connection message, the port is open.
  • If it says "Could not open connection", the port may be closed or blocked by a firewall.

3. Using OpenSSL (Requires Git Bash or OpenSSL Installed)

Useful for testing encrypted ports such as MySQL over SSL, PostgreSQL with SSL, etc.

openssl s_client -connect <hostname or IP>:<port>

Example:

openssl s_client -connect dbserver.mycompany.com:5432
  • If you see a certificate chain or SSL handshake, the server is reachable and supports SSL on that port.
  • If it hangs or shows a connection error, the server might not be listening on that port or SSL is not enabled.

These tools help verify if the database server is reachable and listening on the correct port. If you're still unable to connect, check firewalls, database server status, and network settings.

Establish an SSH Connection

Establish an SSH Tunnel to encrypt the communication to the database.

  1. Enter the Host where the SSH Server is activated;
  2. Enter the SSH Port where the server is activated. The default port is 22;
  3. Enter the SSH User configured in the SSH Tunnel;
  4. Select the Authentication method. This can be a password or an encrypted private key in Open SSH format.
Setup Database SSH Tunnel

More options

In the Options section you can modify details about your model.

  1. Save your model to a local file. By default, DbSchema saves all models to model files. Enabling this feature will allow you to save the connection data separately, to a local file.
  2. Read-Only Connection won't allow any modifications in the database. You can add exceptions to this rule.
  3. Set a specific timezone for DbSchema so you can avoid timezone errors when your computer and the database use different timezones.
  4. Highlight Connection Combo allows you to give different colors for different types of connections (eg. Production, Testing, Development).
  5. You can set a different Alias for the schema on your computer.
Database Connection Options

Enable Windows Firewall

Windows Firewall is blocking connectivity from other machines. To allow connectivity you have to create a new Inbound rule for the database port. Go to Control Panel > System and Security > Windows Defender Firewall > Advanced Settings > Inbound Rules and follow the “New Rule” wizard.

Enable Windows Firewall for Database Connections