Free Database Client

A free, open-source universal database client for Visual Studio Code.

Features

• 🔌 Multiple Database Support — PostgreSQL, Amazon RDS, Amazon Redshift (MySQL, Redis, MongoDB coming soon)
• 🔐 Secure Credential Storage — Passwords stored via VS Code's SecretStorage API (never in plaintext)
• 🚇 SSH Tunnel — Connect through bastion hosts with password, private key, or SSH agent auth
• 🌐 Proxy Support — SOCKS5, HTTP, and HTTPS proxy connectivity
• 📊 Rich Query Editor — SQL editor with line numbers, keyboard shortcuts, and basic formatting
• 📋 Results Viewer — Sortable results table with data type coloring and row counts
• 📤 Export — Export to CSV (RFC 4180, Excel-compatible), JSON, or SQL INSERT statements
• 🌳 Database Explorer — Sidebar tree view with schemas, tables, views, columns, functions, procedures
• 🔒 SSL/TLS — Full SSL support with CA, client certificate, and client key configuration
• 🎨 Connection Colors — Color-code your connections for visual organization

Getting Started

1. Install the extension from the VS Code Marketplace (or press F5 to debug)
2. Click the database icon in the Activity Bar
3. Click + to add a new connection
4. Fill in your connection details and click Save
5. Click the connection to connect, then explore your database

Architecture

src/
├── extension.ts                    # Entry point
├── core/
│   ├── interfaces/                 # IDatabaseDriver, types
│   ├── security/                   # SecureStorageManager
│   ├── tunnel/                     # SSH tunnel (ssh2)
│   ├── proxy/                      # SOCKS5/HTTP proxy
│   ├── export/                     # CSV, JSON, SQL export
│   └── ConnectionManager.ts        # Connection lifecycle
├── drivers/
│   ├── DriverFactory.ts            # Factory pattern
│   ├── postgres/                   # PostgreSQL driver + dialect
│   └── redshift/                   # Redshift driver + dialect
├── providers/
│   ├── DatabaseTreeProvider.ts     # Sidebar tree view
│   └── DatabaseTreeItem.ts         # Tree node types
└── webview/
    ├── WebviewPanelManager.ts      # postMessage bridge
    └── html/
        ├── connectionForm.html     # Connection configuration UI
        └── queryPanel.html         # SQL editor + results UI

Development

# Install dependencies
npm install

# Watch mode (auto-recompile on save)
npm run dev

# Press F5 in VS Code to launch Extension Development Host

Contributing

Contributions welcome! Please open an issue or PR.

License

MIT