npm package: @sqliteai/sqlite-mcp
Description: SQLite MCP extension for Node.js - Model Context Protocol integration enabling SQLite databases to connect to MCP servers and call their tools.
Author: Gioele Cantoni
Latest version: 0.1.9

# @sqliteai/sqlite-mcp

[![npm version](https://badge.fury.io/js/@sqliteai%2Fsqlite-mcp.svg)](https://badge.fury.io/js/@sqliteai%2Fsqlite-mcp)
[![License](https://img.shields.io/badge/license-MIT%20-blue.svg)](LICENSE)

> SQLite MCP extension packaged for Node.js

**SQLite MCP** is a SQLite extension that integrates the [Model Context Protocol (MCP)](https://modelcontextprotocol.io/), 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

```bash
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](https://github.com/sqliteai/sqlite-mcp/blob/main/README.md).

## Usage

```typescript
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](https://github.com/sqliteai/sqlite-extensions-guide/tree/main/examples/node).

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:**
```typescript
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:**
```typescript
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](https://www.npmjs.com/package/@sqliteai/sqlite-vector)** - Vector search and similarity matching
- **[@sqliteai/sqlite-ai](https://www.npmjs.com/package/@sqliteai/sqlite-ai)** - On-device AI inference and embedding generation
- **[@sqliteai/sqlite-sync](https://www.npmjs.com/package/@sqliteai/sqlite-sync)** - Sync on-device databases with the cloud
- **[@sqliteai/sqlite-js](https://www.npmjs.com/package/@sqliteai/sqlite-js)** - Define SQLite functions in JavaScript

## License

This project is licensed under the [MIT License](LICENSE).

## Contributing

Contributions are welcome! Please see the [main repository](https://github.com/sqliteai/sqlite-mcp) to open an issue.

## Support

- 📖 [Documentation](https://github.com/sqliteai/sqlite-mcp/blob/main/API.md)
- 🐛 [Report Issues](https://github.com/sqliteai/sqlite-mcp/issues)