Yugabyte’s SQL API (YSQL) is PostgreSQL wire compatible. What’s YugabyteDB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. In this post we’ll show you how to get DataGrip connected to a YugabyteDB cluster, use it to build a sample database, load it up with data and browse it. And because YugabyteDB is PostgreSQL compatible, getting DataGrip to work with a distributed SQL database is relatively simple.

DataGrip from JetBrains is a well-rounded, visual database tool that supports almost 20 SQL and NoSQL databases from a single interface. Whenever a query is executed, all information about the execution process and results can be found in the console at the bottom of your IDE.If you’re a database developer, you know the time saving value of an IDE in helping you create and navigate database objects, plus query and edit data from single UI. User-defined procedures and functions also will have information about parameters and return values that will be visible in autocompletion (and documentation!). It extracts information like:Īll this information becomes available for autocompletion while writing Cypher queries. When a data source for a Neo4j graph database is created, the plugin automatically retrieves the metadata of the database to make Cypher editing even more powerful than before. Run queries directly against desired data source.Benefit from the fact that the plugin knows that this editor is bound to a specific data source and enables several useful features (like EXPLAIN-based inspections).Note: The editor content is persisted across IDE restarts.

Write queries without creating extra files in a project.

While it’s quite simple, it allows you to:

Download datagrid jetbrains