Which QueryStorm is right for you?

Choose your QueryStorm license

SQL Lite
249
License + 1yr support
109
Yearly support (2nd year onwards)

Run SQL queries on workbook tables as if they were tables in a database. Includes the SQLite engine and the IDE for writing and running SQL queries on Excel tables.

SQL Professional
379
License + 1yr support
169
Yearly support (2nd year onwards)

Enables all SQL related functionality including connectivity to external databases. Allows processing data, automating workbooks and building and publishing Excel functions via SQL.

Developer
499
License + 1yr support
219
Yearly support (2nd year onwards)

Get the full power of QueryStorm with a Developer license. Use SQL, C# and VB.NET in Excel to query data, build and publish functions and automate workbooks.

SQL Lite
99
License + 1yr support
39
Yearly support (2nd year onwards)

Run SQL queries on workbook tables as if they were tables in a database. Includes the SQLite engine and the IDE for writing and running SQL queries on Excel tables.

SQL Professional
149
License + 1yr support
59
Yearly support (2nd year onwards)

Enables all SQL related functionality including connectivity to external databases. Allows processing data, automating workbooks and building and publishing Excel functions via SQL.

Developer
199
License + 1yr support
79
Yearly support (2nd year onwards)

Get the full power of QueryStorm with a Developer license. Use SQL, C# and VB.NET in Excel to query data, build and publish functions and automate workbooks.

For students and teachers
Free

Students and academic staff members are eligible to use all JetBrains tools free, upon verification of their university/college domain email or ISIC card.

For user groups
Free

Organizers of active user groups can get free licenses for QueryStorm products to raffle off at regular user group meetings and community events.

For Microsoft MVPs
Free

Organizers of active user groups can get free QueryStorm licenses to raffle off at regular user group meetings and community events.

Compare Features

SQL Lite
SQL Professional
Developer
SQL in Excel
Advanced IDE features
External database connectivity
Custom Excel functions (SQL)
Workbook automation (SQL)
Publishing functions (SQL)
C# scripting in Excel
Workbook automation (.NET)
Excel functions & extensions (.NET)
NuGet support
Publishing functions & extensions (.NET)
License
$249
$379
$499
Yearly support
$109
$169
$219

Compare Features

SQL Lite
SQL Professional
Developer
SQL in Excel
Advanced IDE features
External database connectivity
Custom Excel functions (SQL)
Workbook automation (SQL)
Publishing functions (SQL)
C# scripting in Excel
Workbook automation (.NET)
Excel functions & extensions (.NET)
NuGet support
Publishing functions & extensions (.NET)
License
$99
$149
$199
Yearly support
$39
$59
$79

Compare Features

For Students and Teachers
For User Groups
For Microsoft MVPs
License
Free
Free
Free
Yearly support
Free
Free
Free
SQL in Excel
Advanced IDE features
Database connectivity
Custom Excel functions (SQL)
Workbook automation (SQL)
Publishing functions (SQL)
C# scripting in Excel
Workbook automation (.NET)
Excel functions & extensions (.NET)
NuGet support
Publishing functions & extensions (.NET)

Frequently Asked Questions

How can I manage my licenses?

To manage your licenses, please create an account on Keystodian (our license management portal). Make sure to use the same email address that your keys are registered to. The portal allows you to view and manage your keys. The credentials you define on the licensing portal can be used directly in the activation prompt to activate QueryStorm (in addition to activating via key and via email).

Can I move my licenses from machine to machine?

Yes, you can transfer licenses as often as you like. The licensing prompt offers three ways of activating, all of which are applicable for transferring licenses as well:

  • Sending a transfer link via email
  • Using your existing key on another machine
  • Using your license portal credentials in the license prompt

All three methods will deactivate a previously activate machine (if the key has no more available slots).

Do my clients need a license to use my workbooks and functions?

No, they do not a license. In order to use the workbooks and functions that you build with the QueryStorm IDE, your clients just need to have the QueryStorm runtime installed. The runtime is a free 4MB installer that can be freely distributed to your end users and clients.

Can I publish and/or sell my own QueryStorm extensions and workbooks?

Yes, you can publish (and optionally sell) your own extensions. You can also license and sell your smart workbooks.

Extensions: If you would like to publish a generally useful extension package to the official QueryStorm feed, contact us to submit it for publication. You can, of course, freely publish any packages to your own Azure servers. If you would like to sell licenses for an extension that you built, our transaction fee will be 20% (in case the extension is distributed via on your Azure Artifacts server) or 30% if it will be hosted on the official QueryStorm feed.

Workbooks: If you would like to license a workbook to your clients, you can do so as well, using the same licensing and payment infrastructure that QueryStorm itself uses. This allows you to sell workbooks without worrying about your intellectual property (simply remove all code and leave the compiled dlls inside the workbook) or worrying about how to charge for them per machine.

In both cases (licensing workbooks or extensions) the process is simple. You install the Keystodian.Client NuGet package to your project and make sure to call the method for checking the license at the appropriate time (at startup or at function call). In addition, you will need to register for vendor status at keystodian.com and define your product there.

For more detailed instructions, please get in touch.

Can I activate QueryStorm on multiple machines over the network?

Yes, your domain administrator can install and activate it remotely on multiple machines on your domain. For help with this, please get in touch.

What happens if I cancel my support subscription?

All licenses are perpetual. Once you buy a license it’s yours forever. The support subscription gives you access to new versions as well as email and online support. The initial price of the license includes the first year of support. The support subscription for the 2nd year onwards is created automatically, but if you will not be needing it, you can immediately cancel it without affecting your license or the currently started year of support.

Can I reactivate a cancelled subscription?

Yes, you do not need to pay for an entirely new license to add support to an existing license. However, we charge a one-time 25% fee for reactivating deactivated subscriptions. For example, if the subscription cost is $199, you will be charged $249 initially ($199 for the year + $50 reactivation fee) and then $199 on following years.

Get Started

Read the documentation to
learn how to use QueryStorm.

Contact sales

Contact us for any licensing
or sales related questions.