SQLite MCP Server

Name: SQLite MCP Server
Author: jacksteamdev

@jacksteamdev

リポジトリ

SQLite MCP Server について

概要はまだありません

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

jacksteamdev

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは 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

FAQ from SQLite MCP Server

What runtime does SQLite MCP Server require?

It requires Bun 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.