Articles

Practical write-ups on using BroadSQL for specific, recurring jobs.

A nicer place to work: what BroadSQL 5.4.0 and 5.4.5 bring you

October 8, 2026

#release #console #scripting #monitoring #export

A friendlier console with colors, themes and tables that fit your window, real variables and named arguments for Scripts, a new REPEAT command for monitoring, and DUMP as the one export command.

What is new in BroadSQL 5.3.0

September 20, 2026

#release #api #scripting #completion #upgrade

A URL-based API client, TAB completion that knows your own connections and scripts, and one Scripts Library replacing two catalogs, with the breaking changes to check before upgrading.

APIs in BroadSQL: Configured Operations, SQL, and Automation

September 18, 2026

#api #architecture #automation #sql #security

How configured API operations connect with BroadSQL's SQL workbench, from the 5.2.4 foundation and current development to automation and repeatable validation.

From query to autopilot: a BroadSQL productivity roadmap

September 4, 2026

#productivity #automation #scripting #export #extensibility

Most people learn one BroadSQL command, get their answer, and stop there, missing four more levels built specifically for everything they do more than once.

Light scripting in BroadSQL: the JS command family

September 4, 2026

#scripting #javascript #automation #multidatabase #devtools

A new lightweight JavaScript layer lets a BroadSQL script hold two or more database connections open at once and drive them with ordinary loops and conditionals, something the interactive shell cannot do at all.

Run the same SQL query across multiple databases and environments

August 29, 2026

#multidatabase #crossvendor #devops #productivity

When you manage DEV, TEST, and PROD, or Postgres, Oracle, and SQL Server side by side, the query stays the same but the tool changes every time.

Export SQL query results to Excel or CSV from the command line

August 29, 2026

#export #excel #csv #reporting #automation

Getting query results into Excel usually means a GUI, some copy-pasting, or a different one-off script for every output format.

Compare and reconcile data between two databases or environments

August 29, 2026

#datacomparison #migration #reconciliation #dataintegrity

After a migration, a sync, or a release, you need to prove PROD still matches the source: row counts, checksums, key differences, often across different vendors.

Build a diagnostic query library for support teams

August 29, 2026

#support #incidentresponse #querylibrary #oncall

When an incident spans environments, engineers end up rewriting the same investigative queries from memory: differently each time, often with production credentials in plain sight.

Store and manage database credentials securely across many connections

August 29, 2026

#security #credentials #compliance #connections

Working across dozens of databases usually means passwords living in scripts, config files, or sticky notes, and that's an audit finding waiting to happen.

Cross-vendor SQL on Windows without a GUI

August 29, 2026

#windows #cli #jdbc #crossvendor #drivers

A single command-line SQL client that reaches Oracle, SQL Server, Postgres, and more on Windows, with every driver behaving identically and no build step, is surprisingly rare.