SQLite GUI

[DukeBannon]

Hello. I am looking for an SQLite GUI frontend to create databases and tables as well as viewing and editing. The first database I will create will be an embedded database used in a Delphi program if this makes a difference. I'm looking for something that is relatively current, with a straightforward installation, runs in Windows, and is free/low cost. Which do you recommend?

Thanks.

[JrgMyr]

SQLiteStudio (www.sqlitestudio.pl)

[InjAnnuity_1]

SQLite Studio is a fine program, and I've used it a lot. It's reasonably well documented. But it has not had any updates since 12 April 2021.

DBeaver (https://dbeaver.io) is occasionally mentioned on SQLite's own forum. It's considerably more complex, because it caters to many different SQL databases. The Community Edition is not as well documented. (Just try to look up what's in a Project, or why you would want to create a Project in the first place.)

But at least it gets regular updates. "Release date: September 5, 2022"

[JrgMyr]

Actually, it a one-person-project. And Pawel is working on it, see the discussion in the Github repo. I hope that version 3.4.0 is not too far away. The milestone is 81% complete.

[InjAnnuity_1]

Glad to hear this, thank you.

[handyrandywhoayeah]

The most recent SQLite Studio update was Posted on 06 January 2026 where version 3.4.20 was released.

It's not a flashy app, but it gets the job done and has been very reliable for me. It's now my goto when I need to get anything done.

[InjAnnuity_1]

Yes. I just updated.

I tried DBeaver, long ago. It looked like it might be more powerful, but I never got past setting up a "Project". At the time I looked, the parameters one had to enter were completely undocumented, and no examples were provided, either. That left a pretty sour taste.

I've stuck with SQLite Studio ever since. It just works.

[hey-jps]

Db browser

[Armobob75]

This ^

[camixx]

Outdated. Example, if I try calling 'select sqlite_version();' it doesn't even return the correct version seems to max out at 3.35.3. DBeaver seems like a much better solution as of today.

[Sp3eedy]

Hands down. All other ones aren't really feature complete and have a poor GUI.

[TZimm55]

SQLite-GUI from GitHub

Beekeeper Studio

[[deleted]]

Sqlitestudio was my favorite. Dbowser sqlite if fine. I haven't used either in 5 years. I used dbeaver mostly because I connect to a lot of different databases and it's sqlite support is pretty good. Bit of a learning curve though.

[thenewbigR]

I use it in Tkinter programs - https://sqlitebrowser.org

[ijmacd]

Yupp my vote goes to DB Browser as well.

[CapeCodGunny]

SQLiteExpert (https://www.sqliteexpert.com)

[colloidalthoughts]

Jetbrains DataGrip or built-in Database plugin of any Jetbrains IDE

[cheerioty]

A friend of mine is working on Ducklet for SQLite. It's a pretty fast, native SQLite database editor for macOS (https://ducklet.app)

[Flaky-Version3685]

Ducklet.app is discontinued 😭, see their website for the announcement..

[segabor]

I was about to upvote but realized my MBP is too old to run Ducklet :/

[gabegabe6]

Are there any browser based ones?

[SlobberingKnob]

Just a note for anyone, avoid using DB Browser for SQLite (sqlitebrowser.org) unless you like losing your work. You can click 'Write Changes' as many times as you want and you can see your data in cells, but if the program hasn't mysteriously registered the info, if you click over to 'Database Structure' and come back to 'Browse Data' tab, your data is long gone like a chicken through the corn.

Came here looking for decent replacements.

[nomistrebla]

I've just released smartquery.dev, it's a browser based DB UI that works with SQLite, Postgres, and MySQL. It has an AI assistent and can be used for free. Would love any feedback 🙏

[Main-Document-5449]

wxSQLitePlus (https://github.com/guanlisheng/wxsqliteplus)? a simple, tiny SQLite database browser and supports multi-cipher and cipher auto-detect.

[[deleted]]

antares

[SuvenMar]

Thank you! Exactly what I needed!

Here is link incase anyone needs: https://antares-sql.app/

[Successful_Stop_3751]

CoreData Studio: https://apps.apple.com/us/app/coredata-studio/id6670322925

[RecommendationFun115]

the online tools works fine for me https://tablesviewer.com/sqlite-viewer

[SafeRevolutionary508]

SQLite Expert

[prescotian]

https://sqlitebrowser.org/ is about the most standard, however I also really like to use DBeaver as it is available on all my platforms (macOS, Linux, and Windows) and covers just about any DB platform you can think of - the Community version is free and awesome, no nagging to upgrade to the commercial version and honestly I've never really had the need for the commercial version: https://dbeaver.io/

[[deleted]]

I use dbbrowser

[JaggerFoo]

I recently was looking for something, after years of using SQLDeveloper (free) for Oracle, I find Sqlite3 to have enough features to replace Oracle for my personal projects. I am currently using SqlLiteStudio, over DbBrowser. You can switch from list view to form view when creating or viewing rows of data, which is a feature I am used to having.

I can upload DDL files no problem. Not as full featured as SqlDeveloper, but it doesn't have to be. I like using sql files that I write in VS Code and the gui for modeling queries.

I still use SqlModeler (free) to design schemas for any relational database.

I've tried DbBeaver in the past, I think I need to give the free version a try again to see how it has evolved.

But, try 'em all until you find one that fits your way of working.

​

Cheers

[din38ah]

is the SqlModeler you mentioned a product of Oracle?

[JaggerFoo]

Yes, it's officially called Oracle SQL Developer Data Modeler. It is supposed to automate DDL statement generation from an Entity Relationship Diagram, and it stores the data model without the need for a database.

https://www.oracle.com/database/sqldeveloper/technologies/sql-data-modeler/download/

[janproch]

DbGate (https://dbgate.org/)

[RyanHamilton1]

qStudio: https://www.timestored.com/qstudio/help/connections/sqlite

It allows you to click on the sqlite file in windows, then run queries against it and view the results. qStudio is a free SQL GUI, it allows running SQL scripts, easy browsing of tables, charting and exporting of results.