• 2.4.143 - November 2017

      You can now customize settings and keyboard shortcuts in TeamSQL. To access and set your application preferences, go to **File** > **Preferences**. Settings you can change: * Editor font size * Line height * Tab size * Word wrap * Enable / Disable: * Mini-map * Line numbers * Code Completion * Built-in Snippets * History Pane * Explorer Pane * Links in the editor Keyboard shortcuts you can set: * Execute Query * Save / Save As... * Increase / Decrease Font Size * Toggle History Pane * Toggle Explorer Pane * Import File * New Tab * Close Tab * Search * Switch to Next / Previous Tab We'll be adding more settings that you can change. Stay tuned...

    • 2.3.134 - October 2017

      ### Highlights - Added Custom Snippets - Added support for editor-related Extensions - Shipped the Beautify SQL extension - Added support for Custom Snippet-related Extensions ### Added Custom Snippets Custom Snippets are those where you can set the value that's automatically populated into your query window when you're writing your SQL statements. They can say whatever you'd like. You can access Snippets features using the primary menu bar -- you can create a new snippet or manage a list of your existing snippets. If you're working on a query and you realize that you're typing the same thing over and over, you can select the text, right-click, and create a new snippet right then and there. You can create snippets that are available for a selected database, or you can create snippets that work for your entire TeamSQL installation. ### Added support for Custom Snippet-related Extensions TeamSQL supports the creation of custom snippet-related extensions. In addition to the on-the-fly editing that comes built-in to TeamSQL, you can create extensions to add to the default snippet behavior. ### Added support for editor-related Extensions / Shipped the Beautify SQL extension TeamSQL now supports extensions that alter the editor window. We've also shipped the Beautify SQL extension as an example of what this feature is capable of and how you might create your own extensions.

      2.2.132 - October 2017

      ### Hot fix - Fixed: Redis HGETALL does not work (https://github.com/TeamSQL/desktop-app/issues/154) - Fixed: Problem with INSERT, UPDATE snippets (https://github.com/TeamSQL/desktop-app/issues/183)

      2.2.131 - October 2017

      ### Syntax Highlighting & Macbook Touchbar Support In this release, TeamSQL now supports syntax highlighting and use of the Touch Bars found on new generation MacBook Pro laptops. ### Syntax Highlighting When working with the following database environments in TeamSQL, you can now take advantage of syntax highlighting: - AWS Redshift - MySQL - PostgreSQL - Redis - SQL Server ### MacBook Pro Touch Bar Support TeamSQL now supports use of the Touch Bars found on new generation MacBook Pro laptops. ![](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/2.2.131/teamsql-touchbar-1.png) Here’s what the Touch Bar and its TeamSQL commands look like up close: ![](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/2.2.131/teamsql-touchbar-2.png)

      2.1.127 - October 2017

      ## October 2nd ### 2.1 - TeamSQL Charts You can now create charts based on your data using TeamSQL's new Charts (preview) feature. Just run your query and click on the 'Charts' button. A new Charts window will appear where you can adjust the dimensions (x-axis, supports basic grouping) and the measures (supports multiple series). TeamSQL currently supports bar, line, area, pie charts and scatter plot. You can easily save your chart as a PNG file or copy it to the clipboard. TeamSQL Charts is currently in preview and we are looking forward to hearing your thoughts and feedback about it. ![](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/2.1.127/charts.png)

    • 2.0.125 - September 2017

      ## September 21st ### 2.0 - TeamSQL Extensions TeamSQL now supports extensions (in preview). You can easily build your extensions in TypeScript using TeamSQL Extensions SDK and teamsql-cli. With this update, TeamSQL Extension Store is also launched. You can publish your extensions in TeamSQL Extension Store and let other users install and use your extension. ![](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/2.0.125/release-notes-extension-image.png) TeamSQL initially supports extensions running as a “context menu” action in the result tables . In the next days, more extension types will be introduced, including snippets, main menu, connection and editor extensions. We can’t wait to see what you can create with TeamSQL Extensions SDK. Here are some sample extensions that we built for you. (all are available in the Extensions Store) ## Export to Google Spreadsheets You can easily integrate your Google account and export your results to Google Spreadsheets without exporting/importing CSV files. ## Intercom Lookup Intercom Lookup extension allows you to cross-reference data you’ve returned in TeamSQL and look up users in your Intercom account using their email addresses, user IDs, or Intercom IDs. ## Klipfolio Exporter Just like the Google Spreadsheets exporter, you can quickly integrate your Klipfolio account and upload your data to your static JSON data sources in Klipfolio with just a few clicks. ## S3 URL Signer One of the headaches while dealing with private S3 files is signing the URLs to quickly check the contents of files. Once you set your access key and secret key, it’s easy to browse S3 URLs in your results table with just one click. ## Open in Google Maps You can open a new Google Maps window by focused to the selected location in your results table. ## Open URL Just right click and select “Open URL” to open a new browser window to navigate the selected URL in your results table. Please contact us if you need an early access to the Extension SDK, documentations and teamsql-cli.

      1.4.122 - September 2017

      ## September 15th ### Release Notes This update includes various bug fixes and enhancements New: * Azure MySQL Connections are now supported. https://github.com/TeamSQL/desktop-app/issues/167 * Passphrase support for SSH Tunnels https://github.com/TeamSQL/desktop-app/issues/97 * Comments for columns are now available in Table Preview windows. https://github.com/TeamSQL/desktop-app/issues/164 * Ability to copy a cell with header https://github.com/TeamSQL/desktop-app/issues/158 * Alert feedback when there are no updates found after manually checking for updates. https://github.com/TeamSQL/desktop-app/issues/95 * 'Clear' option for Output list * Ability to connect to only one database in a server https://github.com/TeamSQL/desktop-app/issues/162 * Detailed connection error messages * Highlighting for Redis queries in the History screen https://github.com/TeamSQL/desktop-app/issues/165 * Driver updates for MySQL, PostgreSQL and Amazon Redshift * Title field in Share Data as URL form is automatically filled with tab title. * Error records in Output pane can now be opened as an alert for easily seeing the whole message in one action (instead of increasing the width of the Message column in data grid.) https://github.com/TeamSQL/desktop-app/issues/166 * Ability to connect to servers by double clicking on connections * Electron framework is updated to 1.7.5 https://github.com/TeamSQL/desktop-app/issues/157 Fixes: * Line ending problems for exported files in Windows * Tab colors are occasionally don't render correctly for schema enabled connections. * Datagrid paging controls are not visible for Redis connections * Query action bar is still visible when a query is moved into a folder. * Encryption for locally stored credentials https://github.com/TeamSQL/desktop-app/issues/150 * Encoding problems when copying result cells with special characters * 'Production warning bar' doesn't appear when the current connection of an existing tab is switched to a 'Prod' connection. * History preview causes a tab sync action, causing previewed query is saved as tab query. * Results table doesn't scroll up after changing pages. * Vertically resizing results table occasionally breaks. * Query doesn't get executed when the total length of multiple selected lines equals to 0.

    • 1.3.117 - August 2017

      ## August 28th ### Release Notes This update includes some performance enhancements. - Memory usage fixes for various cases including connecting to servers with many tables. - CPU related fixes for viewing dataset with hundreds of columns.

      1.3.116 - August 2017

      ## August 18th ### Hotfix Update - Bug fix: An issue affecting some users while adding new connection has been fixed.

      1.3.115 - August 2017

      ## August 18th - Release notes ### Redis Support TeamSQL now supports Redis. * You can run all Redis commands in TeamSQL's editor interface. * All **Redis commands** are available as **Snippets**. ![alt text](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/1.3.115/redis-snippet-1.png) * You can see the list of the keys inside the Connections pane. * You can easily search keys using the filter box. Unlike other connections, filtering in Redis doesn't just filter the listed items but sends an appropriate SCAN command to the server with MATCH parameter to do a server based scanning for the given keyword. ![alt text](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/1.3.115/redis-snippet-2.png) * Double clicking on a key will open the key value using the appropriate command for the data type of that key. * All results are displayed on TeamSQL data grid by default. However, you can switch to the Console View to see a terminal-like output, similar to what you see in *redis-cli.* * All existing data grid commands (copying, exporting, sharing as URL, etc...) work with returned Redis data as well.

      1.2.113 - August 2017

      ### August 14th ##### Row Filtering - You can apply column based filters to your result sets instead of dealing with the WHERE clauses in your query. You can COPY or EXPORT your filtered results as well. ![alt text](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/1.2.113/data-filter.png "TeamSQL Datagrid Filtering") - Fixed: Functions are duplicated in PostgreSQL databases. - Fixed: Query timeout is too low for MSSQL connections. (Query timeout is increased) - Other minor bug fixes

      1.1.111 - August 2017

      # Aug 1st - Release notes - Table Structure Previewer You can now see the structure of tables inside the tree-view in the databases pane, or as a separate window. See how it works. - New Snippets We have added over 50 new snippets into our editor. Creating a table, adding / removing columns, adding new stored procedures or functions just got easier. Click here for a list of supported snippets. - Improved Update Process We added a “New Update Available!” screen. You can now see what has changed in an update, before the update is downloaded. - Various improvements and bug fixes

    • 1.0.108 - June 2017

      ### June 28th - Release notes - TeamSQL v1.0 has been released.

      0.9.106 - June 2017

      ### June 23rd - Release notes - NEW: Proxy support added - Bug fix: Cancel button are not visible & not working with multistatement queries - Bug fix: Tab history list reloads after each statement in a multi-statement query

      0.9.105 - June 2017

      ### June 19th - Release notes - SSL support for MySQL ![mysql-ssl.png](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/0.9.105/mysql-ssl.png) - Automatic JDBC / ODBC URL and AWS endpoint parsing in Add / Edit connection screens ![parsing.gif](https://s3.amazonaws.com/io.teamsql.files/images/releasenotes/0.9.105/parsing.gif) - Fixed: SSH Tunnel still tries to open connection using port 22

    • 0.9.97 - May 2017

      # May 29th - Release notes * Bug fix: MSSQL (Azure) connection does not support encryption,( https://github.com/TeamSQL/desktop-app/issues/98 ), thanks to @flessard, @paulsinnett, @Philoushka

      0.9.96 - May 2017

      # May 26th - Release notes * Bug fix: PostgreSQL errors are not shown, thanks to @rasputino @aburakovskiy

      0.9.95 - May 2017

      # May 23rd - Release notes * New feature: Data sharing You can now share your results as URLs. Your data can be encrypted with AES256 and downloaded as PDF or Excel file. * Important fixes for SHARING and TEAMS * When a connection is selected for a shared query, TeamSQL now remembers the connections when the query is opened in the future. * Toggle on / off for explorer pane and results pane * It"s possible to change the connection of a tab using the new connection switcher. * Tab action bar is redesigned * "Save as..." button in tab action bar * "Share" button in tab action bar. * "Duplicate" option in Saved Queries screen * "New Connection" shortcut in the app menu * Ability to list saved queries grouped by their connections * "Elapsed time" is displayed in the bottom right corner of the results pane for each statement. * In PosgreSQL and Redshift, function parameters and their data types are now visible. It"s now possible to differentiate overloaded functions. * Fixed: Order of connections is not saved and connections listed in their original order when the app restarts. * Fixed: When a cell with new line characters are copied using shortcut, " " characters are visible instead of actual line breaks. * Fixed: When a query is deleted when it"s tab open, if the tab is saved again, sharing configuration of previously saved query are retained. * Fixed: Syntax errors while creating definitions for PostgreSQL and Redshift.

      0.9.93 - May 2017

      # May 5th - Release notes * Cloud Storage' renamed to 'Saved Queries' and it's icon has changed to 'File' icon. * Added right click context menus for folders and files in Saved Queries screen. * While connecting to 'schema' supported databases (PostgreSQL, MSSQL and Redshift), a loading activity indicator is added to each schema so users can understand db assets are still loading. * Added icons for tables and views, changed icons for SPs and functions. * When a connection is updated, all existing sessions for that particular connection is now restarted. * When there is a internet connection problem or the client cannot access to TeamSQL API, a warning is displayed in the authentication screen. * UX Improvements in query sharing popup window * Filtering tables, views and functions in connection pane for Microsoft SQL Server, PostgreSQL and Amazon Redshift * Now, '.' can be used in the hostname field of Microsoft SQL Server connections (i.e. “./SQLEXPRESS”) * You can now use SHIFT + ENTER in the search results screen to copy selected result name * Electron framework is updated to 1.6.6 * Monaco editor is updated to 0.8.3 * Fixed: An issue preventing MySQL Stored Procedure calls from returning data results * Fixed: Datagrid won't resize when window is resized or results pane is vertically resized. * Fixed: Add / edit connection windows are displayed after a delay of a few seconds in Windows (Fixed by async loading of DB drivers and upgrading Electron version) * Fixed: When running a mysql while-cycle like select @i from 1 to 5 from procedure-shows nothing. Recommendation: add option for converting SQL commands to capital https://github.com/TeamSQL/desktop-app/issues/99 * Fixed: SSH tunnel settings are removed while updating a query https://github.com/TeamSQL/desktop-app/issues/82 https://github.com/TeamSQL/desktop-app/issues/96 * Fixed: Cannot create new tab using CMD + SHIFT + N (CTRL + SHIFT + N) in PosgreSQL and Redshift. Databases won't list after server selection. https://github.com/TeamSQL/desktop-app/issues/72 * Fixed: Search results are not listed in Linux * Fixed: Some search results does not work when their connection is not open

    • 0.9.91 - April 2017

      # April 25th - Release notes - Hotfix: Test connection in New Connection Windows fails for Microsoft SQL Server

      0.9.90 - April 2017

      # April 25th - Release notes - Fixed: Renamed saved queries not showing any query. - Fixed: Folder previews may not be visible for some saved queries - Data layer update - Results data grid now expands with the container as the results pane is resized, https://github.com/TeamSQL/desktop-app/issues/53 - DB assets in Microsoft SQL Server are now grouped by schema names, - Schemas in PostgreSQL, Redshift and Microsoft SQL Server are now sorted alphabetically, https://github.com/TeamSQL/desktop-app/issues/60 - Fixed: public schema is not visible for some users in PostgreSQL, https://github.com/TeamSQL/desktop-app/issues/48 https://github.com/TeamSQL/desktop-app/issues/42 - Default database name field for PostgreSQL and Redshift are required. https://github.com/TeamSQL/desktop-app/issues/57 - Spatial data values are now visible in MySQL

      0.9.87 - April 2017

      # April 15th - Release notes - Fixed: EXPLAIN (any other) query results are not visible in PostgreSQL and Redshift ( https://github.com/TeamSQL/desktop-app/issues/45 )

      0.9.86 - April 2017

      # April 12th - Release notes - Added SSL connection support for PostgreSQL and Redshift.

      0.9.84 - April 2017

      # April 7th - Release notes - SSH Tunnels are now supported! You can enable “SSH Tunnel” for any of your existing connections or create a new one with SSH support. We also added SSH options to “Get Credentials” page, which is displayed when signing in from different computers. (https://github.com/TeamSQL/desktop-app/issues/40) - An activity indicator added inside the “Test Connection” buttons in Add / Edit connections. (https://github.com/TeamSQL/desktop-app/issues/63) - User interactions stay disabled when a tab is closed right after executing a query for the first time. - Cannot connect MySQL servers requesting insecure authentication.

    • 0.9.81 - March 2017

      # March 20th - Release notes - Bigint values are not display correctly when they are bigger than maximum integer value (https://github.com/TeamSQL/desktop-app/issues/33) - Menu shortcut combinations displayed incorrectly in Windows & Linux (https://github.com/TeamSQL/desktop-app/issues/32) - Cancel & Force Cancel buttons are not visible while MySQL queries are running. (https://github.com/TeamSQL/desktop-app/issues/31)

      0.9.46 - March 2017

      # March 2nd - Release notes - Electron is updated (https://github.com/TeamSQL/desktop-app/issues/10) - Major bug fixes and schema support for Microsoft SQL Server (https://github.com/TeamSQL/desktop-app/issues/14, https://github.com/TeamSQL/desktop-app/issues/16) - Bug fixes for search functionality - Performance improvements - Paging controls added to result data grids - Other fixed issues: - Problems with databases containing space character in their names - Databases pane cannot be resized. - Javascript errors for Linux users - App is stuck in starting state and nothing is loaded - Columns previews are not loading in search results for PostgreSQL and Redshift - Refresh tables, views and functions not working for schema enabled connections - Saved queries screen is not scrollable - Tabs occasionally got stuck when user double clicks on a table. - When a columns value includes NULL value, neighbouring columns may occasionally also show NULL. - For multi-statement queries, order of result tabs is incorrect. - Changes in favourited db assets may not be stored. - If a bit field in MySQL is NULL, result pane doesn’t show up (https://github.com/TeamSQL/desktop-app/issues/22) - Case sensitivity problems with MSSQL, MySQL, PostgreSQL and Redshift. (https://github.com/TeamSQL/desktop-app/issues/27, https://github.com/TeamSQL/desktop-app/issues/23) - Text overflow in saved queries (https://github.com/TeamSQL/desktop-app/issues/18) - Create table script fixed in Table Design tool (https://github.com/TeamSQL/desktop-app/issues/15)

      0.9.56 - March 2017

      # March 2nd - Release notes - Electron is updated (https://github.com/TeamSQL/desktop-app/issues/10) - Major bug fixes and schema support for Microsoft SQL Server (https://github.com/TeamSQL/desktop-app/issues/14, https://github.com/TeamSQL/desktop-app/issues/16) - Bug fixes for search functionality - Performance improvements - Paging controls added to result data grids - Other fixed issues: - Problems with databases containing space character in their names - Databases pane cannot be resized. - Javascript errors for Linux users - App is stuck in starting state and nothing is loaded - Columns previews are not loading in search results for PostgreSQL and Redshift - Refresh tables, views and functions not working for schema enabled connections - Saved queries screen is not scrollable - Tabs occasionally got stuck when user double clicks on a table. - When a columns value includes NULL value, neighbouring columns may occasionally also show NULL. - For multi-statement queries, order of result tabs is incorrect. - Changes in favourited db assets may not be stored. - If a bit field in MySQL is NULL, result pane doesn’t show up (https://github.com/TeamSQL/desktop-app/issues/22) - Case sensitivity problems with MSSQL, MySQL, PostgreSQL and Redshift. (https://github.com/TeamSQL/desktop-app/issues/27, https://github.com/TeamSQL/desktop-app/issues/23) - Text overflow in saved queries (https://github.com/TeamSQL/desktop-app/issues/18) - Create table script fixed in Table Design tool (https://github.com/TeamSQL/desktop-app/issues/15)

    • 0.9.45 - February 2017

      # Feb 20th - Release notes - Schema support added to Microsoft SQL Server (https://github.com/TeamSQL/desktop-app/issues/3) - TeamSQL now supports Azure SQL Databases. You can add Azure SQL connection as a Microsoft SQL Database connection. No additional settings are required. (https://github.com/TeamSQL/desktop-app/issues/5) - Windows authentication option is added to Microsoft SQL Server connections. (https://github.com/TeamSQL/desktop-app/issues/6) - Duplicate column names issue resolved. (https://github.com/TeamSQL/desktop-app/issues/4) - An issue preventing PostgreSQL and AWS Redshift table lists from refreshing is fixed. (https://github.com/TeamSQL/desktop-app/issues/7) - Minor bug fixes

      0.9.55 - February 2017

      # Feb 20th - Release notes - Schema support added to Microsoft SQL Server (https://github.com/TeamSQL/desktop-app/issues/3) - TeamSQL now supports Azure SQL Databases. You can add Azure SQL connection as a Microsoft SQL Database connection. No additional settings are required. (https://github.com/TeamSQL/desktop-app/issues/5) - Windows authentication option is added to Microsoft SQL Server connections. (https://github.com/TeamSQL/desktop-app/issues/6) - Duplicate column names issue resolved. (https://github.com/TeamSQL/desktop-app/issues/4) - An issue preventing PostgreSQL and AWS Redshift table lists from refreshing is fixed. (https://github.com/TeamSQL/desktop-app/issues/7) - Minor bug fixes

      0.9.44 - February 2017

      - Data Encryption for Enterprise Users - Folder support saved queries - Team Support - Table Design Editor for MySQL - Query sharing with individuals or team members - Tons of bug fixes and improvements

      0.9.54 - February 2017

      - Bug fixes

      0.9.53 - February 2017

      - Improved performance while rendering huge amount of rows - Index column of result data grids are now frozen and stays still during horizontal scroll - Tab history item selection bug is fixed - Minor bugfixes

      0.9.43 - February 2017

      - Improved performance while rendering huge amount of rows - Index column of result data grids are now frozen and stays still during horizontal scroll - Tab history item selection bug is fixed - Minor bugfixes

      0.9.41 - February 2017

      - Implemented copy - export options in results datagrid - Improved results datagrid performance (virtual scrolling) - Console output rows & cells now can be copied - Fixed various bugs for tab history feature - Bug fixes

      0.9.51 - February 2017

      - Implemented copy - export options in results datagrid - Improved results datagrid performance (virtual scrolling) - Console output rows & cells now can be copied - Fixed various bugs for tab history feature - Bug fixes

      0.9.40 - February 2017

      - Minor bug fixes

      0.9.50 - February 2017

      - Minor bug fixes

    • 0.9.39 - January 2017

      - Data Encryption for Enterprise Users - Folder support saved queries - Team Support - Table Design Editor for MySQL - Query sharing with individuals or team members - Tons of bug fixes and improvements

      0.9.44 - January 2017

      - Data Encryption for Enterprise Users - Folder support saved queries - Team Support - Table Design Editor for MySQL - Query sharing with individuals or team members - Tons of bug fixes and improvements

      0.9.37 - January 2017

      - Data Encryption for Enterprise Users - Folder support saved queries - Team Support - Table Design Editor for MySQL - Query sharing with individuals or team members - Tons of bug fixes and improvements

    • 0.9.34 - October 2016

      # Features - You can now search for tables, stored procedures, views and saved queries quickly with shortcut CMD+Shift+F - Filter database items using the box in item lists - You can now select multiple tabs ( with Shift key ) to close them at once - Autocomplete improvements ( Table columns names are suggested after SELECT keyword ) - Import your SQL files quickly from Menu - Bug fixes and UI improvements

      0.9.31 - October 2016

      # Features - You can now search for tables, stored procedures, views and saved queries quickly with shortcut CMD+Shift+F - Filter database items using the box in item lists - You can now select multiple tabs ( with Shift key ) to close them at once - Autocomplete improvements ( Table columns names are suggested after SELECT keyword ) - Import your SQL files quickly from Menu - Bug fixes and UI improvements

      0.9.30 - October 2016

      # Features - Linux version will update itself automatically - Shortcuts are available for all platforms - After Insert, Update and Delete commands are executed MySQL server messages are printed into console output # Fixes - Fixed bug in autocomplete duplicate suggestions - Fixed bug if MySQL returns empty result - Fixed bug post auto-update error message - Fixed data grid last row not visible - Fixed columns not loading for PostgreSQL and Redshift - Fixed test connection not working while adding connections in specific DB types - Fixed schemas not loading for recently added PG and Redshift connections - Fixed edit connection feature may not work for recently added connections

      0.9.32 - October 2016

      # Features - Linux version will update itself automatically - Shortcuts are available for all platforms - After Insert, Update and Delete commands are executed MySQL server messages are printed into console output # Fixes - Fixed bug in autocomplete duplicate suggestions - Fixed bug if MySQL returns empty result - Fixed bug post auto-update error message - Fixed data grid last row not visible - Fixed columns not loading for PostgreSQL and Redshift - Fixed test connection not working while adding connections in specific DB types - Fixed schemas not loading for recently added PG and Redshift connections - Fixed edit connection feature may not work for recently added connections

      0.9.26 - October 2016

      - Auto update bug fix\n - Autocomplete Bug fix

      0.9.28 - October 2016

      - Auto update bug fix\n - Autocomplete Bug fix

      0.9.25 - October 2016

      - New connection screen bug fix

  • Ready to get started?