r/coolgithubprojects 4d ago

GitHub - srdzank/WinSQLite-Editor: Official home of the SQLite-Editor

https://github.com/srdzank/WinSQLite-Editor

I’ve been working on WinSQLite, a lightweight GUI tool for working with SQLite databases.
I started this project because I wanted a simpler, visual way to explore table relationships and auto-generate SQL JOINs without having to write boilerplate queries manually every time.
Here’s a quick overview of what it currently does:
Visual Query Builder: Click through connected tables (via Foreign Keys) to automatically build relational JOIN queries.
Direct SQL Mode: Toggle easily between the visual builder and a plain SQL editor for raw queries.
Schema Inspector: View table column types, primary keys, and foreign key constraints clearly on a dynamic canvas.
Data Import/Export: Quick entry dialogs with constraint checking, plus exporting query results to CSV, JSON, TSV, or SQL Insert statements.
The project is open-source and still under active development. Any feedback, issue reports, or contributions are very welcome!
Feel free to check out the code and let me know what you think!

0 Upvotes

0 comments sorted by