pip install -r requirements.txt

from mcpsqlite import SQLiteServer

server = SQLiteServer(db_path="data.db")
server.run()

{
  "name": "query",
  "arguments": {
    "sql": "SELECT * FROM users WHERE age > ?",
    "params": [18]
  }
}

{
  "name": "execute",
  "arguments": {
    "sql": "INSERT INTO users (name, age) VALUES (?, ?)",
    "params": ["Alice", 25]
  }
}

{
  "name": "schema",
  "arguments": {
    "table": "users"
  }
}

{
  "name": "tables",
  "arguments": {}
}

server = SQLiteServer(
    db_path="data.db",
    read_only=False,
    max_rows=1000
)

python -m mcpsqlite --db data.db --port 8080

{
  "mcpServers": {
    "sqlite": {
      "command": "python",
      "args": ["-m", "mcpsqlite", "--db", "data.db"]
    }
  }
}