Services

Database GUI (DbGate) gebruiken met ASD

Published:
Kelvin Wuite
By Kelvin Wuite • 5 min read
Share

ASD bevat een ingebouwde database management UI aangedreven door DbGate. Het geeft je een visuele database browser, query builder, en data import/export — alles in je browser. Verbind met PostgreSQL, MySQL, SQLite, MongoDB en meer.

Ondersteunde databases

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

Vereisten

  • ASD CLI geinstalleerd (asd init)
  • Het DbGate binary (automatisch gedownload tijdens asd init)
  • Een draaiende database om mee te verbinden

Stap 1: Start DbGate

bash
asd database start

Voor status en URL's:

bash
asd database

Stap 2: Benader het

MethodeURL Formaat
Lokaalhttp://localhost:<poort>/
Caddyhttp://asd.localhost/asde/dbgate/
TunnelVia hub tunnel pad

Stap 3: Verbind met je database

Database-verbindingen configureer je in de DbGate web UI. Klik bij het eerste bezoek op "New Connection" en vul je database-gegevens in.

Voorbeeld: Verbinden met lokale Supabase PostgreSQL

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

Wat je kunt doen

  • Schema's doorzoeken — tabellen, views en stored procedures verkennen
  • Queries draaien — SQL editor met syntax highlighting en autocomplete
  • Data bewerken — inline bewerking van tabelrijen
  • Importeren/exporteren — CSV, JSON, Excel, SQL dump
  • Databases vergelijken — schema's diff-en tussen omgevingen

Configuratie

VariabeleStandaardBeschrijving
ASD_DBGATE_PORT(auto)Poortnummer

Stoppen

bash
asd database stop

Wat nu

Kelvin Wuite
Written by

Kelvin Wuite

Kelvin Wuite is the founder of ASD B.V. With over eighteen years of development experience, he has witnessed the same patterns repeat across every software team - endless documentation, manual preparation, environment mismatches, and fragmented collaboration. His drive is to remove these barriers, enabling engineers to work together in unified environments with shorter feedback loops and hands-on collaboration. Since 2015 he has been refining these ideas, leading to ASD — a platform designed to create a faster, more integrated way for development teams to collaborate in an age where AI is thriving.

Related Articles

Tunnels

How to Expose Local Services with ASD Tunnels

Learn three ways to expose local services with ASD: quick expose for instant sharing, asd.yaml for daily development, and tunnel tokens for CI/CD automation.

Configuration

How to Configure asd.yaml for Your Project

Complete guide to configuring asd.yaml: define services, set up networking, add authentication, create automation tasks, and configure plugins for your project.

Services

How to Set Up a Web Terminal with ttyd

Set up a browser-based terminal with ttyd and ASD. Access your development machine from any device, anywhere, with password protection and HTTPS tunneling.