
SQLite
Embedded SQL database stored in a single file and linked into your app process, with no database server to run.
241 open-source projects declare SQLite in their code; no maker's live product we track uses it yet.
Profile checked
How makers use SQLite
What SQLite is used for
SQLite vs the alternatives makers chose
| Option | Makers' products | 2026 launches | Free for | At 10,000 users | Open source | |
|---|---|---|---|---|---|---|
| 573 45% | 63% | ~500 users | $25/mo · Pro | Yes | ||
| 187 15% | 9% | ~2,000 users | $9.66/mo · Blaze (pay as you go) | No | ||
| 128 10% | 5% | ~500 users | $58/mo · Atlas Dedicated M10 | No | ||
| 98 8% | 1% | — | — | Yes | ||
| 96 8% | 11% | None | $22/mo · Launch | Yes | ||
| 50 4% | 7% | ~630 users | $29/mo · Professional | Yes | ||
| 0 0% | 0% | — | — | Yes |
For database: how many of the 1,263 makers' products we know the database of chose each option, and the share among the 397 launched in 2026, since a tool that came first has products from every year, and what each costs at 10,000 users.
Costs are the cheapest plan that fits, from each vendor's pricing page, at the usage our stack planner assumes for a product with that many users. Free for: the users its cheapest plan a business can use stays free for.
When to use SQLite, and when not
Something else fits better if
- You want the database, auth and file storage in one project, and plain SQL you can take elsewhere: Supabase.
- You're building a live, collaborative app entirely in TypeScript: Convex.
- Your traffic is bursty or you run many preview deploys, and idle hours shouldn't cost much: Neon.
- You already run your own server and want a flat monthly cost: PostgreSQL.
What Hacker News says about SQLite
On Hacker News, 21% of comments about SQLite recommend it and 6% criticize it: net praise +16%, 6th best liked of 16 tools HN discusses for database.
By year
| Year | Comments choosing it, per month | Net praise |
|---|---|---|
| 2023 | 26 | +12% |
| 2024 | 31 | +32% |
| 2025 | 35 | +12% |
| 2026 (8 mo) | 49 | +4% |
In their words
- “I love this trend of pushing SQLite for advanced scenarios and new architectures. It’s so much more powerful than people give it credit for.” HN, Aug 2026
- “I really like the simplicity and speed of SQLite, I've used in both personal and professional projects.” HN, May 2026
Hacker News comments January 2023 to August 2026 that name SQLite in a sentence like "I use" or "we moved to", Claude read a sample of 100 and the counts scale it to all of them; net praise is comments recommending it minus comments criticizing it, as a share of all comments about it. How it's counted, and how HN compares with makers.
Who uses it
No maker's live product on record yet, and 241 open-source projects that declare it in their code.
We haven't found a maker's live product that uses SQLite yet — only the open-source projects below, which declare it in their code.
None of these in makers' own words.
Open source: a project that declares SQLite as a dependency in its public code — verifiable, but not necessarily a live product.
What its projects tell coding agents
What open-source projects' AGENTS.md and CLAUDE.md files say about SQLite, in our words — from the 74 files that name it:
Serves as the default or embedded local database, often with PostgreSQL as an optional alternative.15 files
Reach SQLite through an ORM or query builder such as Drizzle, Kysely or SeaORM, not scattered raw SQL.8 files
Tests use in-memory or real SQLite instead of external database services.7 files
Change the SQLite schema through versioned migration files rather than ad hoc edits.7 files
When supporting SQLite and other databases, keep schemas aligned and verify changes beyond SQLite alone.4 files
111 of the 167 open-source products built with SQLite that were worked on in the last 180 days keep instruction files for coding agents — 66%, against 53% of all the projects we read. AGENTS.md is in 96, CLAUDE.md in 74.
Alternatives to SQLite
All alternatives by situation →Further reading
Questions makers ask about SQLite
What are the alternatives to SQLite?
For database, the other options makers' products we track chose most are Supabase (573), Firebase (187), MongoDB (128), PostgreSQL (98), Neon (96), Convex (50). Open source or self-hostable among them: Supabase, MongoDB, PostgreSQL, Neon, Convex. Each alternative, with the situation it fits, is on the SQLite alternatives page.
Is SQLite free?
Yes — it is free, open-source software.
Is SQLite open source or self-hostable?
Open source, and you can self-host it. source ↗
Can AI coding agents work with SQLite?
No llms.txt, official MCP server or CLI found yet.
Who uses SQLite?
No maker's live product we track yet; 241 open-source projects declare it in their code. source ↗