Skip to main content
This documentation describes the integration of MindsDB with Jira, the #1 agile project management tool used by teams to plan, track, release and support world-class software with confidence. The integration allows MindsDB to access data from Jira and enhance it with AI capabilities.

​
Prerequisites

Before proceeding, ensure the following prerequisites are met:
  1. Install MindsDB locally via Docker or Docker Desktop.
  2. To connect Jira to MindsDB, install the required dependencies following this instruction.

​
Connection

Establish a connection to Jira from MindsDB by executing the following SQL command and providing its handler name as an engine. 
CREATE DATABASE jira_datasource
WITH
    ENGINE = 'jira',
    PARAMETERS = {
        "url": "https://example.atlassian.net",
        "username": "[email protected]",
        "api_token": "a1b2c3d4e5f6g7h8i9j0k1l2m3n4o5p6"
    };
Required connection parameters include the following:
  • url: The base URL for your Jira instance/server.
  • username: The email address associated with your Jira account.
  • api_token: The API token generated for your Jira account.
  • cloud: (Optional) Set to true for Jira Cloud or false for Jira Server. Defaults to true.
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 jira_datasource.table_name
LIMIT 10;
The above example utilize jira_datasource as the datasource name, which is defined in the CREATE DATABASE command.