Features & Benefits


BroadSQL has been designed for increasing the productivity of people working with databases on a daily basis.

  • Use a single client for your various database types : Oracle, MySQL, PostgreSQL, H2, HSQLDB, Derby/JavaDB, and much more. In fact any JDBC compliant databases can be accessed through BroadSQL.
    • You do not have to switch between proprietary tools.

 

  • Store your connection settings in a secure AES-256 encrypted Servers Definition File
    • Authenticate once, no need to remember the passwords of all the database connections, you just need to remember the master password
    • You do not have to switch between proprietary tools, you learn only one set of commands for all your JDBC databases
    • Your connection settings are stored in a H2 encrypted database

 

  • User Connection Scripts allow you to apply specific settings when opening a database
    • Your settings like default auto-commit are automatically loaded when you open a connection

 

  • Export data to various output formats: text, Microsoft Excel .xls or .xlsx, Microsoft Access
    • No need to spend time with the import utility in Excel, your data are stored directly in Excel cells
    • Data are not automatically converted in a wrong format when loaded from a CSV file

 

  • Use DIRECT LOAD and DIRECT UPDATE commands for mass inserting or maintaining data from a text file
    • No need to create a file containing a huge list of of update or insert statement
    • Data ar loaded at maximum speed

 

  • Use native BroadSQL extension commands like SHOW COLUMNS or SHOW TABLES
    • Facilitates daily tasks

 

  • Automate cross-platforms activities through scripts 
    • Save time through automation

 

  • Save queries in a SQL library for later executions 
    • No need to search your favorite SQL queries, they are stored in the library

 

  • Writes output to a Log text file (optional)
    • You can retrieve all commands and output that you have executed on your databases

 

  • Extend the set of SQL commands supported by your database connection or provided by BroadSQL by writing your own commands.
    • Extensibility: countless possibilities of integration with your specific information system

 

  • Embed BroadSQL features in your applications thanks to the documented API specification
    • Extensibility: countless possibilities of integration with your specific information system