SQLite MCP Server

@jacksteamdev

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

jacksteamdev

关于 SQLite MCP Server

暂无概览

SQLite MCP Server 配置

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

{
  "mcpServers": {
    "mcp-sqlite-bun-server": {
      "command": "bun",
      "args": [
        "run",
        "setup"
      ]
    }
  }
}

SQLite MCP Server 工具

工具列表暂未提供

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

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

概览

What is SQLite MCP Server?

A Model Context Protocol (MCP) server that provides database interaction and business intelligence capabilities through SQLite. It enables running SQL queries, analyzing business data, and automatically generating business insight memos.

How to use SQLite MCP Server?

Install Bun, clone the repository, run bun install to install dependencies, then bun run setup to automatically configure the server in Claude Desktop (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json). The server exposes tools, a dynamic resource, and a demo prompt for database operations.

Key features of SQLite MCP Server

Execute SELECT, INSERT, UPDATE, DELETE queries
Create tables with CREATE TABLE statements
List and describe database tables
Append business insights to a dynamic memo
Auto-updating insights memo resource (memo://insights)
Demonstration prompt for guided database analysis

Use cases of SQLite MCP Server

Run ad‑hoc SQL queries against a local SQLite database
Analyze business data and store discovered insights
Automatically generate and maintain a business insights memo
Walk through database analysis with a guided demo prompt

常见问题

What runtime does SQLite MCP Server require?

It requires [Bun](https://bun.sh) to be installed on your system.

Where is the SQLite database file stored?

The database file is created as `data.sqlite` in the project root directory; it is created automatically if it doesn’t exist.

How do I configure SQLite MCP Server for Claude Desktop?

Run `bun run setup` to automatically add the server configuration to your Claude Desktop config file (macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`).

What logs does the server keep?

The server writes detailed logs to `server.log` in the project root directory, including timestamps, log levels (DEBUG, INFO, WARN, ERROR, FATAL), and structured metadata.