Web UI Overview

The Web UI of DBDash provides a graphical interface to manage your database visually, offering features like code generation, user management, table design, and real-time queries – all accessible from your browser.

🌐 Getting Started with the Web UI

Once your DBDash server is running, access the Web UI at http://localhost:3000 in your browser.

From the sidebar, you can explore different tools for managing your database environment efficiently:

🗃️ Database Manager

Create, delete, or connect to multiple databases with ease. You can also view connection strings, metadata, and status reports.

  • Create new database instances
  • Manage connection configurations
  • See DB status and version info

👤 User Manager

Manage user roles, permissions, and database access securely through a graphical role assignment UI.

  • Add or remove users
  • Assign roles like Admin, Editor, Viewer
  • Enable/disable access to specific tables

📋 Table Manager

View, create, and modify tables directly from the UI. The Table Manager also lets you define column types, indexes, constraints, and more.

  • Design tables and set primary keys
  • Modify schema with visual column editor
  • Auto-generate migration scripts

🧠 Code Generation

Automatically generate backend code (CRUD APIs, models, and DB access logic) based on your current schema using our AI-assisted engine.

  • Generate Node.js, Python, or Go boilerplates
  • Download code snippets for integration
  • Use generated routes in your REST API

📦 Data Export

Export your data in CSV, JSON, or SQL formats for backups, migrations, or offline analysis.

  • Selective export by table or database
  • Choose export formats: CSV / JSON / SQL
  • Set filters before export

🧮 Query Console

Run custom SQL queries directly in the browser with instant result previews, syntax highlighting, and history tracking.

  • Write and execute raw SQL
  • View result tables in real time
  • Save query history for reuse