Levered Docs
Getting StartedConnect Your Warehouse

Postgres

Connect a PostgreSQL database to Levered.

What you need

ItemDescription
HostThe hostname or IP of your PostgreSQL server
PortThe port PostgreSQL is listening on (default 5432)
DatabaseThe database containing your event tables
UsernameA PostgreSQL user with read access
PasswordThe password for that user
CREATE ROLE levered_reader WITH LOGIN PASSWORD 'a-strong-password';
GRANT CONNECT ON DATABASE analytics TO levered_reader;
GRANT USAGE ON SCHEMA public TO levered_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO levered_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO levered_reader;

Connect via the dashboard

  1. Navigate to Settings > Warehouse in the Levered dashboard.
  2. Select Postgres as the provider.
  3. Enter your Host, Port, Database, Username, and Password.
  4. Click Test Connection to verify Levered can reach your database.
  5. Click Save.

Troubleshooting

Connection test fails

  • Make sure your PostgreSQL server is accessible from the internet (or from Levered's IP range if you use allowlisting).
  • Verify the hostname, port, and credentials are correct.
  • Check that the user has CONNECT on the database and USAGE on the schema.

Permission errors at training time

Levered runs SQL queries during model training. If training fails with permission errors, check that the PostgreSQL user has SELECT access on the specific tables referenced in your metric queries.

Next step

Now that your warehouse is connected, set up your data pipeline -- create the tables Levered reads during training.