← Back to Field Notes

pgLens Now Supports SQLite

pgLens expands beyond PostgreSQL—explore SQLite databases with the same intelligent, type-aware interface you already know.

Beyond Postgres

When we launched pgLens, it was built for one thing: making PostgreSQL exploration effortless. But the most common request we heard was simple—“Can it do SQLite too?”

Today, the answer is yes.

SQLite Support is Here

pgLens now connects to SQLite databases with the same experience you get with Postgres:

  • Schema Discovery - Tables, columns, types, indexes, and foreign keys auto-detected from your .db or .sqlite files
  • Smart UI - The same type-aware rendering (toggles for booleans, formatted JSON, human-readable dates) works across both engines
  • Relationship Mapping - Foreign key graphs for SQLite databases, even when PRAGMA foreign_keys hasn’t been enforced
  • Search & Browse - Full-text search, pagination, and sorting—no matter the database size

Just point pgLens at a SQLite file and start exploring.

Why SQLite Matters

SQLite is everywhere. It powers mobile apps, embedded systems, local-first software, Electron apps, and increasingly production workloads. Yet the tooling for exploring SQLite databases hasn’t kept up:

  • Most GUI tools are Postgres- or MySQL-first, with SQLite as an afterthought
  • The sqlite3 CLI is powerful but not visual
  • Browser-based tools often require uploading your database to a server

pgLens keeps everything local. Your SQLite file never leaves your machine.

How It Works

Web (pglens.io)

  1. Visit pglens.io
  2. Select SQLite as your database type
  3. Drop in your .db or .sqlite file
  4. Explore

The file is read entirely in-browser—nothing is uploaded.

Local / Self-Hosted

git clone https://github.com/lab-zee/pgLens
cd pgLens
npm install
npm run dev

Then connect by providing a path to your SQLite file.

Same Philosophy, Broader Reach

Adding SQLite doesn’t change what pgLens is about: see your data clearly, without overhead. Whether it’s a production Postgres cluster or a local SQLite file powering your side project, the experience is the same.

  • Privacy-first: no data leaves your environment
  • Open source: MIT licensed, fork and customize freely
  • Zero config: connect and explore

What’s Next

SQLite support is the first step toward a multi-engine future. We’re evaluating additional database support based on community feedback. If there’s an engine you’d like to see, open an issue on GitHub.

Try it now: pglens.io Source Code: github.com/lab-zee/pgLens License: MIT