🗃️ DBWebpage

A lightweight database data visualization tool for PostgreSQL 🐘 and MySQL 🐬.

Install

npm install -g db-webpage

Usage

After global installation, simply run:

dbw

This will start the server on port 12301 and automatically open your browser.

CLI Options

dbw -v, --version     # Show version
dbw -h, --help        # Show help
dbw -p, --port <port> # Start on a custom port, e.g. dbw -p 8080

You can also set the port via the PORT environment variable:

PORT=8080 dbw

Features

• 🔌 Connection Management — Create, edit, and delete database connections
• 🗄️ Multi-Database Support — PostgreSQL and MySQL
• 📊 Data Browsing — Browse table data with pagination
• 📝 SQL Execution — Execute arbitrary SQL queries
• 💾 State Persistence — Saves last used database, table, and SQL per connection

Tech Stack

| Layer | Technology | |-------------|--------------------------------| | Backend | Node.js + Express | | Frontend | HTML + CSS + JavaScript | | PostgreSQL | pg | | MySQL | mysql2 |

Configuration

Connection settings and state are stored in ~/.db-webpage/dbw-cache.json.

License

MIT