SQLite MCP Server

@isaacgounton

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

isaacgounton

关于 SQLite MCP Server

暂无概览

#sqlite #database #mcp-server

SQLite MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "sqlite-mcp-server": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "sqlite-mcp-server",
        "."
      ]
    }
  }
}

SQLite MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is SQLite MCP Server?

SQLite MCP Server is a Model Context Protocol (MCP) server that provides SQLite database operations through a standardized interface. It supports in-memory and file-based storage, offering tools for SQL queries, table management, and business insights memo tracking.

How to use SQLite MCP Server?

Install dependencies and run locally with npm install and npm start, or deploy using Docker (docker build -t sqlite-mcp-server . && docker run -d ...) or Nixpacks. No environment variables are required by default; modify the database path in source code for file-based storage. Connect remote clients (e.g., n8n) via SSE at http://localhost:3000/sse with messages endpoint at http://localhost:3000/messages.

Key features of SQLite MCP Server

In-memory SQLite database (configurable for file-based storage)
SQL operations: SELECT, INSERT, UPDATE, DELETE
Table management: CREATE, LIST, DESCRIBE
Business insights memo tracking with append_insight tool
Docker support for easy deployment

Use cases of SQLite MCP Server

Quickly prototype or test SQL queries in an isolated environment
Manage database schemas (create, list, describe tables) via MCP tools
Append and track business insights as structured memos
Integrate a lightweight local database into AI-agent workflows

常见问题

What operations does SQLite MCP Server support?

It supports SELECT queries (`read_query`), data modifications (`write_query`), table creation (`create_table`), listing tables (`list_tables`), viewing schema (`describe_table`), and appending business insights (`append_insight`).

Is the database persistent?

By default the database runs in-memory, but you can modify the database path in `src/index.ts` to use file-based storage for persistence.

What runtime or dependencies are required?

Node.js and npm are needed for local development. Docker is supported for containerized deployment. No external services or environment variables are required by default.

How do I connect a remote client (e.g., n8n) to this server?

Connect via SSE: use the SSE URL `http://localhost:3000/sse` and the messages post endpoint `http://localhost:3000/messages`. No additional headers are required.

Does SQLite MCP Server require authentication or authorization?

The README does not mention any authentication or authorization mechanisms. No headers or credentials are needed for the SSE connection.

数据库分类下的更多 MCP 服务器

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

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