# MCP Setup Guide for Legal Text Analysis Project*Successful Configuration with Claude Desktop & SQLite Integration*
## Project Structure```plaintextD:\\Projects\\LegalTextAnalysis\\├── .venv\\                  # Python virtual environment├── data\\│   └── legal_text.db      # SQLite database├── inspector.bat          # MCP Inspector script├── start-mcp.bat         # MCP Server script└── claude_desktop_config.json  # Claude Desktop configuration

1. Configuration Files

1.1 VS Code Settings (settings.json)

{    "python.defaultInterpreterPath": "${workspaceFolder}\\\\.venv\\\\Scripts\\\\python.exe",    "terminal.integrated.env.windows": {        "PATH": "${workspaceFolder}\\\\.venv\\\\Scripts;C:\\\\Program Files\\\\nodejs;C:\\\\Users\\\\alexa\\\\AppData\\\\Roaming\\\\npm;C:\\\\Windows\\\\system32;C:\\\\Windows"    },    "terminal.integrated.defaultProfile.windows": "Command Prompt"}

1.2 MCP Server Script (start-mcp.bat)

@echo off
setlocal enabledelayedexpansion

echo [%time%] Starting MCP Server...

REM Set environment
set "VENV_PATH=D:\\Projects\\LegalTextAnalysis\\.venv"
set "PATH=%VENV_PATH%\\Scripts;%SystemRoot%\\system32;%SystemRoot%"
set "PYTHONIOENCODING=utf-8"
set "UV_FORCE_STDIO=1"
set "DEBUG=mcp:*,sqlite:*"
set "MCP_SQLITE_EXPOSE_TABLES=true"

REM Change to project directory
cd /d D:\\Projects\\LegalTextAnalysis
call .venv\\Scripts\\activate.bat

REM Start MCP Server in background
start /B cmd /c "mcp-server-sqlite --db-path D:/Projects/LegalTextAnalysis/data/legal_text.db"

echo [%time%] MCP Server started in background
echo [%time%] You can now start the inspector
timeout /t 2 /nobreak > NUL

exit

1.3 MCP Inspector Script (inspector.bat)

@echo off
echo Starting MCP Inspector...

REM Set environment
set "PATH=C:\\Program Files\\nodejs;C:\\Users\\alexa\\AppData\\Roaming\\npm;C:\\Windows\\system32;C:\\Windows"
set "PYTHONIOENCODING=utf-8"
set "UV_FORCE_STDIO=1"
set "DEBUG=mcp:*,sqlite:*"
set "MCP_SQLITE_EXPOSE_TABLES=true"

REM Set working directory
cd /d D:\\Projects\\LegalTextAnalysis

REM Start inspector
echo Starting inspector service...
start /B /WAIT npx @modelcontextprotocol/inspector

cmd /k

1.4 Claude Desktop Config (claude_desktop_config.json)

{  "mcpServers": {    "sqlite": {      "command": "mcp-server-sqlite",      "args": [        "--db-path",        "D:/Projects/LegalTextAnalysis/data/legal_text.db"      ],      "cwd": "D:/Projects/LegalTextAnalysis",      "env": {        "PYTHONIOENCODING": "utf-8",        "UV_FORCE_STDIO": "1",        "DEBUG": "mcp:*,sqlite:*",        "MCP_SQLITE_EXPOSE_TABLES": "true",        "PATH": "D:\\\\Projects\\\\LegalTextAnalysis\\\\.venv\\\\Scripts;D:\\\\SQLite"      }    }  }}

2. Start-up Sequence

1. Close any existing MCP processes
2. Start MCP Server:

start-mcp.bat

1. Start MCP Inspector:

inspector.bat

1. Configure MCP Inspector (http://localhost:5173):

   • Transport Type: STDIO

   • Command: mcp-server-sqlite

   • Arguments: –db-path D:/Projects/LegalTextAnalysis/data/legal_text.db

   • Environment Variables:

     PYTHONIOENCODING=utf-8
     UV_FORCE_STDIO=1
     DEBUG=mcp:*,sqlite:*
     MCP_SQLITE_EXPOSE_TABLES=true
     PATH=D:\\Projects\\LegalTextAnalysis\\.venv\\Scripts
     

2. Start Claude Desktop

3. Verification Queries

Test the connection with these queries in MCP Inspector: