🐘 PostgreSQL Explorer

Professional Database Management for VS Code

A comprehensive PostgreSQL database management extension featuring interactive SQL notebooks, real-time monitoring dashboard, and advanced database operations—all within VS Code.

🚀 Quick Start • 📖 Documentation • 🤝 Contributing • 💬 Support

🎯 Why PostgreSQL Explorer?

🎨 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 Database backup & restore
🔐 Secure & Reliable VS Code SecretStorage for credentials Safe connection management Transaction support Data integrity protection	🚀 Developer Friendly 🤖 GitHub Copilot integration Keyboard shortcuts IntelliSense support Export to CSV/Excel PSQL terminal integration

📸 Preview

📊 Real-Time Database Dashboard

Monitor connections, queries, and performance metrics in real-time

🔗 Connection Management

Manage multiple database connections with an intuitive interface

📑 Table of Contents

📚 Click to expand/collapse

✨ Features
🚀 Quick Start
📖 Usage Guide
🎓 Tutorials
🤝 Contributing
🏗️ Local Development
🔧 Troubleshooting
📫 Support

✨ Features

🔌 Connection Management

Secure & Flexible Connections

🔐 Secure Storage: Passwords encrypted with VS Code SecretStorage API
🔄 Multiple Connections: Switch between databases effortlessly
🎛️ Visual Dashboard: Intuitive UI for managing connections
⚡ Quick Toggle: Connect/disconnect with a single click
🏷️ Custom Names: Organize connections with friendly labels

{
  "name": "Production DB",
  "host": "db.example.com",
  "port": 5432,
  "username": "admin",
  "database": "myapp"
}

📊 Real-Time Database Dashboard

Note

The dashboard provides live metrics updated in real-time without manual refresh.

📈 Live Metrics & Monitoring (click to expand)

Metric	Description	Actions
🔗 Active Connections	Real-time connection count	View connection details
💾 Database Size	Current storage usage (MB/GB)	Track growth trends
⚡ Active Queries	Running query count	Cancel/Kill queries
🎯 Cache Hit Ratio	Cache performance percentage	Optimize performance

Performance Graphs:

📈 Connection trends over time
🔄 Query activity patterns
💾 Memory usage monitoring

Active Query Management:

✅ View all running queries with execution time
❌ Cancel long-running queries safely
🛑 Terminate stuck connections
📊 Query execution statistics

🌳 Database Explorer

Hierarchical Navigation

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

Supported Objects

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

📓 Interactive SQL Notebooks

🎯 Notebook Features (click to expand)

Create & Execute Queries

-- Cell 1: Data Analysis
SELECT 
  date_trunc('day', created_at) as day,
  COUNT(*) as user_count
FROM users
WHERE created_at >= NOW() - INTERVAL '30 days'
GROUP BY day
ORDER BY day;

-- Cell 2: Performance Check
EXPLAIN ANALYZE
SELECT * FROM orders 
WHERE customer_id = 123;

Key Features:

✅ Multi-cell execution
⌨️ Ctrl+Enter to run cell
🤖 AI-Powered Assistance: GitHub Copilot & agentic support
📊 Rich tabular output
🎨 Syntax highlighting
💾 Export to CSV/Excel
📈 Row count & execution time
🔄 Result sorting by column

[!TIP] AI-Powered SQL Development: The notebook interface fully supports GitHub Copilot and other agentic AI tools, providing intelligent code completion, query suggestions, and automated SQL generation directly in your notebooks!

Interactive SQL notebooks with rich output formatting

🛠️ Object Operations

📊 Table Operations

Data Management

✅ View data with pagination
➕ Insert new rows
✏️ Update existing data
🗑️ Delete rows
🧹 Truncate table
❌ Drop table

Structure Management

🔍 View table properties (columns, constraints, indexes)
✏️ Edit table definition
📋 Show column details with data types
🔗 View foreign key relationships

Script Generation

-- Quick script generation
SELECT * FROM employees;                    -- SELECT
INSERT INTO employees (...) VALUES (...);  -- INSERT
UPDATE employees SET ... WHERE ...;        -- UPDATE
DELETE FROM employees WHERE ...;           -- DELETE
CREATE TABLE employees (...);              -- CREATE

Maintenance Tools

🧹 VACUUM: Clean up dead rows and reclaim space
📊 ANALYZE: Update table statistics for query planner
🔄 REINDEX: Rebuild indexes for optimal performance

👁️ View Operations

