qmvir

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