InfluxDB Studio is a UI management tool for the InfluxDB time series database.
InfluxDB Studio is a UI management tool for the InfluxDB time series database.
InfluxDB Studio is a UI management tool for the InfluxDB time series database.
Its inspiration comes from other similar database management tools such as SQL Server Management Studio and Robomongo. Under the hood it's powered by InfluxData.Net which is a portable InfluxDB client library for .NET (plus some Kapacitor support). InfluxDB Studio presently implements interfaces and workflows for most of the InfluxData.Net API.
The following are planned features that are not yet implemented in the current version:
Binary releases can be found here.
You can build locally by downloading the source or cloning the repository. Eventually some binary releases might be included with the repository going forward. To build, you will need Visual Studio 2015. Building with Mono might be possible with additional steps but it's not clear how usable it will be. The Mac OS X version definitely has some issues. For now, Windows is the recommended platform to use.
Open the solution file CymaticLabs.InfluxDB.sln to get started.
Upon running InfluxDBStudio.exe you will be prompted with the Manage Connections dialog. This window will let you create, edit, and delete InfluxDB server connections.
Press the Create button to add your first InfluxDB connection using the Connection Setting dialog.
Use the Connection Settings dialog to configure the details of the InfluxDB connection:
The Test button to lets you test the connection to InfluxDB using the provided connection details.
The Ping button lets you ping the InfluxDB server and check response time and server version.
Press the Save button to create or update the connection information.
Once you have created at least one connection, select it in the Manage Connections dialog and press the Connect buton.
After pressing the Connect button you will see the the main application window. The list of active connection(s) is located in the tree view to the left. This window is where perform most of your interactions with the various InfluxDB connections that you have chosen to connect to. You can launch the Manage Connections dialog again at any time by pressing the toolbar button in the top-left corner or by selecting from the application menu Connections → Manage.
Explore databases and measurements by using the tree view in the left panel.
Right-click when you have a Connection node selected in the tree view. You will see a context menu of available commands for the server. These commands are also available at the top of the application in the toolbar. Find the corresponding toolbar button by matching its icon to the context menu command.
The following connection commands are available:
To show connection diagnostics right-click or use the toolbar button to select the Show Diagnostics command:
The following commands are available from the Database context menu and toolbar buttons:
To create a database, select the Connection where you would like to create the database and select Create Database from the context menu or the toolbar button. Next provide the name for the database to create and press the Create button:
The created database should now appear in the tree view on the left:
To drop a database, select it in the tree view on the left. Then right-click or use the toolbar button and select Drop Database:
Confirm that you would like to drop the selected database (this is a permanent operation).
Select a database node in the tree view and either double-click, right-click, use the toolbar button, or select from the application menu Query → New to select the New Query command.
Press CTRL+R, the toolbar button, or select from the application menu Query → Run to run the query. Results will be displayed in the table area below:
Using aggregation (GROUP BY) in queries will group the series results into their own tabs in the results area:
The results of most query windows in InfluxDB Studio can be exported to file. Right-click in the results table and choose from the available export options. Data can be exported in either CSV or JSON format. Choosing Export All will export the entire set of returned rows to file. Alternatively you can export just the selected rows by using CTRL + Left Click and Shift + Left Click to select the rows you want to export and then choosing Export Selected in the export context menu.
Continious Queries run at an interval that you specify and are often used to downsample data by averaging it or processing it as it streams in and dumping the downsample data into a new measurement.
To create and manage Continuous Queries, right-click or use the toolbar button and select the Show Continuous Queries command.
Once the CQ tab opens, click the Create CQ button which will bring up the Create Continuous Query Dialog.
Use the dialog to design a new Continuous Query. Mouse over the help tool tips to learn more about the different form values.
Once you are satisified with your CQ press the Create button to create and run your query. You can verify that the CQ is working by running queries against its destination measurement and exploring the data:
Backfill Queries are similar to Continuous Queries in that they are typically used to process or downsample data from one measurement into another. The difference is that where as Continuous Queries run in realtime at a fixed interval and process incoming data inside a user-specified rolling time window, Backfill Queries are typically only run once on older measurment data that is already stored in the database and outside of the CQ time window.
For example: imagine that you decided you needed to start downsampling data that you've already been collecting for months. You could create a Continuous Query that would downsample the data every hour and average it on all new, incoming data. However since that would only begin downsampling new data, you might also consider running a Backfill Query on the older historic data so that all data becomes downsampled both backwards and forwards through time.
To run a Backfill Query either right-click or click the toolbar button and select Run Backfill. The Run Backfill Query Dialog will open:
Use the dialog to design a Backfill Query. Mouse over the help tool tips to learn more about the different form values.
Click the Run button when you are ready to run the backfill. Unless you receive an error message, the query has successfully run. Check to see that the data exists in the destination measurement as expected:
If you don't see any data or your destination measurement was not created check your time ranges to make sure the Backfill Query did not operate on an empty result set.
The following commands are available from the Measurement context menu and toolbar buttons:
No open issues yet, or sync has not completed.