Apache Ignite Database Management in VS Code

Overview

Apache Ignite is a distributed database for high-performance computing with in-memory speed. DBCode connects to Ignite over its JDBC thin client (binary client protocol, default port 10800) and works against the SQL engine exposed there.

One connection type covers both major lines - pick the one matching your cluster:

• Ignite 2.x
• Ignite 3.x

The DBCode driver requires a Java runtime (JDK 11 or later for Ignite 3.x, JDK 9 or later for 2.x) on your machine.

Connecting

To connect to Apache Ignite in DBCode:

1. Open the DBCode extension and select Add Connection.
2. Select Apache Ignite as the database type.
3. Choose the Ignite Version that matches your cluster (2.x or 3.x).
4. Enter the host and thin-client port. The default port is 10800.
5. Enter a username and password if your cluster has authentication enabled. Ignite runs without authentication by default.
6. Configure optional TLS or an SSH tunnel.
7. Save the connection and open it from the DB Explorer.

User tables live in the PUBLIC schema unless you place them in a named schema. System views are available under the SYS schema on Ignite 2.x and the SYSTEM schema on Ignite 3.x.

TLS

Enable SSL when your cluster’s thin-client endpoint serves TLS. DBCode connects with TLS required so the session is encrypted end to end.

Supported features

Feature	Support
Run Ignite SQL	Yes
Visual query builder	Yes
Browse schemas and tables	Yes
Inspect columns, primary keys, and indexes	Yes
Browse the system views	Yes, read-only (SYS on 2.x, SYSTEM on 3.x)
Insert, update, and delete rows	Yes
Edit grid cells	Yes
Execution plans	Yes, via EXPLAIN
Create and drop tables	Yes
UUID and binary values	Yes
Transactions	Not supported by the Ignite 2.x thin client

Ignite folds unquoted identifiers to uppercase, and every table requires a primary key. The PUBLIC schema holds your tables (with their columns, primary key, and any indexes you create), and the system schema (SYS on 2.x, SYSTEM on 3.x) exposes Ignite’s system views (nodes, caches, running queries, and more) as read-only objects. DATE, TIME, and TIMESTAMP values round-trip as stored; DBCode’s date and time formatting settings control how they are displayed.

SQL examples

CREATE TABLE PUBLIC.accounts (
  id INT PRIMARY KEY,
  name VARCHAR,
  balance DECIMAL(20, 2),
  created TIMESTAMP
);

INSERT INTO PUBLIC.accounts (id, name, balance, created)
VALUES (1, 'Ada', 1000.00, '2026-08-29 10:30:00');

SELECT * FROM PUBLIC.accounts LIMIT 100 OFFSET 0;

For cluster setup and SQL reference information, see the Apache Ignite documentation.