Regular Views

📖 View definition display
✏️ Edit view SQL
🔍 Query view data
❌ Drop view

Materialized Views

🔄 Refresh cached data
📊 View current data
✏️ Edit definition
❌ Drop materialized view

⚙️ Function Management

📖 View function properties (signature, parameters, return type)
✏️ Edit definition (CREATE OR REPLACE)
▶️ Call function with parameters
📝 View source code
❌ Drop function

Example Function Creation:

CREATE OR REPLACE FUNCTION calculate_total(
  item_price DECIMAL,
  quantity INTEGER
)
RETURNS DECIMAL AS $$
BEGIN
  RETURN item_price * quantity;
END;
$$ LANGUAGE plpgsql;

📂 Schema Operations

Schema Management

🔍 View schema properties
➕ Create objects within schema
📜 Generate schema scripts
🔧 Schema-level operations

Quick Object Creation

Object Type	Shortcut
📊 Table	Right-click → Create Table
👁️ View	Right-click → Create View
🔄 Materialized View	Right-click → Create Materialized View
⚙️ Function	Right-click → Create Function
🏷️ Type	Right-click → Create Type
🔗 Foreign Table	Right-click → Create Foreign Table

Create database objects with intelligent templates

🚀 Quick Start

📦 Installation

Option 1: VS Code Marketplace

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

Option 2: Command Line

# Install from VSIX
code --install-extension postgres-explorer-*.vsix

# Or using the extension ID
ext install ric-v.postgres-explorer

🔗 First Connection

Tip

Test your connection using psql before adding it to the extension.

Step-by-Step Setup:

Open Extension
- Click the PostgreSQL icon in Activity Bar
- Or press Ctrl+Shift+P → PostgreSQL: Add Connection

Enter Connection Details

Connection Name: My Local Database
Host:           localhost
Port:           5432
Username:       postgres
Password:       ••••••••
Database:       myapp_dev

Save & Connect
- Click Save to store credentials securely
- Connection appears in explorer
- Click to connect and start exploring

Warning

Passwords are encrypted and stored securely using VS Code's SecretStorage API.

📖 Usage Guide

🧭 Navigation Basics

Tree Navigation

🔍 Expand Connections → View databases
📂 Browse Schemas → See available schemas
📊 Explore Objects → Navigate Tables/Views/Functions
🖱️ Right-Click → Access context menus

Keyboard Shortcuts

F5 - Refresh current item
Ctrl+Enter - Execute query
Ctrl+Shift+P - Command palette
Right-click - Context operations

📊 Working with Tables

🔍 Viewing Table Data

Right-click table → View Table Data
Data opens in new tab with pagination
Click column headers to sort
Use export buttons for CSV/Excel

Pro Tip: Double-click table for quick data view

✏️ Editing Table Structure

Right-click table → Show Table Properties
Review columns, constraints, indexes
Select Edit Table Definition to modify
Make changes in SQL editor
Execute to apply

Example Modification:

ALTER TABLE employees
ADD COLUMN department VARCHAR(100),
ADD COLUMN hire_date DATE DEFAULT CURRENT_DATE;

📜 Generating Scripts

Right-click table → Scripts → Choose type:

Script Type	Use Case
📋 SELECT	Query template with all columns
➕ INSERT	Insert template with column list
✏️ UPDATE	Update template with WHERE clause
🗑️ DELETE	Delete template with conditions
🏗️ CREATE	Full table definition script

📓 SQL Notebooks Workflow

Note

Notebooks support multiple cells for organizing complex queries.

1. Create Notebook

Right-click database/schema/table → New PostgreSQL Notebook

2. Write Queries

-- Cell 1: Setup
CREATE TEMP TABLE report_data AS
SELECT * FROM sales WHERE date >= '2024-01-01';

-- Cell 2: Analysis
SELECT 
  product_category,
  SUM(amount) as total_sales,
  COUNT(*) as order_count
FROM report_data
GROUP BY product_category
ORDER BY total_sales DESC;

-- Cell 3: Cleanup
DROP TABLE report_data;

3. Execute & Export

Press Ctrl+Enter on each cell
Review results inline
Export to CSV/Excel as needed

4. AI-Powered Assistance 🤖

Note

The notebook interface seamlessly integrates with GitHub Copilot and other agentic AI tools for intelligent SQL assistance.

New in v0.2.3: Enhanced AI Integration

✨ "Ask AI" CodeLens: Click the link directly above any SQL query to get instant help.
🔘 Inline Toolbar Button: Access AI assistance from the cell toolbar.
🧠 Multiple Providers: Support for Google Gemini, OpenAI, Anthropic, and GitHub Copilot.
⚡ Pre-defined Tasks: Quickly Explain, Fix, Optimize, or Format your queries.

Copilot Features Available:

💡 Intelligent Code Completion: Auto-complete SQL queries as you type
🔍 Context-Aware Suggestions: Get relevant table/column suggestions
✨ Query Generation: Describe what you want in comments, let AI write the SQL
🐛 Error Detection: Real-time syntax and logical error detection
📝 Query Optimization: Suggestions for improving query performance
💬 Natural Language to SQL: Convert plain English to SQL queries

Example AI-Assisted Workflow:

Click "✨ Ask AI" above your query.
Select a task (e.g., "Optimize Query") or type a custom instruction.
Watch as the AI transforms your SQL in real-time!

-- Cell 1: Ask AI to generate a query
-- Create a query to find top 10 customers by total purchase amount in the last month

-- Copilot generates:
SELECT 
  c.customer_id,
  c.name,
  SUM(o.amount) as total_spent
FROM customers c
JOIN orders o ON c.id = o.customer_id
WHERE o.created_at >= NOW() - INTERVAL '30 days'
GROUP BY c.customer_id, c.name
ORDER BY total_spent DESC
LIMIT 10;

Agentic AI Support:

🎯 Multi-step query planning and execution
🔄 Automated refactoring and optimization
📊 Data analysis suggestions
🧪 Test data generation

📊 Database Dashboard Usage

Right-click database → Show Database Dashboard

Dashboard Components:

Section	Information	Actions
📈 Metrics Panel	Connections, Size, Queries, Cache	Real-time updates
📊 Performance Graphs	Trends over time	Visual analysis
🔍 Active Queries	Running queries with details	Cancel/Kill

Managing Active Queries:

Caution

Killing queries will terminate the client connection immediately.

View query details (SQL, duration, client)
Cancel - Sends cancellation request (graceful)
Kill - Terminates connection (forceful)
Confirm action in dialog

🎓 Tutorials

🎯 Tutorial 1: Creating a Complete Database Schema

Goal: Create a blog database with tables, views, and functions

Step 1: Create Tables

-- Users table
CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  username VARCHAR(50) UNIQUE NOT NULL,
  email VARCHAR(255) UNIQUE NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);

-- Posts table
CREATE TABLE posts (
  id SERIAL PRIMARY KEY,
  user_id INTEGER REFERENCES users(id) ON DELETE CASCADE,
  title VARCHAR(200) NOT NULL,
  content TEXT,
  published_at TIMESTAMP,
  created_at TIMESTAMP DEFAULT NOW()
);

-- Comments table
CREATE TABLE comments (
  id SERIAL PRIMARY KEY,
  post_id INTEGER REFERENCES posts(id) ON DELETE CASCADE,
  user_id INTEGER REFERENCES users(id) ON DELETE CASCADE,
  content TEXT NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);

Step 2: Create View

CREATE VIEW recent_posts AS
SELECT 
  p.id,
  p.title,
  u.username as author,
  p.published_at,
  COUNT(c.id) as comment_count
FROM posts p
JOIN users u ON p.user_id = u.id
LEFT JOIN comments c ON p.post_id = c.id
WHERE p.published_at IS NOT NULL
GROUP BY p.id, p.title, u.username, p.published_at
ORDER BY p.published_at DESC;

Step 3: Create Function

CREATE OR REPLACE FUNCTION get_user_post_count(user_id_param INTEGER)
RETURNS INTEGER AS $$
BEGIN
  RETURN (
    SELECT COUNT(*) 
    FROM posts 
    WHERE user_id = user_id_param 
      AND published_at IS NOT NULL
  );
END;
$$ LANGUAGE plpgsql;

Step 4: Use the Extension

Refresh schema in explorer
View table data
Query the view
Call the function with test data

🎯 Tutorial 2: Database Maintenance Routine

Goal: Optimize database performance

1. Check Table Bloat

SELECT 
  schemaname,
  tablename,
  pg_size_pretty(pg_total_relation_size(schemaname||'.'||tablename)) AS size
FROM pg_tables
WHERE schemaname = 'public'
ORDER BY pg_total_relation_size(schemaname||'.'||tablename) DESC;

2. Vacuum Large Tables

