Articles on: Databases

Connect Your Database with TablePlus

Step-by-step guide to connect to any database instance using TablePlus, provided by Galaxy Databases.


Objective


This guide provides detailed instructions on how to connect to various database instances (MongoDB, PostgreSQL, Redis, etc.) using TablePlus, a modern and versatile database management tool. It outlines the process of obtaining connection credentials from the Galaxy Control Panel and configuring TablePlus for a successful connection.


Requirements


To successfully connect your database with TablePlus, ensure the following prerequisites are met:


  •   You have access to the Galaxy Control Panel.
  •   A database instance has been provisioned by the Galaxy team, which could be MongoDB, PostgreSQL, Redis, or another supported type.
  •   TablePlus is installed (a stable version is recommended) on your computer, and you have an active internet connection.


Instructions


Installation


To install TablePlus, please follow the official documentation specific to your operating system.


Obtain Connection Details from Galaxy Control Panel


To retrieve the necessary connection credentials, follow these steps within the Galaxy Control Panel:


  1.  Access the Galaxy Control Panel: Begin by logging in to your Galaxy Cloud account.
  2.  Navigate to Databases: In the sidebar menu, locate and click on the "Databases" option.
  3.  Select Your Database: A list of your provisioned databases will be displayed. Click on the specific database name you intend to connect to.
  4.  Retrieve Credentials: On the subsequent database overview page, scroll to the "Credentials" section. Here, you will find the essential connection information:
  •   Username: Your database username.
  •   Password: Your database password.
  •   Connection String: A comprehensive connection string (e.g., mongodb://<username>:<password>@<host>:<port>/<database_name>?ssl=true) that contains all the necessary parameters for direct connection.



Connect with TablePlus


Once you have obtained your credentials from the Galaxy Control Panel, proceed with connecting via TablePlus:


  1.  Open TablePlus: Launch the TablePlus application on your computer.
  2.  Create a New Connection: You can initiate a new connection either by clicking Create a New Connection on the welcome screen or by navigating to Connection > New > Connection in the menu bar.



  1.  Choose Database Type: From the presented list, select the database type that matches your Galaxy Cloud database (e.g., PostgreSQL, MongoDB, Redis), then click Import from URL.



  1.  Paste the Connection String: In the dialog that appears, paste the complete Connection String that you copied from the "Credentials" section in the Galaxy Dashboard. The string will be in a format similar to: mongodb://<username>:<password>@<host>:<port>/<database_name>?ssl=true (or similar, depending on your database type). Then, click on "Import".


  1. Verify the Details: TablePlus will automatically process the URL and populate the connection fields with the extracted information:
  • Name: If needed, adjust the connection name to something descriptive such as "My Galaxy MongoDB" or "Galaxy PostgreSQL Dev".
  • Host, Port, User, Password, Database: All of these fields will be automatically filled based on the connection string.
  • SSL/TLS: Will be configured automatically if the string includes ssl=true.


Security Considerations


Maintaining the security of your database connections is paramount. Please adhere to the following best practices:


  •   Secure Credential Handling: Always ensure the secure handling of all database credentials and connection strings to prevent unauthorized access.
  •   Strong Passwords: Utilize strong, unique passwords for database access and make it a practice to update them regularly.
  •   Access Review: Periodically review access permissions and audit logs within the Galaxy Control Panel to monitor and maintain security.
  •   Software Updates: Keep your TablePlus application updated to its latest stable version. This ensures you benefit from the most recent security patches, performance improvements, and new features.


By diligently following these steps and security guidelines, you will be able to efficiently connect to and manage your database instances using TablePlus.

Updated on: 17/10/2025