Treeo Logo
Treeo

Documentation

Introduction

Welcome to the Treeo documentation! This page offers a clear overview of Treeo and its main strengths.
Treeo is a cloud-powered AI assistant that helps teams explore data, build dashboards, and share insights in minutes.

Getting Started

Follow these steps to begin using Treeo:

  1. Sign up with your email or a single sign-on provider (Ex: google).
  2. Create your first workspace to keep projects, boards, and users organised.
  3. Connect a data source by entering read-only credentials and pressing "test connection."
  4. Ask your first question in the chat box or open the visual builder to drag fields.
  5. Save the result as a chart and place it on a board.
  6. Invite teammates and assign roles so they can view or edit content.

Data Connections

Treeo connects to popular data platforms:

  • PostgreSQL
  • MySQL
  • Google BigQuery
  • Snowflake
  • Amazon Redshift
  • CSV or Parquet file upload

Connections use encrypted transport and credentials are stored with strong hashing. Treeo never reads or writes data outside the granted scope.

Querying Data

You can obtain answers in two flexible ways:

  • Natural language chat: Type a question such as "What was our total revenue last quarter?" and Treeo converts it to SQL automatically.
  • Visual query builder: Drag tables, choose columns, and add filters without writing code.

A full SQL editor is available for advanced users. Query history lets you rerun and favourite results at any time.

Visualizations

Turn any query into a chart with one click.
Supported chart types include:

  • Bar
  • Line
  • Pie
  • Area
  • Scatter

Resize, style, and label your charts in the side panel. Dashboards refresh in real time when data changes and can be exported as PNG or CSV.

API Reference

Use the public REST API to automate routine tasks.
Authentication

  • POST /api/auth/login
  • POST /api/auth/signup

Workspaces

  • GET /api/workspaces
  • POST /api/workspaces
  • GET /api/workspaces/[id]

Queries

  • POST /api/queries
  • GET /api/queries/[id]
  • POST /api/queries/[id]/execute

Metrics

  • GET /api/metrics
  • POST /api/metrics/[id]/calculate

All responses are JSON and protected with bearer tokens. See the developer portal for detailed schemas.