GremlinStudio

GremlinStudio is a desktop integrated development environment specifically designed to work with Azure Cosmos DB graph databases via the Gremlin API. It provides a comprehensive set of tools for writing, executing, and visualizing graph queries.

★★★★★

5.0(1 ratings)

• Query editor with syntax highlighting. The query editor is based on the Monaco component, the same one used by Visual Studio Code. It offers full syntax highlighting for the Gremlin language, intelligent autocompletion for steps and functions, as well as automatic code formatting to improve query readability.
• Interactive graph visualization with Sigma.js. Query results are graphically represented using the Sigma.js library, which implements the ForceAtlas2 layout algorithm. This visualization allows you to explore the graph structure, navigate nodes and edges, and interactively adjust the spatial arrangement of elements.
• Step-by-step query debugger. This feature allows you to execute a Gremlin query step by step, analyzing the data transformation at each stage. The debugger displays intermediate results, the traverser count, and the graph state after each step, facilitating the understanding and correction of complex queries.
• AI-powered natural language to Gremlin translation. GremlinStudio incorporates a module that translates natural language descriptions into executable Gremlin queries. To use this feature, the user must provide their own OpenAI API key, which enables automatic code generation from text.
• Visual creation of vertices and edges (WYSIWYG). The tool allows direct modification of graph data from the visualization canvas. Users can create new vertices by clicking on the canvas and establish relationships by drawing edges between existing nodes, following a "what you see is what you get" paradigm.
• Query cost visualization in request units (RU). For each query executed against Azure Cosmos DB, the application calculates and displays the exact number of Request Units consumed. This metric is essential for optimizing performance and controlling costs associated with database usage.
• Schema discovery panel. GremlinStudio analyzes the graph and presents a panel with the inferred schema. This panel shows all vertex and edge labels present in the database, as well as the properties associated with each type, allowing you to understand the graph structure without the need for manual queries.
• Query history with search and replay. The application maintains a chronological record of all executed queries. This history is fully searchable, allows filtering by content, and offers the ability to re-execute previous queries with a single click, facilitating iteration and retrospective analysis.
• Conditional style rules for nodes and edges. Users can define rules based on element properties to modify their appearance in the visualization. It is possible to change the color, size, or label of nodes, and the thickness or color of edges based on specific values of their attributes.
• Multi-tab editor and CSV export. The editing interface supports multiple tabs, each with its own independent state and query. Additionally, tabular query results can be exported to CSV format for subsequent analysis in other tools such as spreadsheets.

GremlinStudio began its development as a specialized solution for administrators and developers working with Azure Cosmos DB and its Gremlin API. The program is developed by a team of software engineers using TypeScript as the main programming language, supported by modern web technologies for its user interface. The application has been available since 2023 and is distributed as a native application for the Windows, macOS, and Linux operating systems.

Alternatives to GremlinStudio: