Database Explorer for VS Code

A powerful PostgreSQL database explorer and query interface that integrates seamlessly into Visual Studio Code. Browse database schemas, execute SQL queries, and manage your data without leaving your development environment.

✨ Features

• 🗂️ Database Schema Browser: Explore databases, tables, columns, indexes, and constraints
• ⚡ SQL Query Execution: Run SQL queries with syntax highlighting and formatted results
• 📊 Data Browser: Browse and paginate through table data with smart formatting
• 🔍 Table Details: View table structure, indexes, constraints, and relationships
• 💾 Export Data: Export query results and table data to CSV
• 🎨 Native VS Code Integration: Clean UI that matches VS Code's design language
• 🔒 Secure Configuration: Environment-based connection management

🚀 Getting Started

Installation

1. Install from VS Code Marketplace: Search for "Database Explorer" by innoiso
2. Or install via command line: code --install-extension innoiso.vscode-database-explorer

Database Configuration

Option 1: Environment Variables (Recommended)

Create a .env file in your workspace root:

PGHOST=localhost
PGPORT=5432
PGDATABASE=your_database
PGUSER=your_username
PGPASSWORD=your_password

Option 2: VS Code Settings

Add to your VS Code settings:

{
  "databaseExplorer.host": "localhost",
  "databaseExplorer.port": 5432,
  "databaseExplorer.database": "your_database",
  "databaseExplorer.username": "your_username",
  "databaseExplorer.password": "your_password"
}

Usage

1. Open Database Explorer:

   • Click the database icon in the Activity Bar, or
   • Use Command Palette (Ctrl+Shift+P) → "Database Explorer: Open"

2. Explore Your Database:

   • Browse tables, views, and schemas in the Explorer tab
   • Click on tables to view structure and data
   • Use the SQL Query tab to run custom queries

3. Execute SQL Queries:

   • Write SQL in the query editor with syntax highlighting
   • Press Ctrl+Enter or click Run to execute
   • View results in formatted tables
   • Export results to CSV

🖼️ Screenshots

Database Schema Explorer

Browse your database structure with an intuitive tree view showing tables, columns, indexes, and constraints.

SQL Query Interface

Execute SQL queries with syntax highlighting, error reporting, and formatted result tables.

Table Data Browser

View and paginate through table data with smart column formatting and export capabilities.

📋 Supported Database Features

• ✅ Tables: View structure, data, indexes, constraints
• ✅ Views: Browse view definitions and data
• ✅ Schemas: Multi-schema database support
• ✅ Data Types: Full PostgreSQL data type support
• ✅ Indexes: View index definitions and usage
• ✅ Constraints: Primary keys, foreign keys, unique, check constraints
• ✅ SQL Execution: Full SQL query support with error handling

🔧 Requirements

• VS Code: Version 1.74.0 or higher
• PostgreSQL: Version 9.6 or higher
• Network Access: Connection to your PostgreSQL database

🛠️ Configuration

Workspace Settings

Configure per-workspace in .vscode/settings.json:

{
  "databaseExplorer.host": "your-db-host",
  "databaseExplorer.port": 5432,
  "databaseExplorer.database": "your-database",
  "databaseExplorer.username": "your-username"
}

Environment Variables

Supports standard PostgreSQL environment variables:

• PGHOST - Database host
• PGPORT - Database port
• PGDATABASE - Database name
• PGUSER - Username
• PGPASSWORD - Password

🔒 Security & Privacy

• Local Processing: All database operations run locally within VS Code
• No Data Collection: Extension does not collect or transmit user data
• Secure Connections: Supports SSL/TLS encrypted connections
• Environment-Based Config: Sensitive credentials via environment variables

� Documentation

Commands

• Database Explorer: Open - Open the Database Explorer panel

Activity Bar

The extension adds a Database Explorer icon to the VS Code Activity Bar for quick access.

🆘 Troubleshooting

Connection Issues

• Verify database credentials and network connectivity
• Check firewall settings and PostgreSQL configuration
• Ensure PostgreSQL server is running and accepting connections

Performance

• Large result sets are automatically paginated
• Consider adding WHERE clauses to limit query results
• Use table data browser for large tables instead of SELECT *

🤝 Support

For issues, questions, or feature requests, please contact the development team.

📄 License

This extension is proprietary software. All rights reserved. Unauthorized copying, modification, or distribution is prohibited.

Made with ❤️ by Innoiso Technology