Database Node Catalog

Generated category

Database Node Catalog

Generated from 36 catalog nodes in Data/Database.

Data/Database/DeleteData/Database/GraphData/Database/Graph/MetaData/Database/Graph/QueryData/Database/Graph/WriteData/Database/InsertData/Database/MetaData/Database/OptimizationData/Database/SchemaData/Database/Search

Nodes in this category

Showing 36 of 36 generated node docs.

Open Database

Data/Database

Open a local database

4 in2 outSecurity 10/10

Delete

Data/Database/Delete

Delete rows from a database table and return the removed rows

3 in2 outSecurity 10/10

Purge

Data/Database/Delete

Purge Database

2 in1 outSecurity 10/10

Create Graph Overlay

Data/Database/Graph

Creates a new graph overlay definition over existing database tables

3 in4 outSecurity 10/10

Drop Graph Overlay

Data/Database/Graph

Deletes a graph overlay definition (does not drop underlying tables)

3 in3 outSecurity 10/10

Open Graph Overlay

Data/Database/Graph

Opens an existing graph overlay and returns a connection for querying

3 in4 outSecurity 10/10

Graph Schema

Data/Database/Graph/Meta

Retrieves the schema (labels and properties) of a graph overlay

2 in2 outSecurity 10/10

List Graph Overlays

Data/Database/Graph/Meta

Lists all graph overlay definitions in the database

2 in3 outSecurity 10/10

Cypher Query

Data/Database/Graph/Query

Executes a Cypher query against the graph overlay

5 in4 outSecurity 10/10

Graph Neighbors

Data/Database/Graph/Query

Finds neighbor nodes by traversing edges from a seed node

7 in5 outSecurity 10/10

Graph Subgraph

Data/Database/Graph/Query

Extracts a subgraph around seed nodes for visualization

6 in5 outSecurity 10/10

SQL Query (Graph)

Data/Database/Graph/Query

Executes a SQL query against graph overlay tables via DataFusion

4 in4 outSecurity 10/10

Upsert Graph Edge

Data/Database/Graph/Write

Inserts or updates an edge in the graph overlay's underlying edge table

4 in3 outSecurity 10/10

Upsert Graph Node

Data/Database/Graph/Write

Inserts or updates a node in the graph overlay's underlying table

4 in3 outSecurity 10/10

Batch Insert

Data/Database/Insert

Inserts multiple items at once. Faster than Upsert but might produce duplicates.

3 in3 outSecurity 10/10

Batch Insert (CSV)

Data/Database/Insert

Inserts multiple items at once. Faster than Upsert but might produce duplicates.

5 in3 outSecurity 10/10

Batch Insert (TDMS)

Data/Database/Insert

Reads a LabVIEW TDMS file and batch-inserts its channel data as rows into a vector database.

4 in1 outSecurity 10/10

Batch Upsert

Data/Database/Insert

Inserts if the Item does not exist, Updates if it does

4 in3 outSecurity 10/10

Insert

Data/Database/Insert

Faster than Upsert, but might write duplicate items.

3 in3 outSecurity 10/10

Upsert

Data/Database/Insert

Inserts if the Item does not exist, Updates if it does

4 in3 outSecurity 10/10

Count

Data/Database/Meta

Count Items

3 in2 outSecurity 10/10

Get Schema

Data/Database/Meta

Get Local Database Schema

2 in2 outSecurity 10/10

List

Data/Database/Meta

List Content

4 in2 outSecurity 10/10

List Indices

Data/Database/Meta

Lists all indices on a database table

2 in2 outSecurity 10/10

List Tables

Data/Database/Meta

Lists all available table names in the database location

2 in2 outSecurity 10/10

Build Index

Data/Database/Optimization

Build Index

4 in1 outSecurity 10/10

Drop Index

Data/Database/Optimization

Remove an index from a database table

3 in1 outSecurity 10/10

Flush Database

Data/Database/Optimization

Flush any buffered writes to storage immediately

2 in3 outSecurity 10/10

Optimize and Update

Data/Database/Optimization

Optimize and Update the Database

3 in1 outSecurity 10/10

Add Column

Data/Database/Schema

Adds a column using a typed SQL expression (e.g. 0, '', CAST(NULL AS STRING)). LanceDB rejects bare NULL — wrap it in CAST(... AS <type>). Supported types: int, bigint, float, double, string, binary, boolean, date, timestamp.

4 in2 outSecurity 10/10