This documentation describes the integration of MindsDB with Confluence, a popular collaboration and documentation tool developed by Atlassian. The integration allows MindsDB to access data from Confluence and enhance it with AI capabilities.

Prerequisites

Before proceeding, ensure the following prerequisites are met:

  1. Install MindsDB locally via Docker or Docker Desktop.

Connection

Establish a connection to Confluence from MindsDB by executing the following SQL command and providing its handler name as an engine.

CREATE DATABASE confluence_datasource
WITH
    ENGINE = 'confluence',
    PARAMETERS = {
        "api_base": "https://example.atlassian.net",
        "username": "john.doe@example.com",
        "password": "a1b2c3d4e5f6g7h8i9j0k1l2m3n4o5p6"
    };

Required connection parameters include the following:

  • api_base: The base URL for your Confluence instance/server.
  • username: The email address associated with your Confluence account.
  • password: The API token generated for your Confluence account.

Refer this guide for instructions on how to create API tokens for your account.

Usage

Retrieve data from a specified table by providing the integration and table names:

SELECT *
FROM confluence_datasource.table_name
LIMIT 10;

The above example utilize confluence_datasource as the datasource name, which is defined in the CREATE DATABASE command.

Supported Tables

  • spaces: The table containing information about the spaces in Confluence.
  • pages: The table containing information about the pages in Confluence.
  • blogposts: The table containing information about the blog posts in Confluence.
  • whiteboards: The table containing information about the whiteboards in Confluence.
  • databases: The table containing information about the databases in Confluence.
  • tasks: The table containing information about the tasks in Confluence.