You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SqlBrowserFX is a feature rich cross platform sql client for SQLite , MySQL, MariaDB and PostgreSQL (partially supported).
Features
Manage data (insert, update, delete) via gui.
Execute raw sql queries.
Editor for sql with syntax highlighting, autocomplete, refactoring features.
Support for sql, java files editing via drag and drop.
Adjustable responsive ui supporting multiple code areas and tables opened at the same time.
Graphical representation of database as tree.
Graphical representation of database as diagram.
Exposure of database to the web as RESTful service with one click.
Import, export csv files.
Queries History.
Savable queries.
Support for SQLite.
Support for MySQL, MariaDB.
Partial Support for PostgreSQL.
Cross Platform.
Css themable (Dark, Light etc).
Generation of simple database tables diagram.
Prerequisites
Java 21 +
Installation of desired database.
Installing
Copy sqlbrowser-for-build.db to sqlbrowser.db.
Import the project to your favorite ide as maven project and run GUIStarter class.
You can also run install.sh script , if you are using linux in order to install sqlbrowserfx as cli command
'sqlfx'.
Compatibility with older versions of java
Tag 2.5.0 -> Java 17
Tag 1.5.0 -> Java 8
Build standalone app
Run build.sh script, this will generate all files needed in 'dist' folder.
Run SqlBrowserFX.exe for Windows, or run sqlbrowserfx.sh for Linux.
Awesome projects used
DockFX - The docking framework used (a moded version actually).
RichTextFΧ - Library which provides editor with syntax highlighting feature.
ControlsFX - Library which provides many useful custom gui components.
Spark Java - The web framework used. (Until version 1.5.0)