広告掲載
MCP.so
ログイン

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

よくある質問

1

What runtime does SQLite MCP Server require?

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

2

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.

3

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`).

4

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.

5

What tools are provided?

Six core tools: `read-query`, `write-query`, `create-table`, `list-tables`, `describe-table`, and `append-insight`.

コメント

「データベース」の他のコンテンツ

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

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.

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

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
広告掲載