mcpserver.so LogoMCPFly
Submit
SQLite MCP Server logo

SQLite MCP Server

by dubydu

Data/DatabasesSQLiteDatabase InteractionAutomation

A lightweight Model Context Protocol (MCP) server that enables Large Language Models (LLMs) to autonomously interact with SQLite databases.

View on GitHub

Last updated: N/A

SQLite MCP Server

A lightweight Model Context Protocol (MCP) server that enables Large Language Models (LLMs) to autonomously interact with SQLite databases.

Showcases

<video src="https://github.com/user-attachments/assets/b4c43fc1-02de-435a-9a9b-1c193ce6baec" autoplay loop muted></video>

Installation

  1. Clone the repository:
git clone https://github.com/dubydu/sqlite-mcp.git
cd sqlite-mcp
  1. Set up a virtual environment (recommended):
python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate
  1. Install dependencies:
pip install -r requirements.txt

Usage

Basic Start

python src/entry.py --db-path /path/to/your/database.db

Command Line Options

  • --db-path: Path to SQLite database file (default: "./db/database.db")

Available MCP Tools

For the full list of tools, see the MCP_TOOLS.md

MCP CLients Configuration

  • 5ire
{
  "name": "SQLite",
  "key": "sqlite",
  "command": "/absolute/path/to/sqlite-mcp/.venv/bin/python",
  "args": [
    "/absolute/path/to/sqlite-mcp/src/entry.py",
    "--db-path",
    "/path/to/database.db"
  ]
}
  • Claude Desktop
{
  "mcpServers": {
    "sqlite-mcp": {
      "command": "/absolute/path/to/sqlite-mcp/.venv/bin/python",
      "args": [
        "/absolute/path/to/sqlite-mcp/src/entry.py",
         "--db-path",
         "/path/to/database.db"
      ]
    }
  }
}

Requirements