Clients and Tools
Spice supports a variety of clients and tools for querying data, including SQL clients, BI tools, and programmatic interfaces. Use these integrations to connect applications and dashboards to the Spice runtime.
Connection Protocols
Most SQL clients connect to Spice using one of the following protocols:
| Protocol | Endpoint | Best For |
|---|---|---|
| Arrow Flight SQL | grpc://localhost:50051 | High-performance data transfer, JDBC/ODBC drivers |
| HTTP | http://localhost:8090 | REST API calls, curl, web applications |
| ADBC | Flight SQL driver | Python and R data science workflows |
For programmatic access, see SDKs.
📄️ DBeaver
Configure DBeaver to query Spice via JDBC
📄️ JetBrains DataGrip
Configure JetBrains Datagrip to query Spice via JDBC
📄️ Apache Superset
Use Apache Superset to query and visualize datasets loaded in Spice.
📄️ Tableau
Use Tableau to to access, visualise and analyse datasets loaded in Spice.
📄️ Microsoft Power BI
Use Microsoft Power BI to access, visualize and analyze Spice datasets.
