Let an AI assistant query and inspect a local SQLite database directly.
Shared by Parshu · Published Aug 1, 2026
Lets an AI assistant run queries against a local SQLite database file — useful for asking questions about your own data in plain English, or having it help write and test a query before you use it in application code. ```json { "mcpServers": { "sqlite": { "command": "npx", "args": [ "-y", "@modelcontextprotocol/server-sqlite", "--db-path", "/absolute/path/to/database.db" ] } } } ``` Point this at a copy of your database rather than one you can't afford to have modified, if the server exposes write operations — check its current docs for whether it's read-only or allows INSERT/UPDATE/DELETE. Never point it at a production database without understanding exactly what operations it can perform first. Good starting point for the general shape of connecting an assistant to a local data file — verify the exact flags against the server's current documentation, since these details change between versions.