Redshift Query - VS Code Extension
Connect and query Amazon Redshift clusters directly from VS Code with multiple connection management and real-time status indicators.
✨ Key Features
- Multiple Connections: Manage multiple Redshift clusters with visual status indicators
- Smart Query Execution: Execute entire files or selected SQL with keyboard shortcuts
- Real-time Status: Green/red indicators show connection health at a glance
- Database Explorer: Browse schemas, tables, and view table descriptions
- SQL File Support: Full syntax highlighting and execution for
.sql files
- Export Results: Copy or export query results to CSV
🚀 Getting Started
- Install the extension from VS Code Marketplace
- Open Redshift panel from the Activity Bar (database icon)
- Click the + button to create your first connection
- Enter connection details and test the connection
- Start querying by opening any
.sql file
💡 How to Use
Create Connection
- Click
+ in Redshift Connections panel
- Enter host, port, database, username, password
- Test connection to verify credentials
Execute Queries
- Ctrl+Shift+E (Cmd+Shift+E on Mac): Execute file or selection
- Ctrl+E (Cmd+E on Mac): Execute selected text only
- Run button: Available in
.sql file editor toolbar
Connection Management
- Green icon: Connection is healthy
- Red icon: Connection failed or disconnected
- Loading icon: Testing connection in progress
- Active label: Currently selected connection
🔧 Requirements
- VS Code 1.74.0 or higher
- Amazon Redshift cluster access
- Network connectivity to your Redshift cluster
📊 Query Results
View results in formatted tables with:
- Column headers and data types
- Row count and execution time
- Export to CSV functionality
- Error messages with detailed information
🛠️ Troubleshooting
Connection Issues:
- Verify host, port, and credentials
- Check network connectivity and security groups
- Ensure Redshift cluster is publicly accessible (if connecting from outside VPC)
Query Execution:
- Make sure a connection is active (green status)
- Check SQL syntax for errors
- Verify permissions for the database user
📝 Supported SQL Features
- SELECT, INSERT, UPDATE, DELETE statements
- DDL operations (CREATE, ALTER, DROP)
- Redshift-specific functions and syntax
- Multi-statement execution
- Comments and formatting preservation
🔒 Security
- Passwords are stored securely in VS Code's secret storage
- Connections use SSL by default
- No credentials are logged or transmitted to external services
📄 License
MIT License - see LICENSE file for details.
🐛 Support
| |
