A Visual Studio Code extension that adds Netezza database support to SQLTools.
Features
- Connect to Netezza databases
- Execute SQL queries
- Browse database schemas, tables, views, and columns
- Autocomplete for database objects
- View table data
- Format SQL queries
- Multi-statement support: Write multiple queries in one file, separated by semicolons
- Smart query parsing: Execute individual queries by placing cursor on them
Installation
- Install SQLTools extension
- Install this Netezza driver extension
- Reload VS Code
Requirements
- SQLTools extension installed
- Access to a Netezza database
- Netezza database server running and accessible
Configuration
Create a new SQLTools connection with the following parameters:
- Connection Method: Server and Port
- Server Address: Your Netezza server hostname or IP address
- Port: Default is 5480
- Database: The database name to connect to
- Username: Your Netezza username
- Password: Your Netezza password
- Secure Connection: Enable SSL/TLS connection (optional)
Example Connection Settings
{
"name": "Netezza Production",
"driver": "Netezza",
"server": "netezza.example.com",
"port": 5480,
"database": "mydb",
"username": "admin",
"password": "password",
"netezzaOptions": {
"secureConnection": false,
"queryTimeout": 30,
"pool": {
"min": 1,
"max": 5,
"idleTimeoutMillis": 30000
}
}
}
Connection Pooling
This driver uses connection pooling for improved performance and resource management. Pool options:
- min: Minimum number of connections to maintain (default: 1)
- max: Maximum number of connections (default: 5)
- idleTimeoutMillis: How long a connection can be idle before closing in milliseconds (default: 30000)
Benefits:
- Faster query execution through connection reuse
- Better handling of concurrent queries from multiple editor tabs
- Automatic connection lifecycle management
- Reduced server load and improved resource efficiency
Note: Pool settings are optional. If not specified, the driver will use sensible defaults.
Usage
- Open the SQLTools sidebar in VS Code
- Click "Add New Connection"
- Select "Netezza" as the driver
- Fill in your connection details
- Click "Test Connection" to verify
- Click "Save Connection"
- Connect to your database and start querying!
Supported Features
- ✅ Connection management
- ✅ Connection pooling with configurable settings
- ✅ Query execution
- ✅ Multi-statement files (semicolon-separated queries)
- ✅ Smart query identification ("Run on active query")
- ✅ Database browsing
- ✅ Schema browsing
- ✅ Table browsing
- ✅ View browsing
- ✅ Column browsing
- ✅ Table data preview
- ✅ Query history
- ✅ Generate CREATE script (right-click on table/view)
- ✅ SSL/TLS connections
- ✅ Configurable query timeout
Known Issues
Please report issues on the GitHub repository.
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
MIT
Credits
This driver uses node-netezza to connect to Netezza databases.
Built for use with SQLTools.
