Let an AI assistant query and inspect a local SQLite database directly.
Preview full content
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.