One shell for every database you manage.

BroadSQL is a command-line SQL client for people who work across many databases and environments daily. Connect, query, script, and export ... without switching tools for every vendor.

Latest release v5.0.7 (download it). Free for personal use. See the license.

Get started Download BroadSQL

Ships with drivers for H2, PostgreSQL, Apache Derby, HSQLDB, and SQLite. Any other JDBC-compatible database (Oracle, MySQL, SQL Server, MariaDB, DB2, and more) works by adding its driver. See technical requirements.

Who BroadSQL is for

The work it's built for has a shape: many databases, tasks you repeat, and a need to prove what ran.

Run the same query across DEV, TEST, and PROD by swapping one connection name.
Export results to Excel, CSV, or JSON with a single command.
Script a recurring extract or reconciliation once, and run it unattended against any environment.
Keep a library of diagnostics your whole team runs the same way.

That makes it a fit for data stewards checking integrity across systems, DBAs and support engineers working across environments, service-delivery and integration teams automating repeated work, and migration and archiving specialists who need data moved reproducibly and auditably.

If you live in a single database, a good GUI is probably all you need. BroadSQL earns its place the moment you're managing more than one.

Why a command-line client

Graphical tools are good for exploring one database. BroadSQL is built for the parts of the job that involve more than one: many servers, many vendors, the same task repeated on a schedule.

One shell, every database

Connect to H2, PostgreSQL, Derby, HSQLDB, SQLite, or any JDBC-compatible database, using the same commands and the same session, whichever vendor you're pointed at.

Built for automation

Run a stored SQL library, a script file (@file.sql), or a whole sequence of BroadSQL and SQL commands unattended, and re-run the same script against a different environment by swapping one connection name.

`PULL`: one command, any destination

Copy a query's results into a local H2 table, an Excel/ODS tab, or a CSV, JSON, Markdown, or HTML file, all through one unified syntax instead of a different tool per format.

No GUI required

Runs anywhere a terminal does. Easy to script, easy to run over SSH, easy to keep your saved queries under version control.

See it in action

A short walkthrough: connecting to a database and running commands from the shell.

Ready to try it?

Download the latest release and connect to your first database in a few minutes.

Read the getting started guide