How to Use the Database GUI (DbGate) with ASD

ASD includes a built-in database management UI powered by DbGate. It gives you a visual database browser, query builder, and data import/export — all in your browser. Connect to PostgreSQL, MySQL, SQLite, MongoDB, and more.

Supported databases

• PostgreSQL
• MySQL / MariaDB
• SQLite
• MongoDB
• SQL Server
• Redis

Prerequisites

• ASD CLI installed (asd init to set up your workspace)
• The DbGate binary (auto-downloaded during asd init)
• A running database to connect to

Step 1: Start DbGate

asd database start

To see the status and access URLs:

asd database

Step 2: Access it

Method	URL Format
Local	http://localhost:<port>/
Caddy	http://asd.localhost/asde/dbgate/
Tunnel	Via hub tunnel path

Step 3: Connect to your database

Database connections are configured within DbGate's web UI. When you first open it, click "New Connection" and enter your database details.

Example: Connecting to local Supabase PostgreSQL

Host: 127.0.0.1
Port: 54322
Database: postgres
Username: postgres
Password: postgres

If you're using the Supabase plugin, these credentials are available in your .env file after running asd plugin:supabase:bootstrap.

What you can do

• Browse schemas — explore tables, views, and stored procedures
• Run queries — SQL editor with syntax highlighting and autocomplete
• Edit data — inline editing of table rows
• Import/export — CSV, JSON, Excel, SQL dump
• Compare databases — diff schemas between environments
• Save connections — reconnect with one click

Configuration

Variable	Default	Description
ASD_DBGATE_PORT	(auto)	Port number

DbGate needs minimal configuration from ASD's side — most setup happens in the DbGate UI itself.

Security notes

• DbGate stores database credentials in its own config — be aware if sharing access
• Use basic auth in asd.yaml if exposing via tunnel
• Stop when not actively using: asd database stop

Stopping DbGate

asd database stop

What's next

• Network Inspector (mitmproxy) — debug HTTP traffic
• Web Terminal with ttyd — shell access in the browser
• Configure asd.yaml — full project configuration