pg-explorer-vsce

A Visual Studio Code extension for browsing and querying PostgreSQL databases, inspired by Beekeeper Studio and IntelliJ's database tools

• Connection management — add via JDBC URL or manual fields; passwords in VS Code secretStorage.
• Object browser — lazy tree of connections → databases → schemas → tables / views / foreign tables / sequences / types / functions.
• Query editor — a SQL editor bound to a connection; Ctrl+Enter (Cmd+Enter on macOS) to run.
• Results panel — result tabs in the bottom panel with sorting, type-aware column filters, pagination, pinning, and in-flight cancellation.
• Diagnostics, history, bookmarks, read-only mode — see FEATURES.md.

📖 FEATURES.md — the full feature list. 📖 USAGE.md — walkthrough and every command. ⚙️ CONFIGURATION.md — settings and the security model (credential storage, TLS, read-only mode).

Requirements

• A PostgreSQL server reachable from your machine.
• VS Code 1.85+ (or Cursor), via the Extension Development Host or an installed .vsix.

Quick start

1. Open the PostgreSQL Explorer view in the Activity Bar and click Add Connection.
2. Expand a connection → database → schema, right-click a connection for New Query, then press Ctrl+Enter.

Right-click tables for Preview Data, Count Rows, View/Copy DDL; right-click a connection for Connection Diagnostics (server info + active sessions).

Development

npm install
npm run build        # bundle with esbuild
npm run typecheck    # type check without emitting
npm test             # run unit tests (node --test)

Open the extension Development Host via the Run and Debug view (extension launch config) to test it live.

License

MIT