Connect TablePlus to Oxla

TablePlus is a database management tool and in this guide you will be able to connect TablePlus to an Oxla on-premise database using a Docker container.

Gather your Oxla details

Before connecting, ensure you have the following information for your Oxla PostgreSQL database:

  • Name: Your connection name
  • Host: localhost or 127.0.0.1
  • Port: Default for PostgreSQL is 5432
  • Database’s user: oxla (default username)
  • Password: oxla (default password)

Run the Oxla Docker Container

  1. Open your terminal
  2. Pull and Run the Oxla Docker container
    docker run --rm -it -p 5432:5432 public.ecr.aws/oxla/release:latest
    

Download TablePlus

TablePlus can be downloaded from TablePlus Official Website.

Add a New Database Connection

  1. Launch the TablePlus application on your computer

  2. From the welcome screen, click on the top left panel button > New Connection

Configure Connection Settings

Fill in the connection details in the configuration form:

  • Name: Your connection name (e.g. “Oxla Database”)
  • Choose PostgreSQL from the list of available databases.
  • Host: Your Oxla server IP address or hostname (e.g. 127.0.0.1)
  • Port: Port number that Oxla is using (default for PostgreSQL is 5432)
  • Database’s user: Your database name (e.g. “oxla”)
  • Password: Your database password (e.g. “oxla”)
  • Connection type: Select ALLOW

Test the connection

Click on the Test button to verify that your connection settings are correct. If the test is successful, you will receive a confirmation message.

Save and Connect

If the test is successful, click on the Connect button to save your connection settings and establish a connection to your Oxla database.

That’s all! The data source is connected.

Query Oxla