SQLite Connection MCP Error

[jasonmutd]

Pre-submission Checklist

• I have verified that this discussion would not be more appropriate as an issue in a specific repository
• I have searched existing discussions to avoid duplicates

Discussion Topic

I would like to share my personal step-by-step experience to connect Claude Desktop with SQLite. As I spent two days, trying to figure out how to connect my sqlite database to Claude desktop. After searching the mcp official website as well as the discussions here, I am not able to find a solution thus I throw this question to Claude and try to figure out a solution.

1. Setup Python Virtual Environment:

mkdir claude-mcp-project
cd claude-mcp-project
python -m venv venv
source venv/bin/activate

2. Install required package:
   pip install mcp-server-sqlite

3. Configure claude Desktop and modified calude_desktop_config.json with:

    "sqlite": {
      "command": "~/venv/bin/mcp-server-sqlite",  ## this should be the directory where mcp-server-sqlite package is installed
      "args": [
        "--db-path",
        "~/test.db" ## this should be the directory where database is saved
      ]
    }

4. Restarted Claude Desktop to apply the configuration.

Please note that the example that provided here showed two different approaches, which I have trouble understanding due to my limited experiences and thus figured out a different way. Hope it would help!

[damms005]

You can try out DevDb if you use VS Code/Windsurf/Cursor etc.

https://github.com/damms005/devdb-vscode?tab=readme-ov-file#mcp-configuration