Compatible Tools

gdotv

ArcadeDB is fully compatible with gdotv, so no particular configurations need to be made. The only requirement is loading the Gremlin plugin via the server setting:

"-Darcadedb.server.plugins=GremlinServer:com.arcadedb.server.gremlin.GremlinServerPlugin"
Details

On the title screen, create a new connection:

gdotv title

choose ArcadeDB from the list of graph database types:

gdotv type

enter the host name of the ArcadeDB server:

gdotv connect

and enter username and password:

gdotv credentials

In case of non-standard configurations of the server, under "Advanced Settings" more fine-grained settings can be made.

JetBrains DataGrip/Database Plugin

Connecting via JetBrains DataGrip database plugin is relatively straightforward. The introspection features aren’t working yet, but the basics seem to work well.

Details

To connect, create a new Postgres datasource and point it to the IP/port of your ArcadeDB server. (0.0.0.0:5432 by default) You will need to fill out the database field, or you’ll get an error on connection. At present, changing the current database requires editing the datasource.

jetbrains connection

Next, you’ll need to set preferQueryMode to simple on the Advanced tab, like this:

jetbrains querymode

You can then run queries via a console. Even non-SQL queries will work, though expect squigglies!

jetbrains queries

DBeaver

The universal database tool DBeaver has basic compatibility via the legacy Postgres connector.

Details

Create a new connection with the "PostgreSQL (Old)" driver:

dbeaver driver

Add your host, port, database, username and password to the general connection settings:

dbeaver settings

Set the preferQueryMode option to simple on "Driver Properties" tab:

dbeaver option1

Set the sslmode option to disable:

dbeaver option2

The "Finish" the connection wizard and double click the created connection to connect. Then with a right-click the SQL console can be started:

dbeaver console

Now the SQL console can be used to communicate via DBeaver with ArcadeDB.

Note that this is only a basic support using a generic relational driver for a NoSQL database, so various functionalities can result in errors.

DbVisualizer

The database client DbVisualizer can also be used via its PostgreSQL driver.

Details

Create a new connection and select "PostgreSQL":

dbvisualizer create

Enter server, port, database, userid, and password:

dbvisualizer connection

Go to the "Properties" tab and set preferQueryMode to simple:

dbvisualizer settings1

Also set sslmode to disable:

dbvisualizer settings2

After applying the changes and connecting the SQL commander is available:

dbvisualizer sqlcommander

DbGate

The SQL+noSQL database client DbGate is compatible via the PostgreSQL driver.

Details

Add a new connection of type PostgreSQL:

dbgate newconnection

Enter host, port, user, password, database, make sure to check "Use only database <db>", and connect:

dbgate settings

It seems the reported error can be ignored, so now new queries can be composed by:

dbgate newquery

LibreOffice Base

There is minimal support for ArcadeDB in LibreOffice Base via a PostgreSQL connection:

Details

Select "Connect to existing database" and choose "PostgreSQL"

libreoffice select

Enter the postgres protocol connection string (without username and password), for example: postgres://localhost:5432/dbname

libreoffice settings

Enter the user name and check that a password is required (try with the "Test Connection" button)

libreoffice authentication

Choose if you want to register the database in LibreOffice, select to open for editing, and "Finish" the wizard.

libreoffice proceed

Now, in the menu under "Tools" → "SQL…​" queries and commands can be send to ArcadeDB.

libreoffice execute

Make sure that "Run SQL command directly" is selected, and to view results check "Show output …​"