All extensions

PostgreSQL Explorer v0.1.23

Browse and query PostgreSQL databases without leaving your editor. Inspired by Beekeeper Studio and IntelliJ’s database tools.

MIT license VS Code 1.85+ Works in Cursor PostgreSQL
pg-explorer — results panel
PostgreSQL Explorer showing query results in the VS Code bottom panel

Query editor bound to a connection, results in the bottom panel.

Features

What you get

Connection management

Add connections via JDBC URL or manual fields. Passwords are stored in VS Code secretStorage — never in plain-text settings.

Object browser

A lazy tree of connections → databases → schemas → tables, views, foreign tables, sequences, types and functions.

Query editor

A SQL editor bound to a connection. Press Ctrl+Enter (Cmd+Enter on macOS) to run.

Results panel

Result tabs with sorting, type-aware column filters, pagination, pinning, and in-flight cancellation.

Table actions

Right-click tables for Preview Data, Count Rows and View/Copy DDL.

Diagnostics & safety

Connection diagnostics (server info + active sessions), query history, bookmarks and a read-only mode for production databases.