Installation

MountSQLI is a pnpm monorepo, but you install it like any other package. The core package re-exports the tree-shakeable surface; driver packages are added separately.

Install the core

npm

npm install @mountsqli/core

pnpm

pnpm add @mountsqli/core

yarn

yarn add @mountsqli/core

bun

bun add @mountsqli/core

Install a driver

Pick the driver for your database. Each driver self-registers on import.

SQLite (zero-dep)

pnpm add @mountsqli/driver-sqlite

Uses Node’s built-in node:sqlite. Requires Node ≥ 22.5.

Postgres

pnpm add @mountsqli/driver-postgres

Depends on pg.

MySQL

pnpm add @mountsqli/driver-mysql

Depends on mysql2.

Single import

mountsqli is the umbrella package. Importing it pulls in the matching driver package; you usually do not import @mountsqli/driver-sqlite directly.

Install subsystems (optional)

Add only what you use. Each is a separate package:

pnpm add @mountsqli/auth     # passwords, JWT, RBAC, RLS, OAuth
pnpm add @mountsqli/api      # REST / OpenAPI / RPC codegen
pnpm add @mountsqli/storage  # signed URLs, versioning, S3
pnpm add @mountsqli/realtime # hub, presence, live queries
pnpm add @mountsqli/cache    # L1/L2/query cache
pnpm add @mountsqli/ai       # natural language to SQL

Requirements

Tool	Minimum
Node.js	22.5+ (for the node:sqlite driver)
pnpm	11 (recommended)
TypeScript	5.9+
Module system	ESM only

Node version

If you cannot use Node ≥ 22.5, choose the Postgres or MySQL driver. Only the zero-dependency SQLite driver needs node:sqlite.

Verify the install

import { mountsqli, defineTable, int, text } from "@mountsqli/core";

const ping = defineTable("ping", { id: int().pk() });
const db = mountsqli({ driver: "sqlite", url: ":memory:", tables: [ping] });

console.log("MountSQLI is ready");

Common mistakes

• Forgetting to install a driver — you get a MountError("CONFIG", "unknown driver").
• Using CommonJS require — MountSQLI is ESM-only.

Related

• Quick Start — first query end to end.
• Drivers — when to use each driver.