A user-friendly PostgreSQL database viewer for Visual Studio Code.
Features
Connection Management — Add, edit, and delete PostgreSQL connections with SSL support. Passwords stored securely in your OS keychain.
Database Explorer — Browse your database hierarchy in the sidebar: Connections > Databases > Schemas > Tables / Views / Functions.
Tabular Data Viewer — View table data in a fast, scrollable grid powered by AG Grid. Supports sorting, filtering, and pagination with configurable page sizes.
Inline Editing — Double-click any cell to edit values directly. Changes are saved to the database instantly via parameterized queries. Available for tables with primary keys.
Table Describe — Inspect table structure with tabs for Columns, Constraints, and Indexes. Shows column types, nullability, defaults, primary keys, foreign key references, and index definitions.
SQL Query Editor — Write and run SQL queries using VS Code's built-in editor with syntax highlighting. Press Cmd+Enter (Mac) or Ctrl+Enter (Windows/Linux) to execute.
JSONB Support — JSON and JSONB columns display as formatted JSON with pretty-printed tooltips on hover. Edit JSON values inline.
Export — Export table data or query results to CSV or JSON files.
Theme Integration — Seamlessly adapts to your VS Code theme (dark and light).
Getting Started
Click the DB Viewer icon in the Activity Bar
Click Add Connection and enter your PostgreSQL connection details
Browse your database tree, right-click tables to View Data or Describe Table
Open a New SQL Query from the toolbar to write and execute queries
