Easy Sqlite Mcp

What is Easy Sqlite Mcp?

Easy Sqlite Mcp is a Model Context Protocol server implemented in Node.js and TypeScript, designed to enable LLMs to interact directly with SQLite databases. It supports two startup modes: manual mode (agent opens/closes databases) and fixed mode (a configured database opens automatically).

How to use Easy Sqlite Mcp?

Run via npx easy-sqlite-mcp. For manual mode, no environment variable; for fixed mode, set the SQLITE_PATH environment variable to a database file path. Configuration examples are provided for Claude Desktop, Codex, and OpenCode clients.

Key features of Easy Sqlite Mcp

• Connection Management: sqlite_open, sqlite_close, sqlite_status (manual mode only for open/close)
• Data Operations: sqlite_query (read-only SELECT), sqlite_execute (INSERT/UPDATE/DELETE/CREATE/DROP)
• Schema Discovery: sqlite_list_tables, sqlite_describe_table (columns, types, row count)

Use cases of Easy Sqlite Mcp

• An LLM assistant querying a local SQLite database to answer user questions
• An agent performing data modifications (insert, update, delete) on a SQLite file
• Automating schema exploration for SQLite databases during troubleshooting or data analysis

FAQ from Easy Sqlite Mcp

What is the difference between manual and fixed mode?

In manual mode the agent must explicitly call sqlite_open and sqlite_close; only one database can be open at a time. In fixed mode the database is opened automatically at startup and connection switching is disabled.

What are the runtime and dependency requirements?

Node.js >= 18, TypeScript, the @modelcontextprotocol/sdk, better-sqlite3 (synchronous SQLite driver), and Zod for parameter validation.

Where does the data reside?

The server operates on SQLite database files on the local filesystem. The agent or user provides the file path either at runtime (manual mode) or via the SQLITE_PATH environment variable (fixed mode).

Is there a limit on concurrent database connections?

Yes, in manual mode only one SQLite database file can be open at a time; opening another file automatically closes the previous connection. Fixed mode allows only the preconfigured database.

What transports or authentication methods are supported?

The README does not mention specific transports or authentication; it relies on the Model Context Protocol standard. The server does not describe any built-in auth mechanism.