Tabloy

Appearance

Open Tabloy

Connect a database or API ​

Connect once in Sources, and every question in a chat with that source runs on the live data. Available on Pro and Pro+.

Engines ​

EngineWhat you need
PostgreSQLHost, port, database, user, password. Or a connection string.
MySQL (and MariaDB)Host, port, database, user, password. Or a connection string.
BigQueryA service account JSON, or a bigquery://project/dataset URI.
SnowflakeThe connection URI or JDBC string from Snowflake, including user and password. Account, warehouse, role and schema when the URI does not carry them.
REST APIA name, the base URL or a list endpoint, and a token. Docs or an OpenAPI file help but are optional.

Tabloy only reads. It never writes to your database.

Connect a database ​

  1. Open Sources in the sidebar and press Add source.
  2. Pick the engine and fill in the fields, or paste a connection string.
  3. Press Test and continue. Tabloy checks that it can connect.
  4. Choose tables: tick the tables you want to ask about. Fewer, well-chosen tables give better answers than the whole schema.
  5. Press Build profile. Tabloy reads the structure of the chosen tables and works out what each column means. This takes from a few seconds to a few minutes.

When the source says Ready, click it to start a chat with its tables attached.

The password is stored for the connection and erased when you delete the source.

Connect a REST API ​

Same steps, with REST API as the engine. Give it a name, the URL and the token; paste the OpenAPI spec, a cURL example or a short note about the API if you have one. Choose resources lists the endpoints Tabloy found; tick the ones to index. Tabloy builds a profile of the API the way it does for tables.

Ask ​

Ask the way you would ask a colleague who knows the database.

Try these requests

How many orders did we ship last week, by country?

Open in Tabloy

Which ten customers have the highest revenue this year, and how does that compare with last year?

Open in Tabloy

Show daily sign-ups for the last 30 days as a line chart

Open in Tabloy

Every answer shows the chart or the table behind it. The query runs on your database each time, so the numbers are current.

Where the source is attached ​

Press + → Attach Source in any chat, or start from Sources. One source per chat. See How data works in a chat.

If the connection fails ​

  • Every field is required, including the port (PostgreSQL is usually 5432, MySQL 3306).
  • The database must accept connections from the internet, or your admin must allow Tabloy's address. A database on your laptop or on an office network without a public address cannot be reached; use the Tabloy app for that.
  • Turn on SSL if your database requires it.
  • For BigQuery, the service account needs read access to the dataset.

Automations on live data ​

An automation with a source attached runs the query on every schedule: "every Monday, last week's sales by region". See Automations.