DB Manager

DB Manager is a VS Code / Cursor extension that brings full-featured database management directly into your editor. Connect to MySQL, MariaDB, PostgreSQL, SQLite, and Redis — browse schemas, write queries, edit data, and export results without leaving your IDE.

Supported Databases

Features

Connection Management

• Save and manage multiple database connections
• Organize connections into custom groups (folders)
• Color-coded connections for visual identification
• SSH tunnel support with password or private key authentication (passphrase supported)
• SSL/TLS support for secure remote connections
• Passwords stored securely in the OS keychain via VS Code SecretStorage
• Test connection and SSH tunnel before saving
• Create / Drop database directly from the sidebar context menu

Schema Browser

Explore your database structure from the Explorer sidebar with a lazy-loading tree view.

Connection Groups (custom folders)
  └─ Connection (MySQL / MariaDB / PG / SQLite / Redis)
       └─ Database
            └─ Schema (PostgreSQL only)
                 ├─ Tables
                 │    └─ Table
                 │         ├─ Columns (type, nullable, default, PK, auto-increment)
                 │         ├─ Indexes (unique, primary, composite)
                 │         └─ Foreign Keys (with cascade rules)
                 ├─ Views
                 └─ Routines / Triggers (PostgreSQL)

• Click a connection to auto-connect and expand its children
• Right-click context menus for every node level
• View DDL for tables and views
• Drop tables with confirmation
• Server information display (version, charset, uptime, platform)

SQL Query Editor

• Monaco Editor with SQL syntax highlighting
• Execute full query or selected text only (Cmd+Enter / Ctrl+Enter)
• Query cancellation — stop long-running queries mid-execution
• Database/schema context selector — switch target database without reconnecting
• Query history — browse and re-run up to 1,000 recent queries
• SQL file integration — open .sql files directly in the DB Manager query editor with connection context metadata
• Execution stats — elapsed time, affected rows, error details

Table Data Viewer & Editor

Powered by AG Grid for high-performance data browsing:

• Sort & filter columns by clicking headers
• Resize columns by dragging borders
• Pagination with First / Previous / Next / Last navigation (100 rows per page)
• WHERE clause filtering — apply custom filters without leaving the grid
• Inline editing — double-click cells to INSERT, UPDATE, or DELETE rows (requires primary key)
• Batch changes — stage multiple edits and apply them all at once
• Row insertion — add new rows via pinned top row
• Bulk delete — select multiple rows with checkboxes and delete at once
• Undo pending changes before saving

Data Export & Import

Export query results or entire tables in multiple formats:

Import data from files into tables:

• Auto-suggested filenames with timestamps
• Progress tracking for large exports/imports
• Row count confirmation before import

SQL File Integration

• Open .sql files directly in the DB Manager custom editor
• Auto-generated metadata header with connection name, type, database, and schema
• Execute queries with Cmd+Enter / Ctrl+Enter and view results inline
• Save queries to .sql files with Cmd+S / Ctrl+S

Backup & Restore

Back up and restore databases directly from the sidebar context menu.

• Auto-detection of CLI tools with manual override
• Progress tracking with cancellation support
• Timestamped backup filenames
• Works through SSH tunnels

Redis Browser

• Select database (0–15) with key count per database
• SCAN-based key browsing (safe for large databases — never uses KEYS *)
• Tree view representation of keys with configurable delimiter
• View, edit, and delete key values
• TTL management (view and set expiration)
• Add new keys with type selection (string, list, set, hash)

Internationalization

DB Manager supports multiple languages via VS Code's built-in localization:

Getting Started

1. Install DB Manager from the VS Code Marketplace or Open VSX Registry.
2. Open the Explorer sidebar — you'll see the DBManager - Connections panel.
3. Click the + button to add a new connection.
4. Fill in connection details, click Test Connection, then Save.
5. Click your saved connection to connect and browse schemas.
6. Right-click a table to View Data, Edit Data, Show DDL, or Export.
7. Right-click a database to open a New Query editor, Backup, or Restore.

Keyboard Shortcuts

Requirements

• VS Code 1.95+ or Cursor
• For backup/restore CLI features: mysqldump/mysql, pg_dump/psql installed locally (optional — SQL-based fallback is always available)

Development

# Install dependencies
pnpm install

# Build (shared → webview-ui → extension)
pnpm build

# Watch mode
pnpm dev

# Run tests
pnpm test

# Type check
pnpm typecheck

# Lint
pnpm lint

Press F5 in VS Code to launch the Extension Development Host.

Tech Stack

Support

If you find DB Manager useful, consider buying me a coffee!

License

MIT