gsqlcmd Version History

gsqlcmd Version History

Version 6.14, May 5, 2025

Bug Fixes

  • Fixed a WebView2-related exception in gsqlcmd when opening web pages.

Version 6.13, April 30, 2025

Licensing Changes

  • Introduced a dual licensing model:
  • The Free edition is now licensed under the MIT License.
  • The Standard and Enterprise editions are licensed under the updated End-User License Agreement (EULA).
  • The Free edition has no output row limits.

Breaking Changes

  • Removed the local CHM help file; use the online documentation instead.
  • Discontinued support for DB2, NuoDB, and SQL Server Compact.

New Features

  • gsqlcmd now loads environment variables from .env files.
    Use variable values in connection strings of gsqlcmd.exe.config like %name%.
    For example, if .env contains pass=123, you can use %pass% in the string instead of the actual password.
    This feature helps hide passwords in public repository projects.

Improvements

  • gsqlcmd uses WebView2 by default for displaying HTML and authentication forms instead of WebBrowser.
  • ExitCode now reflects the StatusCode value of the last web request.
  • Updated data providers: MySqlConnector, Npgsql, Oracle Database, and SQLite.

Version 6.12, April 30, 2024

Bug Fixes

  • Resolved issues with MySqlConnector and Npgsql data providers.

Version 6.11, April 29, 2024

Improvements

  • gsqlcmd now supports curl header parameters, such as -H "header: value".

Version 6.10, October 10, 2023

Improvements

  • Updated data providers: MySqlConnector, Npgsql, Oracle.ManagedDataAccess, and System.Data.SQLite.

Bug Fixes

  • Fixed an issue where gsqlcmd failed to read an SQL query from a file when using the /table option.

Version 6.9, July 12, 2023

Bug Fixes

  • gsqlcmd now respects the /cookie and /cookieFile options.
  • The registration wizard now correctly displays the names of available languages.

Version 6.8, April 10, 2023

New Features

  • gsqlcmd introduces a mode to generate JavaScript and TypeScript seed files for Knex using make /knex.
  • This mode is similar to make /insert, but generates seed files instead of SQL commands.
  • You can use the "knex" synonym instead of the "make /knex" command.
  • A new option, /truncate, generates the truncate() method instead of delete().
  • Specify the *.ts extension for TypeScript files and *.js for JavaScript files.

Improvements

  • gsqlcmd allows specifying MySQL objects without schemas, using the active connection's database name.

Version 6.7, February 21, 2023

Improvements

  • gsqlcmd now uses the MySql.Data.MySqlClient data provider installed on the system instead of the bundled version.
  • This change allows you to install and use the latest version of the provider: MySQL Connector/NET.
  • gsqlcmd dynamically substitutes the missing MySql.Data.MySqlClient provider with the built-in MySqlConnector provider.
  • gsqlcmd automatically reopens Snowflake connections when tokens expire.

Bug Fixes

  • Fixed various exceptions thrown by gsqlcmd when connecting to MySQL 8 using the MySql.Data.MySqlClient.

Version 6.6, January 23, 2023

Improvements

  • Updated .NET and .NET Framework data providers for Snowflake.
  • Enhanced registration wizards (RegisterProduct for Windows and register for Linux).
  • Updated utilities: AutoUpdate, dbsetup.exe, and grx.exe.

Bug Fixes

  • gsqlcmd now removes leading and trailing spaces in CSV output.
  • Fixed an issue where gsqlcmd lost decimal precision when outputting data from databases to CSV.

Version 6.5, December 13, 2022

New Features

  • gsqlcmd is now available for .NET 6.0 on both Linux and Windows.
  • gsqlcmd examples are now released under the MIT license.

Version 6.4, October 19, 2022

Bug Fixes

  • gsqlcmd now correctly formats decimal values in CSV as 6E+09.00.

Version 6.3, October 13, 2022

Bug Fixes

  • gsqlcmd no longer formats integer values with two dots (e.g., 1..00).

