Tips & Tricks

How to Get Support for Database Tools and SQL Inside WebStorm

Read this post in other languages:

You may already know that other JetBrains IDEs, like PhpStorm and IntelliJ IDEA Ultimate, have built-in support for database tools and SQL. This support is provided through our database plugin, which comes bundled with those IDEs.

Although we don’t bundle the database plugin with WebStorm, there has long been a way to get database and SQL support inside it by acquiring a DataGrip or All Products Pack subscription. This would allow you to install the database plugin and use it inside WebStorm.

This option wasn’t optimal as it would require you to pay for the more expensive DataGrip or All Products Pack subscriptions. You’ve been asking us to find a better way to do that, and we’re finally able to say that we’ve done it! Starting with v2020.2, you can get a subscription for our database plugin and use it inside WebStorm for a sensible price.

How to try the plugin out

To install the plugin, go to Preferences/Settings | Plugins, then go to the Marketplace tab and search for Database tools and SQL. Click on the Install button next to the Database tools and SQL plugin in the search results and restart your IDE.

Next, you’ll be prompted to activate a license. If you already have one, you can activate it right there. Alternatively, click on Evaluate for free to start a free 30-day trial.

license-activation-dialog-webstorm

On the right-hand side of the License Activation dialog, you can also see the Buy license link. Click on this link if you want to purchase a subscription.

What you get with the database plugin

With the database plugin installed, you get access to all the features available in DataGrip, our standalone IDE for databases.

database-features-in-webstorm

Some of the key DataGrip features include:

  • Support for MongoDB, MySQL, PostgreSQL, and other databases.
  • A powerful data editor that lets you modify data rows and navigate through data quickly.
  • Coding assistance for queries similar to the one you get for your projects in WebStorm.
  • A wide range of import and export options for your data.

If you want to learn more about the available features, take a look at this webpage. You can also check out the DataGrip blog to learn about the latest improvements and news.

Pricing details

If you want to learn more about pricing, visit this webpage. Bear in mind that prices for corporate customers and individual users differ. If you already have a DataGrip or All Products Pack license, you can use it to activate the plugin without having to purchase any additional subscription.

As with other JetBrains products, there’s a continuity discount that applies starting with the second year of use. Unfortunately, it’s not aligned with WebStorm discounts.

That’s about it for now. Please let us know if you have any questions or feedback!

The WebStorm team

image description