SQLite MCP Server

Name: SQLite MCP Server
Author: javsanmar5

@javsanmar5

SQLite MCP Server について

Implementation of an MCP (Model Context Protocol) Server for SQLite. It provides an AI model with context and the ability to execute SQL queries.

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

javsanmar5

設定

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

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

ツール

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

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is SQLite MCP Server?

A Model Context Protocol (MCP) server implemented in TypeScript that provides an interactive interface for executing SQL queries, managing database schemas, and synthesizing business insights from an SQLite database. It is designed for AI clients that support MCP, such as Claude Desktop.

How to use SQLite MCP Server?

Clone the repository, build the Docker image (docker build -t mcp/sqlite .), then add the provided JSON configuration to your AI client’s configuration file, specifying --db-path (e.g., test_db.sqlite3). After restarting the client, the tools list_tables and read_query become available.

Key features of SQLite MCP Server

list_tables – lists all tables in the SQLite database
read_query – executes SELECT queries on the database
Runs as a Docker container for easy deployment
Integrates with MCP‑compatible AI clients like Claude Desktop

Use cases of SQLite MCP Server

Querying a SQLite database directly from an AI assistant
Listing all tables to understand database structure
Running SELECT queries with conditions (e.g., SELECT * FROM users WHERE age > 18)
Synthesizing business insights from database content via AI

FAQ from SQLite MCP Server

What is MCP?

Model Context Protocol (MCP) is a standardized way for AI models to interact with external tools and services. It allows AI assistants to perform actions like running database queries through a defined protocol interface.

How do I set up SQLite MCP Server with Claude Desktop?

On Windows, press Win+R, type %appdata%\Claude, create or edit claude_desktop_config.json with the Docker configuration shown in the README, save, and restart Claude Desktop.

Where is the database file stored?

The database is inside the Docker container at the path specified by --db-path. The volume mount -v mcp-test:/mcp persists data across container restarts.