Sqlite Tool

🚀 SQLite MCP Tool (Delete Function Only)

This project implements a Python-based MCP tool that only provides the ability to delete data from SQLite tables (delete_rows). Callers can specify the database path, table name, and simple equality filtering conditions to perform the DELETE operation.

🚀 Quick Start

The SQLite MCP tool allows you to delete data from SQLite tables. Here's how to get started:

Prerequisites

• Python installed on your system.
• It is recommended to use a virtual environment.

Steps

1. Install dependencies (preferably in a virtual environment):

cd agent-cli
pip install -r requirements.txt

2. Start the MCP server (this is a demonstration; the actual integration depends on your Agent/host):

cd agent-cli
python -m sqlite_mcp.server

3. Register the service in an MCP-supported Agent and call the delete_rows method.

Example of cursor registration:

{
  "mcpServers": {
    "user-sqlite-delete-tool": {
      "command": "/Users/XXX/.mcp/sqlite-tool/.venv/bin/python",
      "args": [
        "-m",
        "sqlite_mcp.server"
      ],
      "env": {
        "PYTHONPATH": "/Users/XXX/.mcp/sqlite-tool/agent-cli"
      }
    }
  }
}

Usage Example

@user-sqlite-delete-tool, please delete the records where the table name is BBB and the field id is CCC in the database at /Users/XXX/XXX.db.

✨ Features

• delete_rows: Delete records that meet the conditions from the specified SQLite database table.
  • Required parameters: db_path (database path), table (table name)
  • Optional parameters: filters (dictionary of simple equality conditions), allow_full_table (whether to allow full table deletion)

📦 Directory Structure

• agent-cli/
  • README.md: Project description
  • requirements.txt: Python dependencies
  • sqlite_mcp/: Main source code directory
    • __init__.py
    • server.py: Implementation and entry point of the MCP tool service
    • delete_tool.py: Core deletion logic
  • docs/
    • delete_rows_spec.md: Requirements and interface description of the delete_rows method
  • tests/
    • test_delete_rows.py: Simple unit tests, which can be run via python tests/test_delete_rows.py