Right-click large table → Maintenance → VACUUM
Choose VACUUM FULL for maximum space reclamation

3. Update Statistics

Right-click table → Maintenance → ANALYZE
Improves query planning

4. Rebuild Indexes

Right-click table → Maintenance → REINDEX
Fixes index bloat and fragmentation

5. Monitor Results

View dashboard for cache hit ratio improvement
Check query performance

🎯 Tutorial 3: Data Migration Workflow

Goal: Export data from one database and import to another

1. Export Source Data

-- In source database notebook
SELECT * FROM users WHERE active = true;

Execute query
Export to CSV

2. Backup Source Database

Right-click database → Backup
Choose location and format
Save backup file

3. Create Target Schema

Connect to target database
Run CREATE TABLE scripts

4. Import Data

-- Use COPY command or insert from CSV
COPY users FROM '/path/to/users.csv' 
WITH (FORMAT csv, HEADER true);

5. Verify Migration

SELECT COUNT(*) FROM users;
SELECT * FROM users LIMIT 10;

🤝 Contributing

🌟 We Love Contributors!

Your contributions make this extension better for everyone.

🎯 Ways to Contribute

🐛 Report Bugs

Found a bug? Help us fix it!

Search existing issues first
Include reproduction steps
Provide error messages/logs
Mention versions (VS Code, extension)

Report Bug →

💡 Suggest Features

Have an idea? We'd love to hear it!

Describe the use case
Explain expected behavior
Provide examples
Consider implementation

Request Feature →

🔧 Submit Code

Ready to code? Here's how!

Fork the repository
Create feature branch
Make your changes
Write/update tests
Open pull request

View Code →

📋 Development Guidelines

💻 Code Style

✅ Follow TypeScript best practices
✅ Use meaningful variable/function names
✅ Add comments for complex logic
✅ Keep functions small and focused
✅ Use async/await for async operations

🧪 Testing

✅ Test changes thoroughly
✅ Include test cases for new features
✅ Ensure existing tests pass
✅ Test with different PostgreSQL versions
✅ Test edge cases

📝 Documentation

✅ Update README for new features
✅ Add JSDoc comments to functions
✅ Update CHANGELOG.md
✅ Include usage examples
✅ Document breaking changes

📜 Commit Convention

We follow Conventional Commits:

feat: add materialized view refresh functionality
fix: resolve connection timeout issue
docs: update installation instructions
refactor: simplify query execution logic
test: add tests for table operations
chore: update dependencies

Types:

feat: New feature
fix: Bug fix
docs: Documentation only
style: Code style changes
refactor: Code refactoring
perf: Performance improvements
test: Adding/updating tests
chore: Maintenance tasks

🏗️ Local Development

🛠️ Prerequisites

Tool	Version	Purpose
Node.js	≥ 18.0.0	Runtime environment
npm	≥ 8.0.0	Package manager
VS Code	≥ 1.80.0	Development IDE
PostgreSQL	Any	Testing database
Git	Latest	Version control

🚀 Setup Instructions

Step-by-Step Setup

1. Clone Repository

git clone https://github.com/dev-asterix/yape-postgres-ext-vsc.git
cd yape-postgres-ext-vsc

2. Install Dependencies

npm install

3. Compile TypeScript

# One-time compilation
npm run compile

# Watch mode (auto-recompile)
npm run watch

4. Open in VS Code

code .

5. Run Extension

Press F5 to launch Extension Development Host
Or use Run and Debug panel (Ctrl+Shift+D)
Select "Run Extension" configuration
Click green play button ▶️

6. Debug Extension

Set breakpoints in .ts files
Press F5 to start debugging
Use Debug Console for inspection
Step through code with toolbar

📁 Project Structure

