Metabase

Metabase is a popular open-source BI tool known for its ease of use. It connects to ArcadeDB via the built-in PostgreSQL JDBC driver.

Setup

In Metabase, go to Settings > Admin > Databases > Add database.
Select PostgreSQL.
Enter the connection details:

Display name

ArcadeDB

Host

localhost

Port

5432

Database name

Your ArcadeDB database name

Username

Your ArcadeDB username

Password

Your ArcadeDB password
Expand Additional JDBC connection string options and add:
```
sslmode=disable
```
Click Save. Metabase will sync the schema.

Click + New > SQL query, select your ArcadeDB database, and write queries:

SELECT name, age FROM Person ORDER BY name LIMIT 50

Graph traversal via ArcadeDB SQL:

SELECT name, out('FriendOf').size() AS friendCount
FROM Person
WHERE out('FriendOf').size() > 2

Cypher via language prefix in native query mode:

{cypher}MATCH (p:Person)-[:FRIEND_OF]->(f:Person)
RETURN p.name AS person, f.name AS friend LIMIT 50

Metabase’s "Simple question" and "Custom question" builders show ArcadeDB types as tables with their properties as columns.

Schema sync may not discover all types or properties
The visual question builders work for basic queries but may have gaps for complex filter types
Language prefixes only work in native query mode, not the visual builders
Auto-generated queries from Metabase may occasionally use PostgreSQL-specific syntax that ArcadeDB does not support
SSL is not supported