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 selectivo: refresca solo una base de datos, schema o tabla/vista sin recargar todo el árbol

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
• Truncate table with RESTART IDENTITY and CASCADE options

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
• Change database owner

10) SQL Code Generation

• Generate SELECT TOP 1000
• Generate INSERT
• Generate CREATE TABLE
• Show DDL (Display CREATE statement for tables, views, functions, and sequences)

11) Database Schema Modeler

A full visual schema designer for PostgreSQL — right-click any database or schema in the explorer and select Open Database Modeler.

• Reverse-engineer existing schemas into interactive ERD diagrams automatically
• Interactive canvas with pan, zoom, drag, and minimap navigation
• Auto-layout using dagre (Left→Right or Top→Bottom)
• Create tables graphically with a full column editor:
  • Name, type (30+ PostgreSQL types), length, precision/scale
  • Primary Key, Unique, Nullable, Default value, Check constraint
• Visual relationship designer — draw connections between tables and choose the type:
  • Many to One (N:1): adds FK column to source table automatically
  • One to Many (1:N): adds FK column to target table automatically
  • Many to Many (M:N): creates a junction table with composite PK automatically
• FK edge properties panel — configure constraint name, ON DELETE, ON UPDATE actions
• DDL generation: complete CREATE TABLE, ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY, and CREATE INDEX statements
• Apply to DB: execute the DDL directly against the connected database in a transaction — schema reloads automatically from DB after apply
• Undo/Redo (Ctrl+Z / Ctrl+Y) with full history stack
• Layout persistence: node positions saved to .vscode/pg-modeler/{schema}.layout.json
• Loading indicator: spinner overlay while the schema is being fetched and rendered

12) 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 (mvintg)
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.

License

MIT. See LICENSE.

Support

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