Data loaders
Enable the Database Tools and SQL plugin
This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in PhpStorm by default. If the relevant features are not available, make sure that you did not disable the plugin.
Press Ctrl+Alt+S to open settings and then select .
Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.
Data loaders are specialized scripts that allow you to import your tabular data files into a database. They also enable the visual representation of this data in the data editor. The view of such files in the data editor is read-only.
Data display in data editor. For example:
Excel
JSON
To disable the Data tab with table view for JSON files, in the Advanced Settings page of settings Ctrl+Alt+S, set the Open file as table if detected by scripted loader to Table-first formats.
For more information about viewing data in data editor, refer to Data editor and viewer.
Data import from a file to a database
For more information about importing data from a tabular data file to a database, refer to Import data from tabular data files.
To locate data loaders, open the Project tool window Alt+1 and navigate to Scratches and Consoles | Extensions | Database Tools and SQL | data | loaders.
You can also create and use your own scripted data loader that you can write on Groovy or JavaScript.
Supported file formats
The supported file formats are as follows:
Script | File format |
|---|---|
Excel | .xlsx, .xls |
JSON | .json |
Parquet | .parquet |
Shapefile | .shp |