Easy Sqlite Mcp

Name: Easy Sqlite Mcp
Author: chenkumi

@chenkumi

About Easy Sqlite Mcp

A Model Context Protocol (MCP) server implemented in Node.js and TypeScript, designed to enable LLMs to interact directly with SQLite databases.

#sqlite

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "easy-sqlite-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "easy-sqlite-mcp"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Databases MCP servers

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412