Database Tools and SQL

Enable the Database Tools and SQL plugin

This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in JetBrains Rider 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 Plugins.
Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.

The database management functionality in JetBrains Rider is supported by the Database Tools and SQL plugin. The plugin provides support for all the features that are available in DataGrip, the standalone database management environment for developers. With the plugin, you can query, create and manage databases. Databases can work locally, on a server, or in the cloud. The plugin supports MySQL, PostgreSQL, Microsoft SQL Server, SQLite, MariaDB, Oracle, Apache Cassandra, and others. See the full list of supported vendors in Create a data source.

Get started with database tools

Glossary	Learn the main concepts.
Create a data source	Start working with your database by creating a connection configuration for it.
Run a query	Connect an SQL file to a data source and run your code.
View results	Connect an SQL file to a data source and run your code.
Work with data	View and edit data in data editor.
Export/Import	Import and export your data to and from various formats with or without special tools like mysqldump, pg_dump, pg_restore, or psql.
Diagrams	Generate diagrams for database objects, build query and execution plans, generate flame graphs for `EXPLAIN` statements.
Troubleshooting	Connectivity issue is a very common definition and might include many problems. This troubleshooting article will guide you through the most common steps to identify and fix the issue. If you could not find the answer, try to contact JetBrains and we can try to help you.

Last modified: 21 November 2024