About Oracle NoSQL Database Visual Studio Code Extension

The Oracle NoSQL Database provides an extension for Microsoft Visual Studio Code which lets you connect to a running instance of Oracle NoSQL Database.

You can use Oracle NoSQL Database Visual Studio (VS) Code extension to:

• View the tables in a well-defined tree structure with Table Explorer.

• View information on columns, indexes, primary key(s), and shard key(s) for a table.

• View column data in a well-formatted JSON Structure.

• Create tables and child tables using form-based schema entry or supply DDL statements.

• Create JSON Collection tables using Advanced DDL Input mode and insert, update rows using Advanced JSON Input mode.

• Drop tables, columns, rows, or indexes.

• Add new columns and indexes using form-based entry or supply DDL statements.

• Add new rows using a form-based entry or use Advanced JSON Input mode.

• Run SELECT SQL queries on a table and view query results in tabular format.

• Run DDL statements to manage regions, namespaces, and roles.

• Run DML statements to update, insert, and delete data from a table.

• Calculate recommended cache and storage settings by using the JeCacheSizingTool.

• Download SELECT query results as a JSON file or as individual JSON files per row.

• Use Prettify SQL to improve readability.