ssms-wakatime icon indicating copy to clipboard operation
ssms-wakatime copied to clipboard

SQL Server Management Studio plugin to quantify your coding with automatic time tracking and metrics about your programming. https://wakatime.com

WakaTime for SQL Server Management Studio

Metrics, insights, and time tracking automatically generated from your programming activity.

Installation

  1. Download the latest release https://github.com/gandarez/ssms-wakatime/releases/latest.

  2. Unzip the content.

  3. Run AddPackage.bat to add WakaTime extension into registry white list.

  4. Manual instructions:

    1. For legacy versions before v18:
      1. Copy the folder WakaTime to the desired installation folder(s):
        • v2012 - C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions
        • v2014 - C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions
        • v2016 - C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions
        • v17 - C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions
    2. For SSMS v18:
      1. Copy the folder WakaTime.v18 to the desired installation folder:
        • v18 - C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\
    3. For SSMS v19:
      1. Copy the folder WakaTime.v18 to the desired installation folder:
        • v19 - C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions\
    4. For SSMS v20:
      1. Copy the folder WakaTime.v18 to the desired installation folder:
        • v19 - C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\
  5. Enter your api key, then press enter.

  6. Use SSMS and your coding activity will be displayed on your WakaTime dashboard.

Usage

Visit https://wakatime.com to see your coding activity.

Project Overview

Supported SQL Server Management Studio Editions

  • SQL Server Management Studio 2012 (build number 11.0.x.x)
  • SQL Server Management Studio 2014 (build number 12.0.x.x)
  • SQL Server Management Studio 2016 (build number 13.0.x.x)
  • SQL Server Management Studio 17 (build number 14.0.x.x)
  • SQL Server Management Studio 18 (build number 15.0.x.x)
  • SQL Server Management Studio 19 (build number 19.0.x.x)
  • SQL Server Management Studio 20 (build number 20.0.x.x)

Troubleshooting

If the extension was blocked, try running as administrator.

<description>Appid denied the loading of package</description>
<guid>{52D9C3FF-C893-408E-95E4-D7484EC7FA47}</guid>