Registry / database / incubyte-sqlite-mcp-server

incubyte-sqlite-mcp-server

library1.0.5jsnpmunverified

A Model Context Protocol (MCP) server that enables Claude Desktop to safely execute SELECT queries on SQLite databases. Current stable version is 1.0.5. It is built with TypeScript, follows Test-Driven Development, and supports both file-based and in-memory databases. Unlike other MCP servers, this one is strictly read-only by design, preventing INSERT/UPDATE/DELETE operations for security. It integrates seamlessly with Claude Desktop via the MCP protocol.

database ai-ml

npm install incubyte-sqlite-mcp-server

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · INCUBYTE-SQLITE-MC

incubyte-sqlite-mcp-server

databasejavascriptv1.0.5

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

SqliteMcpServer (default export)

✓ import SqliteMcpServer from 'incubyte-sqlite-mcp-server'

✗ import { SqliteMcpServer } from 'incubyte-sqlite-mcp-server'

The package exports a default class. Named import will cause a runtime error.

types (type imports)

✓ import type { DatabaseConfig, QueryResult } from 'incubyte-sqlite-mcp-server'

TypeScript types are bundled with the package. Use type-only imports for type safety.

startServer function

✓ import startServer from 'incubyte-sqlite-mcp-server'

✗ const startServer = require('incubyte-sqlite-mcp-server')

Package is ESM-only; require() will fail in CommonJS environments.

Shows how to import and start the SQLite MCP server with default configuration, allowing Claude Desktop to execute SELECT queries.

import SqliteMcpServer from 'incubyte-sqlite-mcp-server'; const server = new SqliteMcpServer(); // Start server with default config (binds to stdin/stdout) server.start(); // Alternatively, connect to a specific database file // const server = new SqliteMcpServer({ dbPath: './data.db' }); // server.start();

Debug

Known issues

gotchaOnly SELECT queries are supported. INSERT/UPDATE/DELETE operations are explicitly blocked for safety.

fix

Use other tools or direct SQLite access for write operations.

affects: >=1.0.0

breakingESM-only package; requires Node.js 18+ and cannot be required() in CommonJS.

fix

Use import syntax or .mjs extension. If using CommonJS, use dynamic import().

affects: >=1.0.0

gotchaThe server runs on stdin/stdout by default, not an HTTP port. Do not expect a network endpoint.

fix

Configure Claude Desktop MCP settings to use npx or node command as described in the README.

affects: >=1.0.0

deprecatedUse of environment variables for configuration (e.g., DB_PATH) is deprecated in favor of constructor options.

fix

Pass dbPath as a parameter to the SqliteMcpServer constructor instead.

affects: >=1.0.0

Errors

Common errors & fixes

ERR_REQUIRE_ESM: require() of ES Module not supported

Trying to require an ESM-only package from a CommonJS context.

fix

Change your file to .mjs or use dynamic import() with await.

TypeError: SqliteMcpServer is not a constructor

Named import instead of default import.

fix

Use 'import SqliteMcpServer from ...' without curly braces.

Error: SQLITE_ERROR: attempt to write a readonly database

Trying to execute INSERT/UPDATE/DELETE queries which are blocked.

fix

Only use SELECT queries. For write operations, use other database tools.

Upgrade

Version history

1.0.5latest on npm

Audit

Dependencies

better-sqlite3requiredUnderlying SQLite engine used for query execution

@modelcontextprotocol/sdkrequiredMCP SDK used for protocol communication

Agent activity

14 hits · last 30 days

node

Resources

githubhttps://github.com/incubyte/sqlite-mcp ↗

packageincubyte-sqlite-mcp-server ↗

homepagehttps://github.com/incubyte/sqlite-mcp#readme ↗