Connect to a Database

1. Select an Alias for your database connection. This will be the name of this specific connection to the database.
2. Select the DBMS (Database Management System). This is the database you want to connect to.
3. The driver for your database will be automatically downloaded when you select the DBMS. Every database can have different methods of connection. You can change them from the dropdown menu. For now, we can stick to the Standard connection. If the standard connection is not working, choose the next one from the menu (this can be different for each database).
4. In the Server Location section, we will establish the connection between DbSchema and the server. If the database you're working with is located on your local machine, choose This computer, default port. If the database is located on a remote computer, choose Remote computer or custom port.
5. If the database is located on your local machine, the host and port will be automatically completed by DbSchema. If you are trying to reach a remote server, you'll have to complete the server host or IP and port.
6. The Check (Ping) button helps you to check if the connection to the server is working properly.
7. In the Authentication section, insert the Database User and Password. The credentials are usually defined during database installation or when the user is created in the database.
8. In the Database section, you will choose a name for the project file that will be stored on your local machine. This file gives you the flexibility to work on your schema offline and synchronize it later with the database.

1. Type cmd in the Start Menu;
2. Type ipconfig command in Command Prompt;
3. Look for the IPv4 Address.

1. Type Turn Windows features on or off in the start bar. Click on the result;
2. In the next dialog, search for Telnet Client and make sure that it's enabled;
3. Click ok and apply the changes.

1. Open Command Prompt by writing cmd in the start menu;
2. Type telnet {host} {port}. Replace the {host} & {port} with the host & post of the database. Press Enter;
3. If the port is open, the telnet window should open, as shown in the right image.
4. If the telnet can't reach the port, you should receive an error. In this case, verify if the database server is active.

You can insert your own JDBC URL or edit the current one. DbSchema will use this URL to connect to the database. Editing the JDBC URL offers you more freedom than composing the URL in the previous tab Compose URL.

If you need more help with editing the JDBC URL, click on the URL Documentation button. This will take you to the documentation of your database.

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

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

1. Save your project to a local file. By default, DbSchema saves all the projects to project file. Enabling this feature will allow you to save the connection data 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.

Windows Firewall is blocking connectivity from other machines. To allow connectivity you have to create 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” setup wizard.