Version 6.2, October 5, 2022

Breaking Changes

  • gsqlcmd now rounds output to four or two decimal places without losing precision.
  • Use the /noround option to disable this behavior.

Bug Fixes

  • gsqlcmd now formats numeric values as text in certain cases.
  • The /DateTimeFormat option now respects date-only formats.

Version 6.1, August 17, 2022

Bug Fixes

  • CSV-based SQL commands now contain NULL instead of an empty string for empty string columns in the first line.
  • gsqlcmd now correctly defines quotes for CSV files in the output FMT file.

Version 6.0, July 5, 2022

This major release introduces three significant features:

  • gsqlcmd now supports Basic, Windows, Forms, OAuth1, and OAuth2 authorization methods, complete with all required options and interactive authorization.
  • SELECT queries from files and URLs now support WHERE and ORDER BY clauses.
  • An auto-update tool is included to check for and install software updates.

Changes in End-User License Agreement

gsqlcmd includes an updated End-User License Agreement. The key change is:

"Consent to Be Included in the Client List: By purchasing the software on behalf of your company, you implicitly consent to the listing of your company name as our customer. You can revoke this consent at any time by submitting a request."

New Features

  • gsqlcmd includes the AutoUpdate tool to check for and install updates.
  • It checks for updates based on a customized schedule.
  • You can manually run the update tool using the AutoUpdate mode.
  • gsqlcmd supports WHERE and ORDER BY clauses in SELECT queries from files and URLs.
  • gsqlcmd defaults to convert mode for inline SELECT queries from files and URLs.
  • gsqlcmd supports various authorization schemas with the Auth option: Auto, None, Basic, Windows, Forms, OAuth1, OAuth2, and Custom.
  • Use the new /interactive option to acquire authorization credentials interactively.
  • New OAuth2-specific modes and options include:
  • Modes: get-authcode, get-token, refresh-token, revoke-token.
  • Options: /authorizationUrlFormat, /getTokenUrlFormat, /getTokenBodyFormat, /refreshTokenUrlFormat, /refreshTokenBodyFormat, /revokeTokenUrlFormat, /revokeTokenBodyFormat, /authorizationUrl, /getTokenUrl, /refreshTokenUrl, /revokeTokenUrl, /code, /validTo.
  • New OAuth1-specific modes and options include:
  • Modes: get-authcode, get-token, refresh-token.
  • Options: /consumerKey, /consumerSecret, /callback, /requestTokenUrl, /authorizationUrl, /accessTokenUrl, /oauthToken, /oauthTokenSecret, /oauthSessionHandle, /oauthExpiresIn, /validTo.
  • gsqlcmd supports user-defined options for OAuth1 and OAuth2 authorization.
  • For example, you can set values for the accounts-server option from ZohoCRM to use in the /get_token_url_format and /refresh_token_url_format options.
  • New /cookie and /cookieFile options are available, particularly useful for Forms authorization.
  • New /urlParameters and /authorizationHeader options are used with custom authorization.
  • gsqlcmd adds URL parameters and sets the authorization header for web requests.
  • You can achieve the same result by specifying an initial URL with parameters and the header like /header=Authorization: <AuthorizationHeader>.
  • New /tokenFields option allows explicit specification of fields to save in the /tokenJson file.
  • New /serviceJson option loads service configurations from JSON or plain text files.
  • You can split client, service, and token options across files like /clientJson=client.json /serviceJson=service.json /tokenJson=token.json.
  • New /acceptEncoding option defaults to gzip, deflate.
  • gsqlcmd reads default values for the Accept and UserAgent headers from the gsqlcmd.exe.config file.
  • Plain text option files can now include line comments starting with the # character.
  • gsqlcmd shows the shortest help by default. Use /? for more help and the help mode for full documentation.

Bug Fixes

  • gsqlcmd now correctly outputs the last put options only from Yahoo Finance.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.