Query and inspect PostgreSQL databases via natural language.
SQLite
Local SQLite database access with full read/write support.
What it does
Provides read and write access to a local SQLite database file. Supports queries, inserts, updates, schema inspection, and table creation.
Why it matters
SQLite is the simplest persistent storage option for local AI workflows. This MCP enables full database interaction without any server setup.
Best for
- Local prototyping
- Agent memory storage
- Offline data workflows
- Testing SQL logic
- Simple CRUD applications
Not ideal for
- Production workloads
- Multi-user concurrent access
- Large datasets
When to use it
When you need fast, local, serverless database access for prototyping, local apps, or agent memory storage.
When not to use it
When you need a shared or production database with concurrent access or scaling requirements.
Key features
- Full read/write access
- Schema creation
- No server required
- Lightweight setup
- File-based persistence
Frequently asked questions
Does SQLite MCP support write operations?
Yes. Unlike the Postgres MCP, it supports inserts, updates, deletes, and DDL.
Is a server required?
No. SQLite is file-based. You just point it at a .sqlite file path.
Install
$ npx -y @modelcontextprotocol/server-sqlite /path/to/db.sqliteScores
Details
- Pricing
- open source
- Setup time
- 2 min
- Complexity
- Low
Works with
Alternatives
- PostgreSQL →
Query and inspect PostgreSQL databases via natural language.
- Memory →
Persistent knowledge graph memory across AI conversations.
More Databases MCPs
Other tools in the same category worth evaluating.
Full Supabase access: database, auth, storage, and edge functions.
Exploring Top MCPs for Databases? See all Databases MCPs →