PostgreSQL Manager

Complete PostgreSQL database management for VS Code: explorer, connection profiles, SQL editor, query execution, table data viewer, roles, and database operations.

Features

1) Query Builder

• Visual query builder for constructing SQL queries without writing code
• Drag-and-drop tables/views from explorer to canvas
• Add/remove tables, joins, and conditions with UI controls
• Generate SQL from visual design and open in SQL editor
• Open query builder from table/view/schema/database context in explorer

2) Database Explorer

• Browse servers, databases, schemas, tables, views, functions, sequences, and roles
• Expand/collapse hierarchy with context-aware actions per node
• Filter objects by name and clear filters quickly
• Refresh explorer and node states on demand

3) Connection Management

• Add, edit, test, connect, disconnect, and remove PostgreSQL connections
• Store multiple connection profiles (pg.connections)
• Save passwords securely using VS Code SecretStorage
• SSL/TLS support in profile configuration
• Connection management from both explorer context menu and connections UI panel

4) SQL Query Editor

• Open SQL editor from connected server/database/schema nodes
• Run query (Ctrl+Enter / Cmd+Enter)
• Cancel running query (Ctrl+Shift+C / Cmd+Shift+C)
• Save SQL to file (Ctrl+S / Cmd+S)
• Request and use schema metadata in-editor for better authoring
• Copy, Paste, Cut, and Select All buttons in toolbar
• Copy (Ctrl+C), Paste (Ctrl+V), Cut (Ctrl+X), Select All (Ctrl+A)
• Context menu with copy/paste support
• Enhanced autocomplete with operators, snippets, and table aliases

5) Query Results Panel

• Multi-result rendering with column metadata
• Row count and elapsed time
• SQL notices/errors surfaced in UI

6) Table Data Viewer

• View table/view data in a paginated grid
• Server-side page fetch with sort and filter support
• In-grid cell editing and save/discard workflow
• Row selection and row delete workflow
• Foreign key lookup popover for FK columns
• Global text search in loaded page
• CSV export of visible/selected rows

7) Table Structure & Alter Table

• Open table structure panel with modern React UI
• Tabbed interface for columns, indexes, foreign keys, and constraints
• Inline editing for columns (name, type, nullable, default value)
• SQL preview before applying changes
• Add, modify, and delete columns directly from the UI
• Alter table actions:
  • Rename column
  • Change column type
  • Add column (with data type and nullable settings)
  • Drop column
  • Set column nullable / NOT NULL
  • Set column default value

8) Role/User Management

• View roles/users list
• Create role/user
• Alter role/user
• Drop role/user
• Manage role privileges

9) Database Operations

• Create database
• Drop database

10) SQL Code Generation

• Generate SELECT TOP 1000
• Generate INSERT
• Generate CREATE TABLE

11) SQL Autocompletion

• Context-aware completions based on schema metadata
• Suggestions for schemas, tables, columns, keywords, built-in functions, and types

Command Reference

Requirements

• Visual Studio Code 1.85.0+
• PostgreSQL 9.0+
• Node.js 18+ (development only)

Installation

1. Open VS Code
2. Go to Extensions (Ctrl+Shift+X)
3. Search for PostgreSQL Manager
4. Click Install

Marketplace: https://marketplace.visualstudio.com/items?itemName=mvintg.pg-manager

Getting Started

1. Open the PostgreSQL Manager activity bar view
2. Click Add Connection
3. Enter host, port, user, database, password, and SSL options
4. Connect from the server node
5. Start with New SQL Query or View Data on a table/view

Configuration

Keyboard Shortcuts

Notes

• The table data viewer currently supports edit/delete workflows in-grid.
• If you need to add records, use SQL editor (INSERT ...) or generated insert templates.

Development

npm install
npm run compile
npm run watch

License

MIT. See LICENSE.

Support

Issues and feature requests: https://github.com/mjavint/pgmanager/issues