Skip to main content

Connect to Aiven for PostgreSQL® with LibreDB Studio

Use LibreDB Studio to connect to your Aiven for PostgreSQL® service from a browser. LibreDB Studio is an open source SQL client that you host yourself, so a team connects through one URL instead of installing a client on every machine.

Prerequisites​

  • Access to the Aiven Console

  • At least one running Aiven for PostgreSQL service

  • LibreDB Studio running on your machine or your network, for example with Docker:

    docker run -p 3000:3000 -v libredb:/app/data \
      -e STORAGE_PROVIDER=sqlite ghcr.io/libredb/libredb-studio:0.15.0

    STORAGE_PROVIDER=sqlite keeps saved connections on the server instead of in the browser, and the volume keeps them when you replace the container. On the first run, LibreDB Studio prints the admin password to the container log, so read it with docker logs before you sign in.

Get the service URI from the Aiven Console​

  1. Log in to the Aiven Console and go to your organization > project > Aiven for PostgreSQL service.
  2. On the Overview page, go to the Connection information section.
  3. Copy the Service URI. It carries the host, port, user, password, database name, and sslmode=require.

Connect to the service URI from LibreDB Studio​

  1. Open LibreDB Studio, sign in, and create a connection.
  2. Click Paste URL, paste the service URI, and click Parse. LibreDB Studio fills in the host, port, user, password, and database name, and sets SSL to REQUIRE because the URI carries sslmode=require.
  3. Click Test Connection to verify the settings, and click Establish Connection to save the connection.

The object browser lists your tables, and the query editor and EXPLAIN plans run against the service.

Connection limits on smaller plans​

LibreDB Studio keeps a connection pool open while a connection is active, so it uses several of the connections your plan allows. Plans with a low connection limit, such as the free plan with a limit of 20, leave less room for other clients. Check Connections on the Overview page if several tools connect at the same time.

Related pages