⚠️ DEPRECATED

This extension has been renamed to PgStudio. Please install the new extension:

VSCode Marketplace: 👉 https://marketplace.visualstudio.com/items?itemName=ric-v.postgres-explorer

Open VSX: 👉 https://open-vsx.org/extension/ric-v/postgres-explorer

🐘 PgStudio

Professional Database Management for VS Code

PgStudio is a comprehensive PostgreSQL database management extension featuring interactive SQL notebooks, real-time monitoring dashboard, AI-powered assistance, and advanced database operations—all within VS Code.

📸 Screenshots

🎥 Video Guides

1. Quick Setup

PgStudio Setup

2. Database Explorer

Database Explorer

3. AI Assistant Configuration

AI Assistant Setup

4. AI Assistant In-Action

AI Assistant Usage

✨ Key Features

Feature	Description
🔌 Secure Connections	Manage multiple connections with VS Code SecretStorage encryption
📊 Live Dashboard	Real-time metrics, active query monitoring, and performance graphs
📓 SQL Notebooks	Interactive notebooks with rich output, AI assistance, and export options
🌳 Database Explorer	Browse tables, views, functions, types, extensions, and roles
🛠️ Object Operations	Full CRUD operations, scripts, VACUUM, ANALYZE, REINDEX
🤖 AI-Powered	GitHub Copilot, OpenAI, Anthropic, and Google Gemini integration
⌨️ Developer Tools	IntelliSense, keyboard shortcuts, PSQL terminal access
📤 Export Data	Export query results to CSV, JSON, or Excel formats

🎯 Why PgStudio?

🎨 Modern Interface

Beautiful, intuitive UI designed for developers
Real-time dashboard with live metrics
Context-aware operations
Seamless VS Code integration

⚡ Powerful Features

Interactive SQL notebooks
🤖 AI-powered Copilot & agentic support
Advanced query management
Complete CRUD operations

🔐 Secure & Reliable

VS Code SecretStorage for credentials
Safe connection management
Transaction support
Data integrity protection

🚀 Developer Friendly

🤖 GitHub Copilot integration
Keyboard shortcuts
IntelliSense support
PSQL terminal integration

🌳 Database Explorer

Navigate your database with an intuitive hierarchical tree view:

📁 Connection
└── 🗄️ Database
    └── 📂 Schema
        ├── 📊 Tables
        ├── 👁️ Views
        ├── 🔄 Materialized Views
        ├── ⚙️ Functions
        ├── 🏷️ Types
        ├── 🔗 Foreign Tables
        ├── 🧩 Extensions
        └── 👥 Roles

🤖 AI-Powered Assistance

Leverage AI to write, optimize, and debug your queries faster:

Smart Completions — Context-aware SQL suggestions
Query Explanation — Understand complex queries in plain English
Query Optimization — Get performance improvement suggestions
Error Detection — Real-time syntax and logical error detection
Natural Language to SQL — Describe what you need, let AI write the SQL

🛡️ Safe AI Execution

PgStudio provides a Safe Execution Model for AI interactions.

Human-in-the-Loop: AI generates the code, but it is never executed automatically. You review it in a notebook cell first.
Context Control: You decide which tables the AI can see.

Supported AI Providers:

GitHub Copilot (VS Code LM)
OpenAI
Anthropic Claude
Google Gemini

🎨 Rich Data Visualization

Transform your data into insights without exporting to Excel.

Instantly Visualize Results

One-Click Charts: Create Bar, Line, Area, and Pie charts from any query result.
Customizable: Adjust log scales, use varied point styles, and control fill opacity.
Modern VFX: Enable Glow and Blur effects for stunning, dashboard-ready visuals.
Custom Endpoints

🚀 Quick Start

Installation

Open VS Code → Press Ctrl+Shift+X
Search for PostgreSQL Explorer
Click Install

Or install via command line:

code --install-extension ric-v.postgres-explorer

First Connection

Click the PostgreSQL icon in the Activity Bar
Click Add Connection or use Ctrl+Shift+P → PostgreSQL: Add Connection
Enter your connection details and click Save
Click on your connection to connect and start exploring!

📊 Complete Database Operations

Object Type	Operations
📊 Tables	View, Edit, Insert, Update, Delete, Truncate, Drop, VACUUM, ANALYZE, REINDEX
👁️ Views	View Definition, Edit, Query Data, Drop
🔄 Materialized Views	Refresh, View Data, Edit, Drop
⚙️ Functions	View, Edit, Call with Parameters, Drop
🏷️ Types	View Properties, Edit, Drop
🔗 Foreign Tables	View, Edit, Drop
🧩 Extensions	Enable, Disable, Drop
👥 Roles	Grant/Revoke Permissions, Edit, Drop

⌨️ Keyboard Shortcuts

Shortcut	Action
`Ctrl+Enter`	Execute current cell
`Shift+Enter`	Execute and move to next
`F5`	Refresh current item
`Ctrl+Shift+P`	Command palette

📚 Resources

📝 License

This extension is licensed under the MIT License.

Made with ❤️ for the PostgreSQL Community

Also available on Open VSX

[DEPRECATED] PgStudio (previously PostgreSQL Explorer)

astrx.dev