This guide walks through connecting a SQLite file to Claude Desktop using QueryBear’s managed MCP server. End result: Claude Desktop can query a local SQLite database from the chat UI.Documentation Index
Fetch the complete documentation index at: https://docs.querybear.com/llms.txt
Use this file to discover all available pages before exploring further.
What you’ll need
- A QueryBear account (sign up free)
- A SQLite file
- Claude Desktop installed
Step 1: Add the SQLite connection to QueryBear
Dashboard → Connections → New connection → SQLite:- File path — absolute path on the machine running the QueryBear connector.
Step 2: Add QueryBear to Claude Desktop
Step 3: Verify
“What QueryBear tools do you have? List my connections.”
Try it
“In the local SQLite DB, find the 5 longest support sessions and the resolution status of each.”
SQLite + Claude Desktop gotchas
- The SQLite file must be reachable from QueryBear’s connector, not from Claude Desktop. If your file is on a server, run QueryBear there; if it’s local, the connector reads it locally.
- Always copy DB files that other apps own (Apple Notes, browsers). Locking conflicts can be subtle.
ATTACH DATABASEis blocked at the parser.- Block sensitive content at the QueryBear level — anything Claude reads goes to Anthropic’s API.
Related
- SQLite MCP server — SQLite-specific deep dive
- Claude Desktop client — Claude Desktop overview
- Security model — what the gateway protects against