For the complete documentation index, see llms.txt. This page is also available as Markdown.

SQLite (roadmap)

SQLite REST and MCP support for pREST is on the roadmap (Phase 3) β€” turn a SQLite file into an API is planned, not shipped.

Status: Roadmap (Phase 3). pREST cannot open a SQLite file as a database backend in current releases.

Last updated: July 11, 2026 Β· Label: Roadmap


Planned positioning

Turn a SQLite file into a REST and MCP API with one binary.

Target use cases: local development, desktop apps, internal tools, prototypes, edge deployments, AI agents over local data β€” without running a database server.

SQLite is not β€œsmall PostgreSQL”; a dedicated dialect must handle schemas, concurrency, types, and metadata differently.


What works today

Use PostgreSQL (including lightweight local Postgres/Docker) or another available engine.


Last updated