Fast SetupLightweightBuilder FavoriteOpen Source

SQLite

Local SQLite database access with full read/write support.

Setup: 2 minLow complexityTop MCPs for Databases

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

Install SQLite
$ npx -y @modelcontextprotocol/server-sqlite /path/to/db.sqlite

Scores

Ease of setup
5/5
Flexibility
3/5
Popularity
4/5
Agent useful
4/5
Builder speed
5/5

Details

Pricing
open source
Setup time
2 min
Complexity
Low

Works with

ClaudeCursorAny MCP-compatible client

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.

Popular

Query and inspect PostgreSQL databases via natural language.

databasesqlpostgresqueries
3 minLow
Trending

Full Supabase access: database, auth, storage, and edge functions.

supabasedatabasebackendpostgres
5 minLow

Exploring Top MCPs for Databases? See all Databases MCPs →