DB Nexus

> Database management tool with web UI


Features

- 🖥️ Modern Web UI - Beautiful interface for database management
- 🔌 Multiple Databases - PostgreSQL, MySQL, SQLite
- 🔄 Schema Sync - Compare and migrate schemas between databases
- 📊 Data Sync - Synchronize table data with conflict resolution
- 🗺️ Schema Diagram - Visual database schema editor with drag-and-drop
- 🔗 FK Navigation - Click foreign key values to query referenced rows
- 📜 Query History - Track and replay queries
- 🔒 Secure - Encrypted credentials with AES-256-GCM
- 🛡️ Safety First - Production guardrails for dangerous queries
- 🔎 Auto-Discovery - Scan for databases via ports, Docker, env files

Installation

$3

``bash
npm install -g dbnexus
`

$3

`bash
npx dbnexus
`

Usage

Start DB Nexus:

`bash
dbnexus
`

This will start the server and open your browser to http://localhost:3001.

$3

`bash
dbnexus --port 8080 # Run on custom port
dbnexus --data-dir /path # Use custom data directory
dbnexus --no-open # Don't open browser automatically
dbnexus --help # Show help
`

$3

`bash
dbnexus # Start DB Nexus (default)
dbnexus start # Explicit start command
dbnexus --version # Show version
`

Data Storage

DB Nexus stores its metadata database in:

- Linux/Mac: ~/.dbnexus/metadata.db
- Windows: %USERPROFILE%\.dbnexus\metadata.db

You can customize this location:

`bash


Using flag

dbnexus --data-dir /custom/path

Using environment variable

DBNEXUS_DATA_DIR=/custom/path dbnexus
`

Features Overview

$3

- Add and manage multiple database connections
- Organize connections into projects and groups
- Test connection health
- Encrypted credential storage
- Auto-discover databases via port scanning and Docker

$3

- Execute SQL queries with syntax highlighting
- View results in a data grid
- Edit data inline
- Click FK values to navigate to referenced rows
- Query history and saved queries

$3

- Browse tables, columns, indexes, and foreign keys
- Visual schema diagram with drag-and-drop
- Compare schemas between databases
- Generate migration SQL
- Apply schema changes

$3

- Compare data between tables
- Sync data with conflict resolution
- Bulk data operations
- Dump and restore databases

Requirements

- Node.js 18 or higher
- One of: PostgreSQL, MySQL, or SQLite

Supported Databases

- PostgreSQL 9.6+
- MySQL 5.7+
- MariaDB 10.2+
- SQLite 3.0+

Configuration

$3

- DBNEXUS_DATA_DIR - Custom data directory
- PORT - Server port (default: 3001)
- NODE_ENV - Environment (development/production)

Uninstallation

`bash


Remove the package

npm uninstall -g dbnexus

Remove all data

rm -rf ~/.dbnexus
``

Documentation

- GitHub Repository
- Issue Tracker

Contributing

Contributions are welcome! Please see our Contributing Guide.

License

AGPL-3.0 © DB Nexus Team

Support

- 🐛 Issues: GitHub Issues
- 💬 Discussions: GitHub Discussions

---

Like Prisma Studio, but for any database - Manage PostgreSQL, MySQL,and SQLite databases with a beautiful web interface.