Dev tools · alternatives · 2026
24 alternatives to LiteCLI
SQLite CLI with auto-completion and syntax highlighting.
Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. LiteCLI launched in 2019; newer entries below may have overtaken it.
- 1
SQLite CLI with auto-completion and syntax highlighting
2019 · litecli.com · its alternatives →
- 2
Tabnine is the AI code assistant that accelerates and simplifies software development while keeping your code private, secure, and compliant.
2018 · tabnine.com · its alternatives →
- 3
Hi HN, James, Valter, Sam and the team from ElectricSQL here. We're really excited to be sharing ElectricSQL with you today. It's an open source, local-first sync layer that can be used to build reactive, realtime, offline-capable apps directly on Postgres with two way active-active sync to SQLite (including with WASM in the browser). Electric comprises a sync layer (built with Elixir) placed in front of your Postgres database and a type safe client that allows you to bidirectionally sync data from your Postgres to local SQLite databases. This sync is CRDT-based, resilient to conflicting…
2023 · electric-sql.com · its alternatives →
- 4
Setting up Kafka or such enterprise oriented software with their clusters or dedicated servers is heavy and bothering enough that most small teams or indie hackers skip it entirely and making compromise to use in-memory queues. I wanted something in between: a persistent queue that is simple to run (one binary, which makes one sqlite db), gets real fault isolation and crash recovery due to Elixir, easy to inspect (open ezra.db in any SQLite browser and see every task), and requires no new client library - it speaks the Redis Streams wire protocol, so any Redis client in any language just…
Jun 2026 · github.com · its alternatives →
- 5
pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…
2024 · github.com · its alternatives →
- 6
SQLite extension + bindings for Postgres NOTIFY/LISTEN semantics with durable queues, streams, pub/sub, and scheduler - russellromney/honker
Apr 2026 · github.com · its alternatives →
- 7MA
2015 · mycli.net · its alternatives →
- 8
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
- 9PA
2015 · pgcli.com · its alternatives →
- 10
A complete SQLite parser you can embed anywhere.
Mar 2026 · marcobambini.substack.com · its alternatives →
- 11
Transparent dictionary-based row-level compression for SQLite - phiresky/sqlite-zstd
2022 · github.com · its alternatives →
- 12
Finally, a home for all your SQL queries.
2021 · rosefinchapp.com · its alternatives →
- 13
Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript. - sqliteai/sqlite-js
2025 · github.com · its alternatives →
- 14
Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is…
2023 · powersync.com · its alternatives →
- 15
Interactive Redis: A Terminal Client for Redis with AutoCompletion and Syntax Highlighting. - laixintao/iredis
2020 · github.com · its alternatives →
- 16
Query SQLite files in S3 using s3fs. Contribute to litements/s3sqlite development by creating an account on GitHub.
2022 · github.com · its alternatives →
- 17
I've created tascli to solve a need of simple activity tracker including task and record in local CLI. It's available via cargo and brew tap. It's simple, the API is minimal and without complex usage patterns. It supports both task and records and treat them separately (task have deadlines, records are point in time) It doesn't run any background processes. It is small (compiled sizes <2MB) It is fast (<5ms on each command on a normal computer/github workflow host). It stores activities into a local sqlite db file. Looking for new features requests too!
Dec 2025 · github.com · its alternatives →
- 18DU
Hi! As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite. Reasons: 1) Using an SQL Database meant having less flexibility and iterating slower. 2) Alternative, proven Document Databases only offered client/server support. 3) No network. Having SQLite server-side next to the application is extremely fast. 4) Replicating Firestore's API makes it easy to use. 5) Listeners and real-time…
2023 · npmjs.com · its alternatives →
- 19SQ
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
2021 · its alternatives →
- 20
I work mostly in the terminal but found myself constantly switching to bloated GUIs like SSMS only for the simple task of browsing tables and run queries. And I didn't find Existing SQL TUIs intuitive, having to read documentation to learn keybindings and CLI flags to connect. Given I had recently switched to linux, I found myself using vs code's sql database extension. Something was awfully wrong. I wanted something like lazygit for databases – run it, connect, and query and frankly just make it enjoyable to access data. Sqlit is a keyboard-driven SQL TUI with: - Context-based keybindings…
Dec 2025 · github.com · its alternatives →
- 21
- 22
SQLite encryption at-rest is a hot requested feature of both the “default” CGo driver [1] and the transpiled alternative driver [2]. So, this is a feature I wanted to bring to my own Wasm based Go driver/bindings [3]. Open-source SQLite encryption extensions have had a troubled last few years. For whatever reason, in 2020 the (undocumented) feature that made it easy to offer page-level encryption was removed [4]. Some solutions are stuck with SQLite 3.31.1, but Ulrich Telle stepped up with a VFS approach [5]. Still, their solution seemed harder than something I'd want to maintain, as it…
2024 · github.com · its alternatives →
- 23
- 24
Also compare
- LiteCLI – A CLI for SQLite with auto-completion and syntax highlighting alternatives
- TabNine, an autocompleter for all languages alternatives
- ElectricSQL, Postgres to SQLite active-active sync for local-first apps alternatives
- Lightweight Task queue on Erlang/OTP, SQLite-backed, no overengineering alternatives
- Embed an SQLite database in your PostgreSQL table alternatives
- Honker – Postgres NOTIFY/LISTEN Semantics for SQLite alternatives
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →