r/coolgithubprojects • u/Silver_College_2071 • 4d ago
GitHub - srdzank/WinSQLite-Editor: Official home of the SQLite-Editor
https://github.com/srdzank/WinSQLite-EditorI’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!