🟢 UltSQL Node.js & TypeScript Package (ultsql)

The official Node.js & TypeScript client for UltSQL - the converged multimodal database engine combining Relational SQL, NoSQL JSON, HNSW Vector RAG, and PL/SQL.

⚡ Installation

npm install ultsql

💻 Install the ultsql CLI (1-Line Auto-Installer)

If you want to run the standalone ultsql server daemon or interactive CLI shell directly from your system terminal:

• Windows (PowerShell):

  iwr -useb https://raw.githubusercontent.com/ompatel3158/ULTSQL/main/install.ps1 | iex

• Linux & macOS (Bash):

  curl -sSL https://raw.githubusercontent.com/ompatel3158/ULTSQL/main/install.sh | bash

After installation, open a new terminal window and run ultsql --help or ultsql server.

🚀 Quickstart Usage

const { UltSQLClient } = require('ultsql');

// Connect to running UltSQL instance (via REST or PgWire)
const db = new UltSQLClient({ host: 'localhost', port: 8080 });

async function main() {
  // 1. High-speed batch ingestion (slotted pages & B+Tree indexed)
  await db.insertBatch('users', [
    { id: 1, name: 'Alice', score: 95.5 },
    { id: 2, name: 'Bob', score: 88.0 },
    { id: 3, name: 'Charlie', score: 92.3 }
  ]);

  // 2. Single record insert
  await db.insert('users', { id: 4, name: 'Diana', score: 99.0 });

  // 3. Query records
  const result = await db.query('users');
  console.log('Users:', result.rows);
}

main();

🔌 PostgreSQL Wire Protocol Compatibility

You can also connect to UltSQL from Node.js using standard pg (node-postgres):

const { Client } = require('pg');

const client = new Client({ host: 'localhost', port: 5432, user: 'admin', database: 'ultsql_db' });
await client.connect();

const res = await client.query('SELECT * FROM users');
console.log('Rows:', res.rows);

✨ Wishlist & Cloud Early Access

Sign up to join the exclusive wishlist for the upcoming UltSQL app and managed cloud database service:
👉 Join the UltSQL Wishlist