広告掲載
MCP.so
ログイン

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

よくある質問

1

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

2

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.

3

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.

4

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.

5

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.

コメント

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

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Elasticsearch MCP Server

elastic

685

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

広告掲載