qmvir

QMvir — Hybrid AI-Native Database combining OLTP + OLAP + Full-text Search + Vector Search + Smart Cache in one platform.

Install

# npm
npm install qmvir

# pnpm
pnpm add qmvir

# Global CLI (auto-downloads platform binary)
npm install -g qmvir

The package auto-downloads the correct native binary for your platform and installs via pip.

SDK Usage (JavaScript / TypeScript)

import { QMClient } from "qmvir";

const qm = new QMClient("http://localhost:8400", { apiKey: "your-key" });

// CRUD
const users = await qm.find("users", {
  where: { status: "active" },
  orderBy: [{ created_at: "desc" }],
  limit: 10,
});

await qm.insert("users", { name: "Alice", balance: 150.5 });
await qm.update("users", "user-123", { balance: 200.0 });
await qm.delete("users", "user-456");

// Full-text + Vector hybrid search
const results = await qm.search("articles", "machine learning", {
  strategy: "hybrid", // lexical | vector | hybrid | rerank
  limit: 20,
});

// Analytics aggregation
const stats = await qm.aggregate("orders", {
  groupBy: ["region", "category"],
  metrics: [{ total: "SUM(amount)" }, { count: "COUNT(*)" }],
  where: { year: 2026 },
});

CLI Usage

# Start QMvir server
qmvir start
qmvir start --port 55433 --data-dir ./qmvir-data

# Connect via psql (PostgreSQL wire protocol)
psql -h 127.0.0.1 -p 55433 -U admin -d qm

# SQL queries
CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, balance DOUBLE PRECISION);
INSERT INTO users VALUES (1, 'Alice', 150.50);
SELECT * FROM users WHERE balance > 100;

# Microbenchmark
qm-bench

Benchmark Results (v1.0.0, Apple Silicon)

| Benchmark | QMvir | PostgreSQL 16 | DuckDB 1.5 | Winner | | --------- | ----: | ------------: | ---------: | ------ | | Point Lookup | 17,514 | 6,754 | 3,136 | QMvir (2.6x PG) | | Aggregation | 6,031 | 1,376 | 2,348 | QMvir (4.4x PG) | | GROUP BY | 13,227 | 6,190 | 3,731 | QMvir (2.1x PG) | | JOIN 2-table | 15,607 | 12,782 | 2,645 | QMvir (1.2x PG) | | JOIN 3-table | 14,874 | 5,489 | 1,617 | QMvir (2.7x PG) | | Bulk INSERT | 22,661 | 6,977 | 1,947 | QMvir (3.2x PG) | | UPDATE | 14,153 | 7,690 | 2,993 | QMvir (1.8x PG) | | OLAP Full Scan | 9,529 | 203 | 2,667 | QMvir (47x PG) |

8/9 benchmark wins vs PostgreSQL 16 + DuckDB 1.5.

Architecture

         [ Unified Data Gateway ]
                  |
      +-->[ Core DB ]  <── source of truth
      |         |
      |         +--> WAL / CDC / Outbox
      |
      +-->[ Search Engine ]      (BM25, fuzzy, semantic)
      +-->[ Vector Engine ]      (HNSW, IVF-PQ, ANN)
      +-->[ Analytics Store ]    (columnar, materialized views)
      +-->[ Object Storage ]     (archive, lifecycle)

Supported Platforms

| Platform | Architecture | Status | | -------- | ------------ | ------ | | macOS | ARM64 (M1+) | ✅ | | macOS | x86_64 | ✅ | | Linux | x86_64 | ✅ | | Linux | ARM64 | ✅ | | Windows | x86_64 | ✅ |

Alternative Install Methods

# pip
pip install qmvir

# Shell script (auto-detect platform)
curl -fsSL https://raw.githubusercontent.com/virgori/qmvir-releases/main/install.sh | bash

License

MIT