Introduction
IBM Db2 Developer Extension integrates Db2 database development directly into Visual Studio Code (VS Code), enabling developers to do a wide range of tasks without switching tools.
Designed for developers, this extension delivers a unified, intuitive environment where you can manage database connections, explore schemas, and write and run SQL.
Key features
Database connection management
- Create, edit, and delete secure connection profiles.
- Maintain multiple active database connections simultaneously.
- Store your credentials safely by using VS Code’s SecretStorage API.
Powerful unified SQL editor
- Write and run multiple queries simultaneously.
- Keyword and template suggestions for faster query authoring.
- Real-time syntax checking and highlighting.
- Signature help for correct parameter usage.
Query running and visualization
- Run queries directly within VS Code.
- View results instantly in tabular format.
- Export results to CSV and JSON with one click.
- Query history with timestamps.
Database explorer with tree view
- Browse schemas, tables, views, procedures, and other objects in a clean tree structure.
- Right-click objects for instant access to common operations.