yape-postgres-ext-vsc/
│
├── 📂 src/                          # Source code
│   ├── 📄 extension.ts             # Extension entry point
│   ├── 📂 commands/                # Command implementations
│   │   ├── tables.ts               # Table operations
│   │   ├── views.ts                # View operations
│   │   ├── functions.ts            # Function operations
│   │   └── ...
│   ├── 📂 services/                # Business logic
│   │   ├── ConnectionManager.ts   # Connection handling
│   │   ├── QueryExecutor.ts       # Query execution
│   │   └── ...
│   ├── 📂 providers/               # VS Code providers
│   │   ├── TreeDataProvider.ts    # Tree view
│   │   ├── NotebookProvider.ts    # Notebook support
│   │   └── ...
│   ├── 📂 views/                   # Webview panels
│   │   ├── dashboard/             # Dashboard UI
│   │   ├── connection/            # Connection UI
│   │   └── ...
│   └── 📂 utils/                   # Utility functions
│
├── 📂 resources/                    # Static resources
│   ├── 📂 screenshots/             # Documentation images
│   ├── 📂 icons/                   # Extension icons
│   └── ...
│
├── 📂 out/                         # Compiled JavaScript
├── 📂 dist/                        # Bundled extension
│
├── 📄 package.json                 # Extension manifest
├── 📄 tsconfig.json               # TypeScript configuration
├── 📄 README.md                   # This file
└── 📄 CHANGELOG.md                # Version history

🔨 Common Commands

Command	Description
`npm install`	Install dependencies
`npm run compile`	Compile TypeScript once
`npm run watch`	Watch mode (auto-compile)
`npm run vscode:prepublish`	Build for production
`vsce package`	Create VSIX package
`vsce publish`	Publish to marketplace

🧪 Testing Setup

🐳 Docker PostgreSQL for Testing

Quick Start:

docker run --name postgres-test \
  -e POSTGRES_PASSWORD=test123 \
  -e POSTGRES_DB=testdb \
  -p 5432:5432 \
  -d postgres:latest

Create Test Data:

CREATE TABLE test_users (
  id SERIAL PRIMARY KEY,
  username VARCHAR(50) NOT NULL,
  email VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);

INSERT INTO test_users (username, email)
SELECT 
  'user' || generate_series,
  'user' || generate_series || '@example.com'
FROM generate_series(1, 100);

Cleanup:

docker stop postgres-test
docker rm postgres-test

🐛 Debugging Tips

Extension Logging

Open Output panel: Ctrl+Shift+U
Select "PostgreSQL Explorer" from dropdown
View real-time extension logs
Look for errors and warnings

Developer Tools

In Extension Development Host:

Press Ctrl+Shift+I to open DevTools
Check Console tab for errors
Use Network tab for requests
Inspect Elements tab for UI issues

Webview Debugging

Right-click in webview panel
Select "Inspect"
Use Chrome DevTools
Debug HTML/CSS/JavaScript

🔧 Troubleshooting Development

TypeScript Compilation Errors

# Clear compiled output
rm -rf out/

# Reinstall dependencies
rm -rf node_modules/ package-lock.json
npm install

# Recompile
npm run compile

Extension Not Loading

Check:

✅ package.json syntax is valid
✅ Activation events are correct
✅ Extension host output for errors
✅ All dependencies are installed

Solutions:

Reload window: Ctrl+R
Restart VS Code
Check Extension Host logs

🔧 Troubleshooting

🔌 Connection Issues

⚠️ Cannot connect to database

Symptoms:

Connection timeout
Authentication failed
Server not found

Solutions:

Verify Connection Details

# Test with psql
psql -h localhost -p 5432 -U postgres -d mydb

Check PostgreSQL Status

# Linux
sudo service postgresql status
sudo service postgresql start

# MacOS
brew services list
brew services start postgresql

# Windows
# Check Services → PostgreSQL

Verify pg_hba.conf
- Allow connections from your client IP
- Check authentication method
- Reload PostgreSQL after changes

Firewall Settings

# Linux - allow PostgreSQL port
sudo ufw allow 5432/tcp

Test Connectivity

# Check if port is open
telnet localhost 5432
nc -zv localhost 5432

[!TIP] Enable logging in PostgreSQL to see connection attempts.

⏱️ Connection timeout

Causes:

Network latency
Server overload
Firewall blocking

Solutions:

Increase timeout in VS Code settings
Check network connectivity
Verify server is accepting connections
Check max_connections setting

⚡ Query Issues

🐌 Query timeout

Optimization Steps:

Add WHERE Clauses

-- Instead of
SELECT * FROM large_table;

-- Use
SELECT * FROM large_table 
WHERE created_at >= NOW() - INTERVAL '7 days'
LIMIT 1000;

Create Indexes

CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_orders_date ON orders(created_at);

Use EXPLAIN

EXPLAIN ANALYZE
SELECT * FROM orders WHERE customer_id = 123;

Adjust Settings
- Increase statement_timeout in PostgreSQL
- Increase query timeout in extension settings

💾 Out of memory

Solutions:

Reduce result set size with LIMIT
Use pagination for large datasets
Export data in chunks
Increase VS Code memory: --max-memory=4096

