Skip to main content
PostgreSQL Web Access PostgreSQL web access provides two modes for interacting with your database directly from the browser: the Data Explorer for visual browsing and editing, and the SQL Terminal for running ad-hoc queries.

​
Data Explorer

The Data Explorer is a visual interface for browsing and editing PostgreSQL tables. It provides schema and table navigation, filtering, sorting, inline editing, and full CRUD operations — all without writing SQL.

​
Connecting

1

Navigate to Account

Go to the Resources tab in your PAM project, open the PostgreSQL resource, and find the account you want to access. Click the Connect button next to the account.Account Connect ButtonAlternatively, if you are on the account page, click the Access button.Account Page Access Button
2

Open Data Explorer

In the connect modal, click Open Data Explorer to launch the Data Explorer in a new tab.Open Data Explorer
Once connected, you get a spreadsheet-like interface for your database where you can:
  • Browse tables and explore their data
  • Filter and sort to quickly find what you need
  • Edit data directly — add, update, or delete rows
Data Explorer

​
SQL Terminal

The SQL terminal provides a psql-like experience in your browser. It is designed for ad-hoc usage — quick queries, debugging, and administrative tasks.

​
Connecting

1

Navigate to Account

Go to the Resources tab in your PAM project, open the PostgreSQL resource, and find the account you want to access. Click the Connect button next to the account.Account Connect ButtonAlternatively, if you are on the account page, click the Access button.Account Page Access Button
2

Open Console

In the connect modal, click Open Console to launch the SQL terminal in a new tab.Connect Button
3

End Session

Click the Disconnect button from the web access terminal status bar or type \q, quit, or exit. You can reconnect from the same page.
Web Access Terminal

​
Usage

Once connected, you’ll see a => prompt. Type SQL queries as you would in psql: 
=> SELECT * FROM users LIMIT 5;
 id | name       | email
----+------------+---------------------
  1 | Alice      | alice@example.com
  2 | Bob        | bob@example.com
(2 rows)

​
Transactions

Transactions are fully supported. You can use BEGIN, COMMIT, and ROLLBACK as you would in psql: 
=> BEGIN;
BEGIN
=> UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE 1
=> UPDATE accounts SET balance = balance + 100 WHERE id = 2;
UPDATE 1
=> COMMIT;
COMMIT

​
Limits

In addition to the common session limits, the following PostgreSQL-specific limits apply:
SettingValue
Statement timeout30 seconds per query

​
FAQ

No. The SQL terminal is not a psql client. It is a custom SQL REPL that connects directly to PostgreSQL and provides a psql-like experience, including familiar prompts and tabular output formatting. Backslash commands like \dt or \d are not supported.
Editing is only available for tables that have a primary key defined. Tables without a primary key, as well as views, are displayed in read-only mode.