SQLite MCP Server

@madhavarora1988

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

madhavarora1988

SQLite MCP Server について

simple poc to demostrate an mcp server on top of sqlite db

SQLite MCP Server の設定

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

{
  "mcpServers": {
    "mcp_sqlite_poc": {
      "command": "python",
      "args": [
        "server.py"
      ]
    }
  }
}

SQLite MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

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

概要

What is SQLite MCP Server?

A Model Context Protocol (MCP) server implementation that enables AI models to interact with SQLite databases through standardized tools. It provides query execution, schema discovery, row counting, and sample data insertion.

How to use SQLite MCP Server?

Install dependencies with pip install -r requirements.txt, configure the .env file (set DB_PATH, MCP_PORT, READ_ONLY), then start the server with python server.py on port 8080. Add it to Claude Desktop via the mcpServers configuration.

Key features of SQLite MCP Server

Execute SQL queries with validation and safety checks
Discover table schemas and list all tables
Count rows in specified tables
Insert sample data for demonstration (write mode)
Read-only mode for production safety
Collect user feedback stored in the database

Use cases of SQLite MCP Server

AI assistants querying a product database for inventory information
Generating reports from customer and order data
Prototyping applications with a sample database schema
Collecting and storing user feedback from AI interactions
Safely exploring database structures without risking data modification

よくある質問

What is read-only mode and how do I enable it?

Set `READ_ONLY=true` in the `.env` file. Write operations like `insert_sample_data` and `add_feedback` are disabled in read-only mode.

What dependencies are required?

Python 3.8+ and the packages listed in `requirements.txt`. Install them with `pip install -r requirements.txt`.

Where does the database data live?

Data is stored in a single SQLite file specified by the `DB_PATH` environment variable (default: `sample.db`). The server creates a sample database with tables for products, customers, orders, and feedback if none exists.

What tools does the server provide?

The server offers six tools: `execute_query`, `list_tables`, `describe_table`, `count_rows`, `insert_sample_data`, and `add_feedback`. The last two are disabled in read-only mode.

How do I connect the server to Claude Desktop?

Add the server to your Claude Desktop configuration file with the command `<Path to UV>`, arguments `["--directory", "<Absolute Path to Project Workspace>", "run", "server.py"]`, and the server name `sqlite`.