📤 Export Issues

❌ Cannot export data

Problem	Solution
Permission denied	Check workspace folder permissions
File in use	Close file in other applications
Disk full	Check available disk space
Large dataset	Export in chunks or use LIMIT

⚙️ Configuration

🎛️ Extension Settings

Access via Ctrl+, or File → Preferences → Settings

{
  // Connection Management
  "postgresExplorer.connections": [],           // Saved connections
  "postgresExplorer.autoConnect": true,        // Auto-connect on startup
  
  // Query Settings
  "postgresExplorer.maxResults": 1000,         // Max rows per query
  "postgresExplorer.queryTimeout": 30000,      // Query timeout (ms)
  
  // Display Settings
  "postgresExplorer.dateFormat": "YYYY-MM-DD", // Date display format
  "postgresExplorer.numberFormat": "en-US",    // Number formatting
  
  // Export Settings
  "postgresExplorer.exportPath": "./exports",  // Default export path
  "postgresExplorer.csvDelimiter": ",",        // CSV delimiter
  
  // Performance
  "postgresExplorer.cacheEnabled": true,       // Enable caching
  "postgresExplorer.refreshInterval": 5000     // Dashboard refresh (ms)
}

📝 License

This extension is licensed under the MIT License.

MIT License - Copyright (c) 2024

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files...

📫 Support

💬 Get Help

📚 Documentation

GitHub Wiki

Comprehensive guides and tutorials

🐛 Report Issues

GitHub Issues

Found a bug? Let us know!

💡 Discussions

GitHub Discussions

Ask questions, share ideas

⭐ Rate Us

Marketplace

Enjoying the extension?

🌟 Community

⭐ Star the repository on GitHub
🐦 Follow updates and announcements
💬 Join community discussions
🤝 Contribute to make it better!

📊 Project Stats

💖 Made with Love for the PostgreSQL Community

Built by developers, for developers

⬆ Back to Top

⭐ If you find this extension helpful, please consider giving it a star on GitHub and rating it on the VS Code Marketplace!

Or the [OpenVSX marketplace](https://open-vsx.org/extension/ric-v/postgres-explorer).

Name		Name	Last commit message	Last commit date
Latest commit History 81 Commits
.github/workflows		.github/workflows
.vscode		.vscode
docs		docs
resources		resources
src		src
.gitignore		.gitignore
.nycrc		.nycrc
.vscodeignore		.vscodeignore
CHANGELOG.md		CHANGELOG.md
LICENSE		LICENSE
Makefile		Makefile
README.md		README.md
index.js		index.js
index.js.map		index.js.map
package.json		package.json
tsconfig.json		tsconfig.json
webpack.config.js		webpack.config.js

License

dev-asterix/yape-postgres-ext-vsc

Folders and files

Latest commit

History

Repository files navigation

🐘 PostgreSQL Explorer

Professional Database Management for VS Code

🎯 Why PostgreSQL Explorer?

🎨 Modern Interface

⚡ Powerful Features

🔐 Secure & Reliable

🚀 Developer Friendly

📸 Preview

📊 Real-Time Database Dashboard

🔗 Connection Management

📑 Table of Contents

✨ Features

🔌 Connection Management

📊 Real-Time Database Dashboard

🌳 Database Explorer

📓 Interactive SQL Notebooks

🛠️ Object Operations

🚀 Quick Start

📦 Installation

🔗 First Connection

📖 Usage Guide

🧭 Navigation Basics

📊 Working with Tables

📓 SQL Notebooks Workflow

📊 Database Dashboard Usage

🎓 Tutorials

🤝 Contributing

🌟 We Love Contributors!

🎯 Ways to Contribute

📋 Development Guidelines

📜 Commit Convention

🏗️ Local Development

🛠️ Prerequisites

🚀 Setup Instructions

📁 Project Structure

🔨 Common Commands

🧪 Testing Setup

🐛 Debugging Tips

🔧 Troubleshooting Development

🔧 Troubleshooting

🔌 Connection Issues

⚡ Query Issues

📤 Export Issues

⚙️ Configuration

🎛️ Extension Settings

📝 License

📫 Support

💬 Get Help

📚 Documentation

🐛 Report Issues

💡 Discussions

⭐ Rate Us

🌟 Community

📊 Project Stats

💖 Made with Love for the PostgreSQL Community

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors 3

Uh oh!

Languages

Packages