Exasol Database Management in VS Code

Overview

Exasol is a high-performance in-memory analytical database built on a massively parallel processing (MPP) architecture. Key characteristics include:

• In-memory MPP engine: Distributes query execution across all cluster nodes for fast analytical performance
• Columnar storage: Optimized for aggregation and analytical workloads on large datasets
• Standard SQL: Full ANSI SQL support with extensions for analytics, scripting, and user-defined functions
• Schema-based organization: Databases contain schemas, which contain tables, views, and functions
• Automatic compression: Transparent data compression reduces storage and improves I/O performance

Exasol is well suited for data warehousing, business intelligence, large-scale reporting, and real-time analytics.

Connecting

To connect to Exasol in DBCode:

1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
2. Add a New Connection: Click on the “Add Connection” icon.
3. Complete the connection form: Select Exasol as the database type and enter:
   • Host: hostname or IP address of your Exasol instance
   • Port: WebSocket port (default: 8563)
   • Username / Password: Exasol credentials
   • Schema: default schema to use on connection (optional)
   • Encryption: enable TLS for secure connections (recommended for non-localhost deployments)
4. Connect: Click save to connect to your Exasol database.
5. Start exploring: Browse schemas, tables, and views, and run queries.

DBCode connects via the Exasol WebSocket API - no ODBC driver or native client is required.

For detailed connection instructions, refer to the Connect article.

Exasol Features in DBCode

DBCode enhances your Exasol development experience with:

• SQL query editor: Write and execute Exasol SQL with syntax highlighting and multi-statement support
• Schema browsing: Navigate schemas, tables, views, and functions with column types and row counts
• Data editing: Insert, update, and delete rows inline in the data grid
• Schema introspection: Inspect table structure and view definitions
• Transactions: Pin a connection to run statements in a transaction and commit or roll back together
• Session monitoring: View active sessions and running statements from the monitoring panel
• Data export: Export query results in multiple formats

Preview limitations

Exasol support is in Preview. Some advanced Exasol-specific syntax (Lua scripting, Python UDFs, and certain IMPORT/EXPORT statements) may not get full editor IntelliSense yet.

By using Exasol with DBCode, you can develop and run analytical queries and manage your data warehouse directly within Visual Studio Code.

For more information about Exasol, visit exasol.com.