DB Browser
The DB Browser lets you connect to MySQL and PostgreSQL databases directly from Gatwy — no external client required. Browse tables, run SQL queries, and inspect data, all from the browser.
Creating a DB Connection
DB connections are created like any other connection type:
- Click New Connection in the sidebar
- Select MySQL or PostgreSQL as the protocol
- Fill in the connection details:
| Field | Description |
|---|---|
| Name | Display name in the sidebar |
| Host | Database host (IP or hostname) |
| Port | Default: 3306 (MySQL) or 5432 (PostgreSQL) |
| Username | Database user |
| Password | Stored encrypted with AES-256 |
- Click Save — the connection appears in your sidebar like any other.
Connecting and Browsing
Click the connection to open the DB Browser tab. The left panel lists all databases and their tables. Click any table to load a paginated row view.
- Pagination — results are paginated with a configurable row limit
- Row count — total row count is shown in the query status bar
- Disconnect — a disconnect screen appears if the connection drops, with a reconnect button
Running SQL Queries
The query editor supports full read and write SQL:
-- Browse
SELECT * FROM users WHERE active = 1 LIMIT 100;
-- Modify
UPDATE settings SET value = 'dark' WHERE key = 'theme';
-- DDL
CREATE TABLE logs (id INT PRIMARY KEY AUTO_INCREMENT, message TEXT, created_at DATETIME);
The DB Browser runs queries with the credentials you configured on the connection. Ensure the database user has only the permissions you intend to grant.
Session Logging
DB Browser sessions are logged like file activity sessions — every query you run is recorded in the Sessions → DB Sessions history with a timestamp and the full SQL statement. Logs are exportable as JSON or CSV.
RBAC
DB Browser connections follow the same permission model as all other connections:
connections.create— create DB connectionsconnections.edit_own/connections.edit_any— edit connectionsconnections.delete_own/connections.delete_any— delete connections
Share a DB connection with specific users or roles the same way as any other connection type.