This guide walks through connecting a SQLite file to Cursor using QueryBear’s managed MCP server. End result: Cursor’s chat and composer can query a local SQLite database while you code.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
- Cursor with MCP support
Step 1: Add the SQLite connection to QueryBear
Dashboard → Connections → New connection → SQLite, with the file path.Step 2: Add QueryBear to Cursor
.cursor/mcp.json in your project root (or ~/.cursor/mcp.json globally):
Step 3: Authorize and verify
Open Cursor. First QueryBear call triggers OAuth in browser.“What QueryBear tools do you have? List my connections.”
Try it
“This Electron app’s SQLite DB has a messages table. Find the 10 most recent messages and their senders.”
Cursor pulls the schema, writes a SELECT ... ORDER BY created_at DESC LIMIT 10, and runs it via QueryBear.
SQLite + Cursor gotchas
.cursor/mcp.jsonis project-scoped — useful when you have one SQLite file per project.ATTACH DATABASEblocked at the parser.- Cursor caches MCP server status — restart Cursor after editing config.
- JSON1 functions work transparently.
Related
- SQLite MCP server — SQLite-specific deep dive
- Cursor client — Cursor overview
- Security model — what the gateway protects against