@sqliteai/sqlite-mcp

@sqliteai/sqlite-mcp

SQLite MCP extension packaged for Node.js

SQLite MCP is a SQLite extension that integrates the Model Context Protocol (MCP), enabling SQLite databases to connect to MCP servers and call their tools.

Features

• ✅ Cross-platform - Works on macOS, Linux (glibc/musl), and Windows
• ✅ Zero configuration - Automatically detects and loads the correct binary for your platform
• ✅ TypeScript native - Full type definitions included
• ✅ Modern ESM + CJS - Works with both ES modules and CommonJS
• ✅ Small footprint - Only downloads binaries for your platform
• ✅ Offline-ready - No external services required

Installation

npm install @sqliteai/sqlite-mcp

The package automatically downloads the correct native extension for your platform during installation.

Supported Platforms

Platform	Architecture	Package
macOS	ARM64 (Apple Silicon)	@sqliteai/sqlite-mcp-darwin-arm64
macOS	x86_64 (Intel)	@sqliteai/sqlite-mcp-darwin-x86_64
Linux	ARM64 (glibc)	@sqliteai/sqlite-mcp-linux-arm64
Linux	ARM64 (musl/Alpine)	@sqliteai/sqlite-mcp-linux-arm64-musl
Linux	x86_64 (glibc)	@sqliteai/sqlite-mcp-linux-x86_64
Linux	x86_64 (musl/Alpine)	@sqliteai/sqlite-mcp-linux-x86_64-musl
Windows	x86_64	@sqliteai/sqlite-mcp-win32-x86_64

sqlite-mcp API

For detailed information on how to use the mcp extension features, see the main documentation.

Usage

import { getExtensionPath } from '@sqliteai/sqlite-mcp';
import Database from 'better-sqlite3';

const db = new Database(':memory:');
db.loadExtension(getExtensionPath());

// Ready to use
const version = db.prepare('SELECT mcp_version()').pluck().get();
console.log('MCP extension version:', version);

Examples

For complete, runnable examples, see the sqlite-extensions-guide.

These examples are generic and work with all SQLite extensions: sqlite-mcp, sqlite-vector, sqlite-sync, sqlite-js, and sqlite-ai.

API Reference

getExtensionPath(): string

Returns the absolute path to the SQLite MCP extension binary for the current platform.

Returns: string - Absolute path to the extension file (.so, .dylib, or .dll)

Throws: ExtensionNotFoundError - If the extension binary cannot be found for the current platform

Example:

import { getExtensionPath } from '@sqliteai/sqlite-mcp';

const path = getExtensionPath();
// => '/path/to/node_modules/@sqliteai/sqlite-mcp-darwin-arm64/mcp.dylib'

getExtensionInfo(): ExtensionInfo

Returns detailed information about the extension for the current platform.

Returns: ExtensionInfo object with the following properties:

• platform: Platform - Current platform identifier (e.g., 'darwin-arm64')
• packageName: string - Name of the platform-specific npm package
• binaryName: string - Filename of the binary (e.g., 'mcp.dylib')
• path: string - Full path to the extension binary

Throws: ExtensionNotFoundError - If the extension binary cannot be found

Example:

import { getExtensionInfo } from '@sqliteai/sqlite-mcp';

const info = getExtensionInfo();
console.log(`Running on ${info.platform}`);
console.log(`Extension path: ${info.path}`);

getCurrentPlatform(): Platform

Returns the current platform identifier.

Returns: Platform - One of:

• 'darwin-arm64' - macOS ARM64
• 'darwin-x86_64' - macOS x86_64
• 'linux-arm64' - Linux ARM64 (glibc)
• 'linux-arm64-musl' - Linux ARM64 (musl)
• 'linux-x86_64' - Linux x86_64 (glibc)
• 'linux-x86_64-musl' - Linux x86_64 (musl)
• 'win32-x86_64' - Windows x86_64

Throws: Error - If the platform is unsupported

isMusl(): boolean

Detects if the system uses musl libc (Alpine Linux, etc.).

Returns: boolean - true if musl is detected, false otherwise

class ExtensionNotFoundError extends Error

Error thrown when the SQLite MCP extension cannot be found for the current platform.

Related Projects

• @sqliteai/sqlite-vector - Vector search and similarity matching
• @sqliteai/sqlite-ai - On-device AI inference and embedding generation
• @sqliteai/sqlite-sync - Sync on-device databases with the cloud
• @sqliteai/sqlite-js - Define SQLite functions in JavaScript

License

This project is licensed under the MIT License.

Contributing

Contributions are welcome! Please see the main repository to open an issue.

Support

• 📖 Documentation
• 🐛 Report Issues